Try hooking into Yahoo Finance here - the display format on Yahoo is slightly different for Shares and ETFs but for two of the examples on your sheet :
=ImportXML( âhttps://finance.yahoo.com/quote/NEX.L","//*[@id=âquote-summaryâ]//td[@data-test=âDIVIDEND_AND_YIELD-valueâ]â)
=ImportXML( âhttps://finance.yahoo.com/quote/STHS.L","//*[@id=âquote-summaryâ]//td[@data-test=âTD_YIELD-valueâ]â)
ETA : if cutting / pasting check the quote characters are correct.
Example sheet here
If that will not work, you could try WeBull app and add your portfolioâs relevant transactions with dates. It will fetch all related dividend yields for you, as well as reflect on them if you changed your positionsâ size or liquidated them. It does have UK stocks and ETFs too. Looks sort of like this (with a nice total at the bottom):
That looks gorgeous. Love a good spreadsheet
How have you set up to update every minute?
I use WeBull and its good.
Iâm also thinking of using Google script to parse Gmail inbox and update spreadsheet.
This way it would be broker agnostic, and can send email to myself with trade details incase broker doesnât.
At the moment I have something basic working to parse IB emails.
If time permits Iâll start expand it to track portfolio.
For Google Sheets fans with UK mutual funds in their portfolio, hereâs a way your spreadsheet can grab the recent prices from Yahoo finance. (The work of @simran , @Jim_mcgrain , others and this and got me there, thanks.)
=iferror(index(IMPORTHTML(âSymbol Lookup from Yahoo Financeâ,1),1,2))
is the formula which grabs the price (currently it is the previous close, not the current price, but thatâs fine for me because mutual funds are priced once a day I think. The formula tries a couple of times because Sheets sometimes fails the first time it tries to get the price.)
And cell A7 contains the fundâs ISIN code with .L appended. So eg for Vanguard Lifestrategy 80, A7 would contain GB00B4PQW151.L
Iâm happy to get involved from a product perspective. Iâve spent most of my career building solutions for investors 
I can help with coding, but Iâm not a proper developer any more!
Thanks very much 
âOnce a developer, always a developerâ. Cannot remember who said that, probably Marcus Aurelius 
Build what, in particular? Much of the discussion in this thread has been around a spreadsheet that tracks the performance of your investments. Are you thinking it would be nice if there were an app that did this? And you donât think that app should be Freetrade?
Agree with you there. There will be further improvements so might be best to wait and see what they come up with in app first.
I would love to see this in Freetrade.
I see this more as a stop-gap whilst the team focus on the most critical features. Once the roadmap is public, weâll know which features are lined up next (and those out of scope), but I assume there will be still be a window where we donât have coverage of all stocks, curated portfolio risk and performance metrics.
Whilst a spreadsheet can definitely do the job, I know I would find a tool useful (and Iâm sure others could too). Whether that tool is an improved spreadsheet, a webpage or an app would be open for discussion.
I think you need to multiply the cell with this:
GOOGLEFINANCE(âCURRENCY:USDGBPâ)
might have a typo as typing this on a phone
Have you tried this
=GOOGLEFINANCE(A15) * GOOGLEFINANCE(âCURRENCY:USDGBPâ)
Works for me:
@PigeonStrangler that is an awesome piece of work. Iâm going to try and build mine today too. Get back in to work mode ish by diving into a nice spreadsheet 
Can you share your spreadsheet please.
Think I cracked most of it yesterday thanks alot for the offer. Havenât got the hang of bringing in any divi info though so would be manual for now
I know its been mentioned above but Iâd really like to create a portfolio value chart into my Google sheet, anybody successfully managed this?
