Excel Forum

Errors in sample stock tracking spreadsheet

Derek Burks

New Member

Members

Forum Posts: 2

Member Since:
January 19, 2023

Offline

January 20, 2023 - 8:25 pm

Oops forgot to add the attachment. I have used the sample stock tracking sheet created by Mynda, and looked at the video a number of times. I have tried to amend the spreadsheet to reflect my stocks and funds spending many hours to sort it but to no avail. As can be seen on the attached file there are number of errors i.e. #Field; Spill! etc, is it possible for someone to sort my spreadsheet for me?

I am using the London Stock Exchange; I would like the currency in GBP, watchlist stocks to be Glencoe and British Telecom.

It appears that Funds are causing the problem, Mynda assures me the spreadsheet can handle funds

I would be extremely if someone could help me

Regards

Derek

See Answer

Catalin Bombea

Iasi, Romania

Admin

Forum Posts: 1824

Member Since:
November 8, 2013

Offline

January 23, 2023 - 7:33 pm

Hi Derek,
If you select the cell A7 where STOCKHISTORY formula is, it will highlight the SPILL range A7:F24. This range should not have any other content, but instead there are formulas in range: C15:F16 interfering with the STOCK formula.
Insert at least 4 columns between columns B and C, to allow STOCK formula to spill.