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
Getting data from Bloombergs
-
- Contributor
- Posts: 2
- Joined: Mon Nov 08, 2010 10:47 am
Getting data from Bloombergs
- Attachments
-
- ERIC.txt
- (207.48 KiB) Downloaded 265 times
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.
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.
-
- Site Admin
- Posts: 9015
- Joined: Tue Apr 06, 2004 1:41 pm
- Location: Boston, MA
- Contact:
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.
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.
-
- Contributor
- Posts: 2
- Joined: Mon Nov 08, 2010 10:47 am