Donate to Remove ads

Got a credit card? use our Credit Card & Finance Calculators

Thanks to johnstevens77,Anonymous,MyNameIsUrl,6Tricia,staffordian, for Donating to support the site

Stepone Portfolio spreadsheet

Discussions regarding financial software
Bena48
Posts: 40
Joined: August 13th, 2017, 5:02 pm
Has thanked: 13 times
Been thanked: 5 times

Stepone Portfolio spreadsheet

#77368

Postby Bena48 » August 27th, 2017, 11:48 am

Hi
I am transferring my historical records to this spreadsheet. I was lucky enough to inherit some shares a while ago.

How should I record them? Thus far I have recorded them as a purchase on the day they were inherited because it provides some sort of benchmark however sometimes I feel that this an unduly harsh way of recording my good fortune.

Any suggestions will be much appreciated.

GPhelan
Posts: 36
Joined: November 11th, 2016, 7:25 pm
Has thanked: 1 time
Been thanked: 15 times

Re: Stepone Portfolio spreadsheet

#77379

Postby GPhelan » August 27th, 2017, 1:41 pm

Hello,
I was in this position a few years ago.
My view was that what mattered to me was the date and then value, that would apply should I need to calculate the gain for Capital Gains tax purposes when they are later sold.
There are three possible dates that could apply.
- Date of the death of the person leaving the shares
- Date that Probate was granted on that person's estate
- Date that the shares were recorded as transferred to my name

The HMRC summary information about CGT and inherited shares says the date of death applies, so that is what I used.
https://www.gov.uk/tax-property-money-s ... and-shares

I have subsequently sold some of them and used this value when computing my CGT liability and included the calculations in my Tax Return.

Bena48
Posts: 40
Joined: August 13th, 2017, 5:02 pm
Has thanked: 13 times
Been thanked: 5 times

Re: Stepone Portfolio spreadsheet

#78227

Postby Bena48 » August 31st, 2017, 5:03 pm

Just another naive question.

How does one record DRIP. As buy or dividend and buy?

scrumpyjack
Lemon Quarter
Posts: 2584
Joined: November 4th, 2016, 10:15 am
Has thanked: 234 times
Been thanked: 1167 times

Re: Stepone Portfolio spreadsheet

#78285

Postby scrumpyjack » August 31st, 2017, 9:00 pm

From a tax point of view it is a dividend and then an investment of that amount of cash in more shares

The dividend will be liable to income tax and the cost of the additional investment will then increase your acquisition cost of the total holding for capital gains tax purposes.

Bena48
Posts: 40
Joined: August 13th, 2017, 5:02 pm
Has thanked: 13 times
Been thanked: 5 times

Re: Stepone Portfolio spreadsheet

#79237

Postby Bena48 » September 4th, 2017, 10:00 pm

I have put all my historical data on now but the sheet does not seem to accept the Centrica epic.Any suggestions?

kiloran
Lemon Quarter
Posts: 3213
Joined: November 4th, 2016, 9:24 am
Has thanked: 2152 times
Been thanked: 1823 times

Re: Stepone Portfolio spreadsheet

#79248

Postby kiloran » September 4th, 2017, 11:03 pm

Bena48 wrote:I have put all my historical data on now but the sheet does not seem to accept the Centrica epic.Any suggestions?

CNA works fine for me.

What do you mean by "does not seem to accept"

--kiloran

Bena48
Posts: 40
Joined: August 13th, 2017, 5:02 pm
Has thanked: 13 times
Been thanked: 5 times

Re: Stepone Portfolio spreadsheet

#79250

Postby Bena48 » September 4th, 2017, 11:23 pm

The trades are entered as CNA. The cell changes it to CAN.CAN is entered on the current sheet. No current price is forthcoming when 'get prices' is activated.

The problem is that the cell in the trade sheet does not accept CNA .

Itsallaguess
Lemon Half
Posts: 7230
Joined: November 4th, 2016, 1:16 pm
Has thanked: 3273 times
Been thanked: 6481 times

Re: Stepone Portfolio spreadsheet

#79265

Postby Itsallaguess » September 5th, 2017, 4:50 am

Bena48 wrote:
The problem is that the cell in the trade sheet does not accept CNA


This is the auto-correct 'feature' of Excel getting in the way.

Go to -

Tools -> AutoCorrect

Find the entry that says 'Replace: cna With: can'

Delete it.

Cheers,

Itsallaguess

Bena48
Posts: 40
Joined: August 13th, 2017, 5:02 pm
Has thanked: 13 times
Been thanked: 5 times

Re: Stepone Portfolio spreadsheet

#79376

Postby Bena48 » September 5th, 2017, 3:46 pm

Thanks. You saved much head scratching

Bena48
Posts: 40
Joined: August 13th, 2017, 5:02 pm
Has thanked: 13 times
Been thanked: 5 times

Re: Stepone Portfolio spreadsheet

#94960

Postby Bena48 » November 11th, 2017, 3:46 pm

Hi

Are there plans to up date this spreadsheet? It is showing similar errors to Hyptus.

kiloran
Lemon Quarter
Posts: 3213
Joined: November 4th, 2016, 9:24 am
Has thanked: 2152 times
Been thanked: 1823 times

Re: Stepone Portfolio spreadsheet

#94969

Postby kiloran » November 11th, 2017, 4:06 pm

Bena48 wrote:Hi

Are there plans to up date this spreadsheet? It is showing similar errors to Hyptus.

Yes, it will definately be fixed. It'll just take time due to HYPTUSS issues and non-LMF things that are taking up my time

--kiloran

Bena48
Posts: 40
Joined: August 13th, 2017, 5:02 pm
Has thanked: 13 times
Been thanked: 5 times

Re: Stepone Portfolio spreadsheet

#102317

Postby Bena48 » December 7th, 2017, 6:10 am

Hi

Hate to nag but is there a time line for the repair of this sheet. I have a number of divi's queuing up to be recorded.

kiloran
Lemon Quarter
Posts: 3213
Joined: November 4th, 2016, 9:24 am
Has thanked: 2152 times
Been thanked: 1823 times

Re: Stepone Portfolio spreadsheet

#102581

Postby kiloran » December 7th, 2017, 8:02 pm

Bena48 wrote:Hi

Hate to nag but is there a time line for the repair of this sheet. I have a number of divi's queuing up to be recorded.

Don't worry about nagging :)

It's now been fixed. See viewtopic.php?f=27&t=8924

Sorry about the delay. We found a strange problem with Yahoo, and I've been away for the past week. StepOne has confirmed that the new version now appears to work OK, and if he's happy, I'm happy

--kiloran

Bena48
Posts: 40
Joined: August 13th, 2017, 5:02 pm
Has thanked: 13 times
Been thanked: 5 times

Re: Stepone Portfolio spreadsheet

#102590

Postby Bena48 » December 7th, 2017, 8:32 pm

Thanks. Fantastic.

Bena48
Posts: 40
Joined: August 13th, 2017, 5:02 pm
Has thanked: 13 times
Been thanked: 5 times

Re: Stepone Portfolio spreadsheet

#449916

Postby Bena48 » October 13th, 2021, 7:15 pm

Hi
A few shares are not updating namely BT,ICAP & AGR. Does anyone know of a quick fix?

kiloran
Lemon Quarter
Posts: 3213
Joined: November 4th, 2016, 9:24 am
Has thanked: 2152 times
Been thanked: 1823 times

Re: Stepone Portfolio spreadsheet

#449930

Postby kiloran » October 13th, 2021, 7:45 pm

Bena48 wrote:Hi
A few shares are not updating namely BT,ICAP & AGR. Does anyone know of a quick fix?

Looks OK to me. Using Windows 10, Excel 2016 and StepOne Portfolio v3-1

--kiloran


Return to “Financial Software - Discussion”

Who is online

Users browsing this forum: No registered users and 6 guests