{"id":1151,"date":"2011-09-21T23:38:34","date_gmt":"2011-09-21T23:38:34","guid":{"rendered":"http:\/\/datafutures.net\/ecsi\/?page_id=1151"},"modified":"2013-06-21T17:19:14","modified_gmt":"2013-06-21T17:19:14","slug":"connect-csi-stock-data-to-trading-blox","status":"publish","type":"page","link":"https:\/\/www.csidata.com\/?page_id=1151","title":{"rendered":"Connect CSI Stock Data to Trading Blox"},"content":{"rendered":"

This process will setup UA with the sample stock data files, and set the preferences and options correctly for Trading Blox. You can then add and delete markets as necessary.<\/p>\n

Use the Portfolio\/Download Portfolio menu item in UA. Download the \u201cTradingBloxStocks\u201d portfolio. This will setup all the sample markets in a UA portfolio called \u201cstocks\u201d.
\n\"\"<\/a><\/p>\n

Making sure the \u201cStocks\u201d portfolio is selected, use the \u201cPortfolio\/Select All\u201d menu item to select all the markets so that they all turn blue.
\n\"\"<\/a><\/p>\n

Use the Portfolio\/Edit File Settings menu item to double check that the file settings are correct. These files and any new files you add must be ASCII file format.
\n\"\"<\/a><\/p>\n

Note that all the file settings need to be correct. They should be setup automatically by the stocks portfolio, but if they are not, then use the Portfolio Select All menu item, Portfolio Edit File Settings, ASCII Preferences button, Edit Portfolio Options, and then check the tabs as per the screen shots below. Rebuild all the files as necessary.
\n\"\"<\/a>
\n\"\"<\/a>
\n\"\"<\/a>
\n\"\"<\/a><\/p>\n

Use the \u201cPortfolio\/Rewrite File Immediately\u201d to create these data files.
\n\"\"<\/a><\/p>\n

Note the directory (third column in the listing is the directory) in which these files are located \u2013 probably C:\\ua\\Files\\Stocks.<\/p>\n

In Trading Blox preferences, set the Stock Data Folder to C:\\UA\\Files\\Stocks. Start by pressing the Stock Data button to bring up a folder explorer window.
\n\"\"<\/a><\/p>\n

Browse to the Stocks folder using the drop down menu to the right of Look In. Be sure to go into (double click into) the Stocks folder, rather than just highlight it.
\n\"\"<\/a><\/p>\n

So once selected, the screen should look like this. Now press Select.
\n\"\"<\/a><\/p>\n

The preferences screen should now look like this, with the Stock Data folder set to C:\\ua\\Files\\Stocks\\
\n\"\"<\/a><\/p>\n

In Trading Blox Edit\/Portfolio, create a new portfolio and add all the stocks you want to test. Note that the symbol will be the description and the exchange will be unkown. This is because there is no Stock Dictionary yet. But the File Name and Folder Location should be correct. You can now run a test using this new portfolio.
\n\"\"<\/a><\/p>\n

This is what the listing would look like if you create a Stock Dictionary:
\n\"\"<\/a><\/p>\n

To add new markets to this UA portfolio:<\/h5>\n

Select the \u201cStocks\u201d portfolio in UA
\nUse the \u201cPortfolio\/Insert File\u201d menu item to add a new market to the portfolio.
\nClick on the Markets button.
\n\"\"<\/a><\/p>\n

Check all the markets to include
\n\"\"<\/a><\/p>\n

Build the data files as necessary.<\/p>\n

Open Trading Blox and use the Portfolio Editor to add these new markets to a Trading Blox portfolio to use in testing.<\/p>\n

If you have problems, start by checking the data files in UA. Find the location of the data files (probably C:\\UA\\Files\\Stocks) and make sure the files are as expected. Symbol name with a .txt for all the markets you want.
\n\"\"<\/a><\/p>\n

Now open this file in Notepad to examine it. Make sure the start and end dates are as expected, and make sure the fields are comma delimited in the DOHLCVU format.
\n\"\"<\/a><\/p>\n

Now check that the Stock Data Folder in Trading Blox preferences is set correctly:
\n\"\"<\/a><\/p>\n

And check the Trading Blox Portfolio Editor to make sure the markets are in the portfolio as expected, and the file name and folder location are correct.
\n\"\"<\/a><\/p>\n

Now you can use this new Trading Blox portfolio called \u201cua stocks\u201d in your testing.<\/p>\n

Note that you have no stock dictionary yet, so the stock symbol is also the stock description, and the currency is assumed to be the system wide base currency of Trading Blox as set in preferences.<\/p>\n

To create the optional Stock Dictionary use the Build Stock Dictionary option in Trading Blox preferences. This will create a stock dictionary for the markets you have in your stock data folder. Note that if you add new markets to the stock data folder, they will not be available in Trading Blox until they have also been added to the Stock Dictionary, either manually or by running this process again. It\u2019s sometimes easier to not create the dictionary, so you can just add new markets to the data folder easily.
\n\"\"<\/a><\/p>\n

Here is how the Stock Dictionary will look in the Data\/Dictionaries folder. It is called StockInfo.csv.
\n\"\"<\/a><\/p>\n

And here is what it looks like if opened in excel:
\n\"\"<\/a><\/p>\n

And as an advanced topic, if you work with delisted stocks, or have non unique symbol names from different exchanges, you should export your CSI files using the CSI Number as the file name rather than the symbol. First delete all the files in the UA\\Files\\Stocks folder, so this rebuild will be a clean fresh list of files. Then check this box, and rebuild all your files.
\n\"\"<\/a><\/p>\n

The Trading Blox Portfolio Editor will now look like this, with the csi number as the symbol.
\n\"\"<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

This process will setup UA with the sample stock data files, and set the preferences and options correctly for Trading Blox. You can then add and delete markets as necessary. Use the Portfolio\/Download Portfolio menu item in UA. Download the \u201cTradingBloxStocks\u201d portfolio. This will setup all the sample markets in a UA portfolio called \u201cstocks\u201d. […]<\/p>\n","protected":false},"author":2,"featured_media":0,"parent":1136,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"footnotes":""},"_links":{"self":[{"href":"https:\/\/www.csidata.com\/index.php?rest_route=\/wp\/v2\/pages\/1151"}],"collection":[{"href":"https:\/\/www.csidata.com\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.csidata.com\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.csidata.com\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.csidata.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1151"}],"version-history":[{"count":9,"href":"https:\/\/www.csidata.com\/index.php?rest_route=\/wp\/v2\/pages\/1151\/revisions"}],"predecessor-version":[{"id":1162,"href":"https:\/\/www.csidata.com\/index.php?rest_route=\/wp\/v2\/pages\/1151\/revisions\/1162"}],"up":[{"embeddable":true,"href":"https:\/\/www.csidata.com\/index.php?rest_route=\/wp\/v2\/pages\/1136"}],"wp:attachment":[{"href":"https:\/\/www.csidata.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1151"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}