Jump to content

RCHGetYahooQuotes down?


SnarkyPuppy
 Share

Recommended Posts

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

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

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

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

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

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

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

  • 2 weeks later...

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

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...