Glad you’ve resolved.
As @mikesmart said, UK stock prices are returned in pence, not pounds, so the /100 was a hack to change the units. Not the cleanest solution, but as far as I know GBP was the only currency with the problem.
2 Likes
Working a dream 
thanks
Morning all!
I’m trying to set up Yahoo finance to track a portfolio but I can’t seem to get it to work. Im sure its because I’ve entered a number incorrectly but for the life of me I cannot see where!
I’ve added some random sample data for the point of sharing, but as you can see my total shows £7k+ which is defonatly not right.
Here is how I have set up my holding:
Why on earth is the total so high? How do I correct this as the total of the shares I’ve ‘purchased’ is no more than £25 and I definatly havnt made £7k on top of that in 2 days 
1 Like
It looks like the ^FTSE is skewing it (as it is measured in pounds not pence and current price is £7,160). Try removing that and see if the others falls in line.
In Yahoo Finance, symbols starting with ^ represent an index. I presume you have bought a fund (e.g. ISF) that is tracking the FTSE, so updating to the specific instrument you are holding (which will have a different price) should bring it in line.
1 Like
Thanks @simran that makes perfect sense and has now brought everything in line!
@Freetrade_Team1 Is there scope to work with IFTTT for something like this?
An auto export of your portfolio to Google Sheets would be great, would totally automate all of this reporting and tracking. Currently managing it all manually, but something like Monzo’s collaboration allowing export of spending data would be ideal!
2 Likes
We’re definitely thinking about it, personally I’d love to have this kind of public API out just to see what kind of cool stuff (integrations) our users, and this community in particular, would come up with. But we need to be realistic, providing public/external access to internal data is hard work, even through a simple API, as it includes serious security considerations, and changes in which you must start designing and thinking about your data. Long story short, we clearly have other priorities right now, but it’s surely something we wanna do, in the longer term though 
6 Likes
I completely agree.
And this is no ‘but…’ or ‘however…’
I imagine you’re all working in some form of Agile methodology, which is great, it leads to a short release cycle that we’re all looking for, and asking for, with our ‘ideas’.
One of the issues I find with this methodology is that long term ‘ideas’ and goals are often overlooked for short-term wins (super cool, we all want those) which may leave you in a position of a hard-to-change system (obvious reference to the incumbent(s)). You may find yourself looking back at design decisions thinking ‘why on Earth did we do it that way?’ essentially closing the door on a really innovative new product.
No one can predict the future, and no system can be 100% future proof, (however/but) a public API could really be a game changer.
1 Like
That sounds like agile with weak/no product management, which could well result in a weak product, yep
2 Likes
(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