Bloomberg feed nonfunctional

[tammer81]

Bloomberg feed nonfunctional

[brymck]

Are you using the latest version?

Bloomberg changed how they laid out their quotes, so for previous versions of the add-in that should be broken. The current version is 0.9.4.3. You can check that by entering =InstalledVersion() in a cell, or just updating to the current version.

[tammer81]

I am indeed; I upgraded just yesterday when I first noticed the error, but unfortunately the feed problem persists into the new version.

[tammer81]

To be more specific, for individual US-listed equities all I get are the Last and Open prices, while my formulas rely also on the day's Highs and Lows, which appear blank, and completely nonfunctional for US and international indices; in fact, Change appears as the negative of the actual change. For instance, yesterday 22 February 2012 the Dow and S&P closed down -27.02 and -4.55 respectively; in my spreadsheet they appear as having finished up +27.02 and +4.55.

[brymck]

Thanks for the info. I fixed the issue with the wrong sign displaying for changes. That occurred because Bloomberg removed minus signs from their quotes and I fixed everything last Thursday, when the market went gangbusters and everything was up. My mistake there.

As for the quotes, I also fixed another issue with highs and lows not displaying for indices. I tested it on several US equities (WFC, BAC, GS, some other banks I follow, and the A's in the S&P 500), indices (SPX:IND, INDU:IND, CCMP:IND), currencies (EURUSD:CUR, USDJPY:IND) and rates (US0003M:IND, USSWAP1:IND, JYSWAP1:IND) and got them working.

There is another possibility: an issue I've had with Excel's Real Time Data servers where they just give up, sometimes sticking at #WAIT. I still haven't been able to figure this one out, and it likely requires a good bit more knowledge about Excel's innards than I have. You might be able to diagnose this by completely closing Excel, then reopening it and creating a new spreadsheet with new formulas for the quotes you're looking for.

In any case, thanks for digging into this. If you're still having issues, could you provide me with some tickers you're having trouble pulling? The current version is 0.9.4.6.

[tammer81]

Everything appears to be working fine with indices now, thank you very much, but daily Highs and Lows for the following US-listed ETFs still appear blank: DBA, EEM, EFA, IAU, JJC, OIL, PHYS, PSLV, QQQ, SLV, UNG, USO, VNQ, XME, XOP.

[brymck]

Should be fixed now for 0.9.4.7. It's caused by the Bloomberg pages for the respective securities denoting high/low differently. For example:

WFC (an equity) Day's Range: 30.0200 - 30.6600

SPX (an index) Day Range: 1,363.46 - 1,368.92

DBA (an ETF) High - Low: 29.1000 - 28.9400 (note the order here also)

That's pretty ridiculous, so there may be other exceptions out there, but I'm hoping that's not the case.

[tammer81]

Unfortunately the problem persists through the latest iteration, with no daily Highs or Lows for any of the above tickers. In any case, I'm just going to stick with the Yahoo! quotes as they update in real-time anyway, and thank you for your diligence and careful concern.

[brymck]

Sure.

It might just be an issue with the RTD servers I mentioned, like needing to force recalc the sheet, completely close Excel, restart Windows, etc. I'm not sure. In any case, it is working for me in both Excel 2010 and 2003:

If you do revisit the problem a while later and it's still not working, feel free to let me know. In any case, thanks for the feedback. I wouldn't have noticed this issue as I didn't realize ETFs were a special case on Bloomberg.

[tammer81]

My mistake; I'd installed the latest version using the install.bat file, which apparently didn't take, but now that I've manually copied and pasted the .xll file manually into my AddIns folder everything appears to work fine with the Bloomberg feed. Thanks again.