The Lemon Fool

What is the best way to download current and past prices into a spreadsheet so that it updates as soon as prices change?
I don’t mind whether it is google heats or excel.

I looked at Google Sheets with its GOOGLEFINANCE('GOOG') lookup function. It had lots of shares in different markets, and the Vanguard index tracking ETFs, but didn't have the Fidelity or Blackrock ones, so it was little use in the end. Other solutions seem like even harder work

I'd never quote the true scale of my holdings in an online spreadsheet. Always divide by 10!

Thanks for the reply. It is not to keep a track of my own investments. It is to look at individual shares in the ftse and compare fluctuations and other info etc.

Lynne wrote:Thanks for the reply. It is not to keep a track of my own investments. It is to look at individual shares in the ftse and compare fluctuations and other info etc.

Are you not trying to reinvent the wheel?

Why download and do it yourself if you can access that, or similar, that exists already on other sites?

HYPTUSS !

Available from the Lemon Fool....and it's a good price too at £0.00.

http://lemonfoolfinancialsoftware.weebl ... op-up.html

Screenshots

http://lemonfoolfinancialsoftware.weebl ... shots.html


I run 2 spreadsheets, my main "analysis sheet" which gets the prices from a separate HYPTUSS spreadsheet.

It takes a matter of seconds to obtain share prices , even for a large portfolio of say, 100 different shares, ITs, ETFs.

Note, there is an Excel version and a open source version for those who do not have Excel. There are also instruction manual ( mainly for background reading as HYPTUSS is easy to use).

And you have Fool backup !

viewforum.php?f=27

At £0.00 , it's a deal, it's a steal, it's sale of ...etc

monabri wrote:
There is also an instruction manual..

Bloody hell...

A live mention of the HYPTUSS instruction manual that's not embedded in a support thread...

2020 takes yet another strange turn...

:O)

Cheers,

Itsallaguess

Lynne wrote:What is the best way to download current and past prices into a spreadsheet so that it updates as soon as prices change?
I don’t mind whether it is google heats or excel.

Google Sheets is useful, though I don't think it updates prices as soon as they change (though that may be possible with a script). You can import prices from Google Sheets into Excel or LibreOffice, with prices updated every few minutes. See: http://lemonfoolfinancialsoftware.weebl ... price.html

Another alternative to get prices into Excel or LibreOffice is http://lemonfoolfinancialsoftware.weebl ... crape.html
However this does not automatically refresh. It could be done with a macro

Discussion of financial software is best discussed at the dedicated board: viewforum.php?f=27 [er, that is here, Mod]

Hope this helps

--kiloran

kiloran wrote:Discussion of financial software is best discussed at the dedicated board: viewforum.php?f=27 [er, that is here, Mod]

Hope this helps

--kiloran

Kiloran,

[er, that is here, Mod]

Did you have somewhere else in mind ?

Regards, dspp

I think the topic was originally at How do I invest (something like that) so it might have been moved before you got here. Presumably the Mods Logs will confirm.

The instructions in the pdf don't work for me when I get to the insert sheet from URL dialog on Linux. I paste in my URL or the one suggested, but hitting enter does nothing. The URL can be downloaded manually as a csv file.

dspp wrote:

kiloran wrote:Discussion of financial software is best discussed at the dedicated board: viewforum.php?f=27 [er, that is here, Mod]

Hope this helps

--kiloran

Kiloran,

[er, that is here, Mod]

Did you have somewhere else in mind ?

Regards, dspp

Hmmm.... when I saw the post it was on the "How do I Invest" board. And it still shows there, but clicking on the post now leads to the Financial Software board. I guess a mod has applied a bit of jiggerypokery

--kiloran

JohnB wrote:The instructions in the pdf don't work for me when I get to the insert sheet from URL dialog on Linux. I paste in my URL or the one suggested, but hitting enter does nothing. The URL can be downloaded manually as a csv file.

OK, I'll have a look at that (anything to distract me from talk of covid, Trump, Patel. etc )

--kiloran