(Sigh, my fix seems to have stopped working: Yahoo have probably changed something.)
Hey guys! Ive been planning to on creating a master spreadsheet for all my investments (stocks/real estate/crypto and so on) Would love to see what templates you guys using on yours, so if anyone keen to share their holding spreadsheet template would be very grateful.Thanks
1 Like
Hey 
youāre in luck, some of the community have shared their trackers here so Iāve moved your post over to keep all of the chat about this in one place.
Check them out & feel free to ask if you have any questions 
Itād be great to see what you come up with too!
I donāt track my investments via a dedicated tool, but rather use Tradingview to look at specific stocks. Having been a paying Bloomberg Terminal user a while back, I can tell you that the quality TV provides (for free) is simply amazing! I would love to see an integration into a future FT Webapp.
1 Like
Thereās also the option of REST API integration directly into TV. Not sure how this works with the batch orders on FT, but it would be amazing.
1 Like
Thatās another reason for us to build this [Feature Request š§] APIs for Accessing User Portfolio 
4 Likes
I tried using the spreadsheet provided in the discussion. However when I change the Stock indicator based on the ticker The spreadsheet shows the whole line as none. I guess something needs to be changed there.
Which ticker were you trying?
LON:TRIG / it did work but I get the prices wrong. If I divide the current price by 100. I get the true price. But my profit/loss is not displayed correcty. Thanks
Spreadsheet from the below site looks good
2 Likes
Anybody know of any software (Windows or Linux) that can track stock portfolios and display in real-time full screen?
1 Like
If you use windows 10 there are some trackers on the store.
How do you guys track crowd funding investments?
Is there an app that will allow me to manually add companies? Or is it just going to be spreadsheets?
Thanks
Spreadsheets but see also todayās Capdesk email thread which you can track your crowdfunded investments in if (a) they all use Capdesk and (b) it actually lets you log in.
What other ways to you like to get your stock news? I used to use Google Finance, but after their most recent update. Iām lost using itā¦
Is that your website? You always seem to link to it
2 Likes
Google sheets fans who havenāt been able to automatically grab the prices of UK mutual funds in the last year will be pleased to know that @christopher came up with a solution.
1 Like
As much as Iād like to claim credit, I nabbed the code from somewhere and altered it (Iām better at research than programming!:).
2 Likes
Ok, so I get that this isnāt the purpose of this forum, but I canāt seem to get GoogleFinance working in Sheets at all.
Even typing in something basic like the following is returning a āFormula Parse Errorā
=GOOGLEFINANCE(AMZN, āpriceā)
I feel silly asking, but canāt figure out what Im doing wrong!
`
Try quotes around AMZN
2 Likes