SnarkyPuppy Posted November 3, 2017 Share Posted November 3, 2017 Does anybody else use the excel add-in "RCHGetYahooQuotes" to pull quotes? Has worked flawlessly for a long time and just suddenly stopped this week - a quick google/twitter search doesn't highlight anything. Link to comment Share on other sites More sharing options...
oddballstocks Posted November 3, 2017 Share Posted November 3, 2017 https://news.ycombinator.com/item?id=15616880 Link to comment Share on other sites More sharing options...
hillfronter83 Posted November 3, 2017 Share Posted November 3, 2017 Does anybody else use the excel add-in "RCHGetYahooQuotes" to pull quotes? Has worked flawlessly for a long time and just suddenly stopped this week - a quick google/twitter search doesn't highlight anything. I switched to use Bloomberg site. It's not too hard if you know a little VBA programming. Link to comment Share on other sites More sharing options...
SnarkyPuppy Posted November 3, 2017 Author Share Posted November 3, 2017 Does anybody else use the excel add-in "RCHGetYahooQuotes" to pull quotes? Has worked flawlessly for a long time and just suddenly stopped this week - a quick google/twitter search doesn't highlight anything. I switched to use Bloomberg site. It's not too hard if you know a little VBA programming. I don't... do you have any resources / tutorials on this? I've built most of my personal account tracking using Yahoo's fubctionality... Link to comment Share on other sites More sharing options...
gokou3 Posted November 3, 2017 Share Posted November 3, 2017 Does anybody else use the excel add-in "RCHGetYahooQuotes" to pull quotes? Has worked flawlessly for a long time and just suddenly stopped this week - a quick google/twitter search doesn't highlight anything. I switched to use Bloomberg site. It's not too hard if you know a little VBA programming. I know Excel VBA... not sure if that is what you referred to? Do I need to be a Bloomberg paid subscriber? All I need is a function that allows me to input a stock symbol and get the last price as output. Link to comment Share on other sites More sharing options...
Jurgis Posted November 4, 2017 Share Posted November 4, 2017 Have you guys tried/used SMF addin? http://ogres-crypt.com/SMF/Install-the-addin.html Yeah, bunch of services are killing their APIs lately (Microsoft, Yahoo), but I believe this still has a ton of functioning sources. Especially for something as trivial as last price. I need a market cap and that's getting tough. There was time where there was no market cap data anymore through SMF. There's one functioning now, but not sure for how long. Link to comment Share on other sites More sharing options...
hillfronter83 Posted November 4, 2017 Share Posted November 4, 2017 Does anybody else use the excel add-in "RCHGetYahooQuotes" to pull quotes? Has worked flawlessly for a long time and just suddenly stopped this week - a quick google/twitter search doesn't highlight anything. I switched to use Bloomberg site. It's not too hard if you know a little VBA programming. I know Excel VBA... not sure if that is what you referred to? Do I need to be a Bloomberg paid subscriber? All I need is a function that allows me to input a stock symbol and get the last price as output. No subscription needed. Instead of grab data from yahoo, you get them from Bloomberg website with XMLHTTP in VBA. Link to comment Share on other sites More sharing options...
rukawa Posted November 4, 2017 Share Posted November 4, 2017 I know Excel VBA... not sure if that is what you referred to? Do I need to be a Bloomberg paid subscriber? All I need is a function that allows me to input a stock symbol and get the last price as output. My excel addin does that for you. See link below where I posted it. I''ve got documentation and examples. You should be able to figure it out pretty quickly. Excel addin Find the ticker at the Bloomberg site and then put it in getPrice and you will get the price. For example: =getPrice("7299:JP") will return 5120 which is the price obtained from this URL: https://www.bloomberg.com/quote/7299:JP Link to comment Share on other sites More sharing options...
rukawa Posted November 4, 2017 Share Posted November 4, 2017 I need a market cap and that's getting tough. There was time where there was no market cap data anymore through SMF. There's one functioning now, but not sure for how long. Added some market cap functionality. Try attached with formula: =getMarketCap("MSFT:US"). It should return 649,106,000,000.00. Link to comment Share on other sites More sharing options...
thowed Posted November 4, 2017 Share Posted November 4, 2017 This is very cool and useful - I'm surprised nobody replied to your OP. Great of you to share it. Sadly I use LibreOffice and Excel add-ins don't work with it. C'est la vie. Link to comment Share on other sites More sharing options...
Jurgis Posted November 5, 2017 Share Posted November 5, 2017 Thank you, rukawa. Link to comment Share on other sites More sharing options...
gokou3 Posted November 7, 2017 Share Posted November 7, 2017 Thank you hillfronter and rukawa. Will try it out! 8) Link to comment Share on other sites More sharing options...
rukawa Posted November 19, 2017 Share Posted November 19, 2017 I deleted my attachments is this thread with the mcap functionality as they no longer work since bloomberg changed their site. The other thread though has addin attachments that should work with the current bloomberg site. I'm not fixing the mcap functionality unless someone needs it. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now