Donate to Remove ads

Got a credit card? use our Credit Card & Finance Calculators

Thanks to johnstevens77,Bhoddhisatva,scotia,Anonymous,Cornytiv34, for Donating to support the site

Download info into a spreadshhet

Discussions regarding financial software
Lynne
Posts: 2
Joined: November 19th, 2020, 11:20 am

Download info into a spreadshhet

#358044

Postby Lynne » November 19th, 2020, 11:23 am

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.

JohnB
Lemon Quarter
Posts: 2497
Joined: January 15th, 2017, 9:20 am
Has thanked: 677 times
Been thanked: 997 times

Re: Download info into a spreadshhet

#358045

Postby JohnB » November 19th, 2020, 11:33 am

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!

Lynne
Posts: 2
Joined: November 19th, 2020, 11:20 am

Re: Download info into a spreadshhet

#358050

Postby Lynne » November 19th, 2020, 11:43 am

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.

dealtn
Lemon Half
Posts: 6072
Joined: November 21st, 2016, 4:26 pm
Has thanked: 441 times
Been thanked: 2324 times

Re: Download info into a spreadshhet

#358058

Postby dealtn » November 19th, 2020, 11:58 am

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?

monabri
Lemon Half
Posts: 8396
Joined: January 7th, 2017, 9:56 am
Has thanked: 1539 times
Been thanked: 3428 times

Re: Download info into a spreadshhet

#358069

Postby monabri » November 19th, 2020, 12:28 pm

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

Itsallaguess
Lemon Half
Posts: 9129
Joined: November 4th, 2016, 1:16 pm
Has thanked: 4140 times
Been thanked: 10023 times

Re: Download info into a spreadshhet

#358072

Postby Itsallaguess » November 19th, 2020, 12:42 pm

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

kiloran
Lemon Quarter
Posts: 4092
Joined: November 4th, 2016, 9:24 am
Has thanked: 3234 times
Been thanked: 2827 times

Re: Download info into a spreadshhet

#358475

Postby kiloran » November 20th, 2020, 3:30 pm

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

dspp
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

#358602

Postby dspp » November 20th, 2020, 9:59 pm

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

PinkDalek
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

#358608

Postby PinkDalek » November 20th, 2020, 10:23 pm

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.

JohnB
Lemon Quarter
Posts: 2497
Joined: January 15th, 2017, 9:20 am
Has thanked: 677 times
Been thanked: 997 times

Re: Download info into a spreadshhet

#358612

Postby JohnB » November 20th, 2020, 10:46 pm

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.

kiloran
Lemon Quarter
Posts: 4092
Joined: November 4th, 2016, 9:24 am
Has thanked: 3234 times
Been thanked: 2827 times

Re: Download info into a spreadshhet

#358618

Postby kiloran » November 20th, 2020, 11:27 pm

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

kiloran
Lemon Quarter
Posts: 4092
Joined: November 4th, 2016, 9:24 am
Has thanked: 3234 times
Been thanked: 2827 times

Re: Download info into a spreadshhet

#358620

Postby kiloran » November 20th, 2020, 11:32 pm

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 3 guests