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
Anybody know of any software (Windows or Linux) that can track stock portfolios and display in real-time full screen?
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
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.
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!:).
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
You need to add quotation marks and the market, like so:
=GOOGLEFINANCE("NASDAQ:AMZN", "price")
Similarly, for other US stocks, like AT&T, youād want:
=GOOGLEFINANCE("NYSE:T", "price")
For UK-listed securities in pounds, eg the hedged iShares MSCI developed world ETF:
=GOOGLEFINANCE("LON:IWDG", "price")/100
Thanks guys - thatās sorted it
I use the Financial Times to update mutual funds. Example for Lifestrategy 80ā¦
=index(importhtml(CONCATENATE(āVanguard LifeStrategy 80% Equity Fund A Acc, GB00B4PQW151:GBP historical prices - FT.comā), ātableā, 1),2,5)
Just switch out the ISIN for your fund and it should do the trick.
Google Sheetās integration is great. Also, a bunch of analytics like this should be a feature in freetradeās app. One platform.
Has anyone figured out how to get data for how much dividends a stock will pay in google sheets? (UK Stock)
Hi, @finki is the man for this. Check out some of his posts, and the awesome services heās set up.
Head over to Welcome to FinKi and copy paste some of the examples into google sheets.
Any issues just message me
Thanks for the shoutout @mikesmart
Motley Fool. Itās not too bad. www.fool.com
Note you should be a paying customer (e.g. Stock Advisor) to get the most benefits.
Also, check out this young millionaireās blog post about how he used MF:
Hereās an example of a customisable āScore Cardā that you can use to track your portfolio:
And a News tab covering your favourite stocks: