Hi
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
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.
