RCHGetYahooQuotes down?

[SnarkyPuppy]

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.

[oddballstocks]

https://news.ycombinator.com/item?id=15616880

[hillfronter83]

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.

[SnarkyPuppy]

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...

[gokou3]

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.

[Jurgis]

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.

[hillfronter83]

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.

[rukawa]

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

 

 

[rukawa]

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.

[thowed]

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.

[Jurgis]

Thank you, rukawa.

[gokou3]

Thank you hillfronter and rukawa.  Will try it out!  8)

[rukawa]

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.