Got a credit card? use our Credit Card & Finance Calculators
Thanks to eyeball08,Wondergirly,bofh,johnstevens77,Bhoddhisatva, for Donating to support the site
Download info into a spreadshhet
-
- Posts: 2
- Joined: November 19th, 2020, 11:20 am
Download info into a spreadshhet
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 don’t mind whether it is google heats or excel.
-
- Lemon Quarter
- Posts: 2505
- Joined: January 15th, 2017, 9:20 am
- Has thanked: 689 times
- Been thanked: 1005 times
Re: Download info into a spreadshhet
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!
I'd never quote the true scale of my holdings in an online spreadsheet. Always divide by 10!
-
- Posts: 2
- Joined: November 19th, 2020, 11:20 am
Re: Download info into a spreadshhet
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.
-
- Lemon Half
- Posts: 6091
- Joined: November 21st, 2016, 4:26 pm
- Has thanked: 442 times
- Been thanked: 2338 times
Re: Download info into a spreadshhet
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?
-
- Lemon Half
- Posts: 8418
- Joined: January 7th, 2017, 9:56 am
- Has thanked: 1547 times
- Been thanked: 3439 times
Re: Download info into a spreadshhet
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
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
-
- Lemon Half
- Posts: 9129
- Joined: November 4th, 2016, 1:16 pm
- Has thanked: 4140 times
- Been thanked: 10025 times
Re: Download info into a spreadshhet
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
-
- Lemon Quarter
- Posts: 4111
- Joined: November 4th, 2016, 9:24 am
- Has thanked: 3244 times
- Been thanked: 2850 times
Re: Download info into a spreadshhet
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
-
- Lemon Half
- Posts: 5884
- Joined: November 4th, 2016, 10:53 am
- Has thanked: 5825 times
- Been thanked: 2127 times
Re: Download info into a spreadshhet
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
-
- Lemon Half
- Posts: 6139
- Joined: November 4th, 2016, 1:12 pm
- Has thanked: 1589 times
- Been thanked: 1801 times
Re: Download info into a spreadshhet
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.
-
- Lemon Quarter
- Posts: 2505
- Joined: January 15th, 2017, 9:20 am
- Has thanked: 689 times
- Been thanked: 1005 times
Re: Download info into a spreadshhet
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.
-
- Lemon Quarter
- Posts: 4111
- Joined: November 4th, 2016, 9:24 am
- Has thanked: 3244 times
- Been thanked: 2850 times
Re: Download info into a spreadshhet
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
-
- Lemon Quarter
- Posts: 4111
- Joined: November 4th, 2016, 9:24 am
- Has thanked: 3244 times
- Been thanked: 2850 times
Re: Download info into a spreadshhet
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
Return to “Financial Software - Discussion”
Who is online
Users browsing this forum: No registered users and 29 guests