We’d like to remind Forumites to please avoid political debate on the Forum.
This is to keep it a safe and useful space for MoneySaving discussions. Threads that are – or become – political in nature may be removed in line with the Forum’s rules. Thank you for your understanding.
The MSE Forum Team would like to wish you all a very Happy New Year. However, we know this time of year can be difficult for some. If you're struggling during the festive period, here's a list of organisations that might be able to help
📨 Have you signed up to the Forum's new Email Digest yet? Get a selection of trending threads sent straight to your inbox daily, weekly or monthly!
Has MSE helped you to save or reclaim money this year? Share your 2025 MoneySaving success stories!
Share prices, company info and software
makemdano
Posts: 78 Forumite
I've been looking for free/cheap software that could take some of the effort out of assessing potential shares to invest in. There doesn't seem to be anything suitable so I'm using a combination of Excel and Access (2010) which helps but I'm having difficulty solving the problem of laboriously manually updating share prices, PE ratios etc. etc. I asked my broker if they had anything to assist... they don't. I wondered if anyone could point me to a site that quotes prices and company data that I can put a URL link into a spreadsheet so that I can do an auto update? "Semi real time" would be great (but expensive I guess) so end of day prices would do as a start
0
Comments
-
With excel I use the SMF Add In, links to prices on yahoo finance.
Example of the addin function:-
Last Trade Price =RCHGetYahooQuotes("BT-A.L","l1")
Yield =RCHGetYahooQuotes("BT-A.L","y")0 -
If you can use VBA then you can use web queries to get whatever you want. I don't know of anything currently available commercially that is set up ready to go.Faith, hope, charity, these three; but the greatest of these is charity.0
-
You might find some useful info in this thread started by ironwolf a couple of weeks ago.
https://forums.moneysavingexpert.com/discussion/48109010 -
Sorry for resurrecting an old thread. This works a treat:-Example of the addin function:-
Last Trade Price =RCHGetYahooQuotes("BT-A.L","l1")
Should it also work for *fund* prices if I get the ticker symbol correct?
e.g. I tried =RCHGetYahooQuotes("GB0003879185.L","l1") for Fidelity SE Asia (https://uk.finance.yahoo.com/q?s=GB0003879185.L) without success.
Haven't studied the smf_addin documentation as yet - all may become clear when I do so.0 -
Sorry for resurrecting an old thread. This works a treat:-
Should it also work for *fund* prices if I get the ticker symbol correct?
e.g. I tried =RCHGetYahooQuotes("GB0003879185.L","l1") for Fidelity SE Asia (https://uk.finance.yahoo.com/q?s=GB0003879185.L) without success.
Haven't studied the smf_addin documentation as yet - all may become clear when I do so.
Don't seem to get anything out of that function, can get some date for you ticker using the RCHGetYahooHistory function0
This discussion has been closed.
Confirm your email address to Create Threads and Reply
Categories
- All Categories
- 353K Banking & Borrowing
- 253.9K Reduce Debt & Boost Income
- 454.8K Spending & Discounts
- 246.1K Work, Benefits & Business
- 602.2K Mortgages, Homes & Bills
- 177.8K Life & Family
- 260K Travel & Transport
- 1.5M Hobbies & Leisure
- 16K Discuss & Feedback
- 37.7K Read-Only Boards