Getting data from Bloombergs

Use this forum to discuss data providers like CSI, charting, or other non testing software.
Post Reply
fmelin22344
Contributor
Contributor
Posts: 2
Joined: Mon Nov 08, 2010 10:47 am

Getting data from Bloombergs

Post by fmelin22344 » Wed Nov 24, 2010 11:34 am

Hi! I am a new trading blox user. I wish to extract market data from Bloombergs. I have tried to export price data and create text files but it doesn´t seem to work. Do you know if the data is separated with tab or "," only? I have the same format as Trading Blox has described. (Date, Open, High, Low, Close, Volume for equities). I have separed it with ",".
Maybe there is a better way to extract from Bloombergs. Any ideas?
I have also added the stock in the "stockinfo.txt" file.

Regards,
Fredrik
Attachments
ERIC.txt
(207.48 KiB) Downloaded 117 times

stamo
Roundtable Knight
Roundtable Knight
Posts: 522
Joined: Tue Mar 13, 2007 5:27 pm

Post by stamo » Wed Nov 24, 2010 12:10 pm

I'd check (1) the file name (2) the data layout & (3) Preferences.

From the latest User's Guide p.120 --

(1) Stocks: The stock files must be named SYMBOL.TXT or SYMBOL.CSV where SYMBOL is the symbol of the stock. For example, a file name for AAPL needs to be AAPL.CSV or AAPL.TXT and the file name for MSFT needs to be MSFT.TXT or MSFT.CSV.

(2) For ASCII format, the files must be comma delimited. Also be sure the dates are in sequential order from earliest date to latest date."



(3) Then I'd go to Preferences and make sure you are pointing to your data directory & rebuild the Dictionary.

If it works, you can go to Portfolio Editor (F2) and "see" your data files.

Tim Arnold
Site Admin
Site Admin
Posts: 8500
Joined: Tue Apr 06, 2004 1:41 pm
Location: Boston, MA
Contact:

Post by Tim Arnold » Wed Nov 24, 2010 12:30 pm

This file looks fine. If you just delete the stockinfo file for now, Trading Blox will load up all text files and create a market with the symbol "erik" in this case.

Then later you could add back the stockinfo file if you need a stock description or currency, etc.

Also add the stock to a portfolio in order to test with it.

fmelin22344
Contributor
Contributor
Posts: 2
Joined: Mon Nov 08, 2010 10:47 am

Post by fmelin22344 » Thu Nov 25, 2010 4:06 am

Thanks for your advise. I will have a look at it. Do you know anyone who is using Bloomberg data?
Regards,
Fredrik

Post Reply