These instructions will explain how to add or remove an export format. If you do not have BodhiGold installed on your computer, please refer to this tutorial: Installing BodhiGold
Information for all Users:
With BodhiGold you can use as many formats as you require. However, the more formats your choose the longer the software will take to export the days data.
Information for Previous BodhiGold Users:
If you have used the AsciiCsv format in previous versions of BodhiGold you will need to ensure that you configure it identically in this version. If you make any changes (i.e. you add or delete a field) you will need to purchase new history as BodhiGold will have Access Violation errors when trying to update the different formatted history. |
Information about adding or removing formats:
When you add a new format, BodhiGold will start updating from your next Catchup. If you have historical data in other formats that BodhiGold updates and you have the option: Copy history from another database if missing ticked in the Edit>Options>General tab, then the history from those formats will be added to the new format. If you don't have any other history or don't have this option turned on, you can still download 6-months of history using BodhiGold.
When you de-select (remove the tick from) a format in the BodhiGold menu, the data will cease updating that format from this time on. BodhiGold will not delete this data from your computer hard-drive. You will need to do this manually.
In this tutorial I'm going to show you how to select or de-select formats from the Configuration screen in BodhiGold. I'm also going to show you the hidden menu that has more advanced settings for the individual formats.
[+] Adding or Removing formats
[+] Setting advanced format options
Adding or Removing formats
- Open BodhiGold.
- Click on the Configure button. The Configuration screen will appear.
- In the Data Distribution section of the screen you will see two tabs.
The Native tab contains a list of formats that BodhiGold updates automatically. This means that BodhiGold writes directly to the format. If you have software that reads one of these formats then you only need to click the Catchup button and BodhiGold will do the rest.
The formats that are greyed out are older formats that have not been added to BodhiGold yet. If you use software that reads one of these formats contact our Help Desk to get them added.
The Import tab contains a list of formats that BodhiGold creates an import text file for. BodhiGold does not update the format directly but creates a daily file that can be imported into the software.
If you run your mouse over a format a tag will appear displaying the field order of the file. For example, in the image below the mouse is over the Indexia II format. It shows that the text file created will have the format: Time Date(20080924) Close High Low Open Volume Open_Interest
- Now that you know the difference between the Native and the Import tab you can make your selections. Either tick the box next to the formats you wish to export data to or remove the tick from the formats you don't wish to export data to.
Setting advanced format options
Once you've turned on a format you can now set some advanced options.
The Import formats only have one advanced feature. This is modifying the symbol by adding a Prefix or a Suffix. The Native formats have more options available. To find the advanced options:
- Open BodhiGold.
- Click on the Configure button. The Configuration screen will appear.
- Right-click over the format that you want to configure. This will display the options box for this format.
Note: Make sure you have a tick in the box next to this format or BodhiGold won't update it.
EzyStation; EzyChart & Market Analyst all have the same two options:
Modify Symbol with- This feature lets you add a prefix and/or suffix to all the symbols that trade on a particular exchange. This has been made available for two reasons:
- Some import file formats require it (i.e. OptionVue).
- It's an easy way to recognise stocks when loading multiple Exchange data into one database.
You activate this option by ticking Prefix or Suffix (or both) then clicking the Edit button. This will open your Word Processor and display a Prefix and Suffix heading. Enter the 3-letter Exchange code then an equals sign then the Prefix or Suffix you want added to the symbols in that Exchange.
Then exit [x] the Word Processer and Save the document.
Groups- If you tick this feature any sets you choose from the Groups screen will be downloaded. To read more information on this, refer to this tutorial: Updating a set group of stocks .
The BodhiOne format has the 'Modify Symbol with' and the 'Groups' option and also another option called Sector:
Sector- The Sector options lets you choose which sector classification you want to use in your format. You have the choice of either MSCI or GICS.
MSCI stands for 'Morgan Stanley Capital International' - this is the company that maintains this sector classification. It is a simple structure that classifies equities into 38 industry sectors.
GICS stands for 'Global Industry Classification Standard'. It is a newer classification method that was created by Standard & Poors (S&P) and Morgan Stanley. It reflects a more global industry group and sector structure and is made up of four levels. The first level classifies equities into 10 sectors, these 10 sectors comprise 24 industry groups. The industry groups break down further into 64 industries then 139 sub-industries.
The MetaStock format also has the 'Modify Symbol with' and the 'Groups' option as mentioned above. It also has another two options that are applicable to the MetaStock format only, these are called DirLimit and DopFiles:
DirLimit- Earlier versions of MetaStock used the Computrac format which was created in 1984 and could only update 255 symbols per directory. This format is open source and as such has been used by a variety of charting software companies (i.e. SuperCharts; TradeStation; Gannalyst etc.). Later versions of MetaStock were upgraded to include 2000 files per directory and the latest release can handle 6000.
| Version |
Symbols |
Software |
| 6.52 or lower |
255 |
MetaStock V6.52; SuperCharts; TradeStation & Gannalyst Lite |
| 7.* |
2000 |
MetaStock V7; GuppyTraders-Essentials |
| 8 or higher |
6000 |
MetaStock V8; 9 & 10 |
This default setting for this is 2000 but you will need to change it to the number your software reads. If you use MetaStock V7 and set the DirLimit to 6000 you will not be able to read the data in the directory.
Please Note: when your directories reach the number you've entered in the DirLimit box, BodhiGold automatically creates a new directory with a sequential number (i.e. c:\data\asx1 or asx2) so you don't lose any of your information.
DopFiles- These files were used with the early Computrac format and allowed the user to customise the data fields and scale factors for any security These files are no longer used in MetaStock. If you require them, simply tick this option.
The AsciiCsv format also has the 'Modify Symbol with' and the 'Groups' option as mentioned above (EzyStation) and the 'Sector' option mentioned in the BodhiOne format. However it is a completely customisable format that also has the following options:
Trade tab- The Trade tab contains the price fields that are updated daily. You simply need to tick the fields that you want added to your AsciiCsv files. The AsciiCsc format will create one file for each symbol you download and append daily data to each file.
Common tab- The Common tab contains extra information that may be available on each symbol. This information is written into a Catalog file that holds details on every symbol in the current folder.
Market tabs- The Market tabs only appear if you tick the Market box in the Common tab. Once ticked, tabs will appear for every market in BodhiGold (i.e. Equities; Indexes etc.). From these tabs you can then select more fundamental information (EPS; DPS, Assets, Beta etc.) to add to the Catalog file.
Date Format- You can choose between two date formats for your data files: YYYYMMDD or Microsoft.
YYYYMMDD is self-explanatory. Y stands for Year; M stands for Month & D stands for Date. Therefore the date 29/09/08 will be entered as 20080929.
The Microsoft date format is the number of days since January 1, 1900. Therefore, the date 01/01/1900 would display as 1 and the 29/09/2008 would display as 39720. This format is handy if you plan to import these files into other MicroSoft® software (i.e. Excel or Access) for further analysis.
Include Headers- Headers are simply the names given for the fields in the AsciiCsv files. The header names will be exactly as they are written in the tabs (i.e. Open, High, Low, Close etc.). If you want these headings in each file tick the appropriate box.
No catalogue entry when no trade- If you tick this option, symbols that don't trade will not be included in your AsciiCsv file.
Delineator- You have the choice of COMMA or TAB. If you choose Comma the fields will be separated by a comma (,) if you choose tab the fields will be separated by a tab space.
- Now that you know what options are available for each format, make your selections. These will be applied for every directory you make using that format.
|
