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

An alternative price source to Yahoo

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

An alternative price source to Yahoo

#224750

Postby kiloran » May 27th, 2019, 2:20 pm

Most investment tools and spreadsheets use Yahoo as a source of share price. It's very rapid and can handle hundreds of shares with a single query. Generally, it works very well, but when it has a problem with one or more shares, we tend to get very frustrated.
Data can be obtained from many other web pages, but this tends to be complicated and much slower, since a separate query is needed for each share.

Google can handle multiple shares with a single query, using a Google Docs spreadsheet and the GoogleFinance function, but many/most investors prefer to have the data in a "real" spreadsheet such as Excel or LibreOffice.

Here's a solution which imports and automatically refreshes data from Google Docs to Excel or LibreOffice. Once the data is in Excel or LibreOffice, prices can be extracted to other sheets using VLOOKUP or INDEX/MATCH functions

I hope you find it useful, either as a main tool or as a backup to Yahoo

http://lemonfoolfinancialsoftware.weebl ... price.html

--kiloran

Return to “Financial Software - Discussion”

Who is online

Users browsing this forum: No registered users and 10 guests