These instructions will explain how to configure the Ascii/Csv format in Bodhi6. If you do not have Bodhi6 installed on your computer, please refer to this tutorial: Installing Bodhi6.

The Ascii/Csv format includes user configurable fields. This can include trade (open, high, low, close, volume, gross and open interest) values and some fundamental data.

The fundamental data you download will depend on the type of securities you are following (i.e. Future or Equity etc.). The table below details the information you can choose:

Configurable Text Download Information
Please Note: some of the fundamental fields stopped being populated in December 2004
Trade Information - applicable to all security markets. This information is distributed to the individual security file (i.e. BHP.csv)
Symbol	The code used by the Exchange for the security (maximum 8 characters).
Date	The date this information was traded on.
Open	The opening price.
High	The highest price the symbol traded at.
Low	The lowest price the symbol traded at.
Close	The closing price.
Volume	The amount of shares that were traded.
Gross	The total value traded. (Volume x Amount paid)
Open Interest	The open interest price. (Applies to Future markets only and is not ticked by default)
Common Information - applicable to ASX only. This information is distributed to the Catalog file (!Catalog.csv)
Symbol	The code used by the Exchange for the security
Status	The current status of the security. A = Active; R = Rescinded/Expired; S = Suspended & Z = Zombie (this means the security is currently trading under a temporary code but will come back to this code soon.)
Called	The name of the security (BOQPA = Bank of QLD-Pref)
Family	The parent name of the security (BOQPA = Bk of Queensland)
Detail	The longer description of the security (this field is currently not populated)
Sector	The sector code this security belongs to (is not ticked by default)
Closed	The last closing price.
Issued	The number of shares/script on issue.
Listed	The first trade date of information contained in this Ascii/Csv database.
Ceased	The last trade date of information contained in this Ascii/Csv database.
Market	The market this security belongs to (E = Equity; D = Income; I = Indice; O = Option and W = Warrant).
Equity Information - applicable to the ASX equity market only. This information is distributed to the Catalog file (!catalog.csv)
Income	The amount derived from the provision of goods and services falling within the Company's ordinary activities, otherwise known as sales or turnover.
Earned	Earnings per share (EPS) is the amount of profit on ordinary activities, after tax and all other charges, that has been earned for each Ordinary share.
Assets	Everything that the Company owns at the end of the financial year, expressed in local currency.
Profit	The profit before tax figure taken from the Company Report.
Equity	The shareholders' interest in the Company.
Liable	The total debt figure of the Company expressed in Local Currency.
Dividend	Otherwise known as DPS. This is the cash amount paid in dividends to each ordinary shareholder for each share held for the financial year. DPS is often comprised of an interim plus a final dividend but may also include special dividends paid.
Beta	This refers to the sensitivity of the rate of return of a security to changes in the rate of return of the market.
Indice Information - applicable to the ASX index market only. This information is distributed to the Catalog file (!catalog.csv)
Starts	The earliest date on which data for the index is available.
Covers	Not currently populated.
Weight	The weighting factor that is applied to the constituent's price to determine its absolute weight. Absolute Weight = Weighting factor X Price. This calculation depends on the type of weighting system used in an index. For example, the FTSE 100 is market capitalisation weighted using shares in issue, while the DAX is market capitalisation weighted using a weighting factor.
Future Information - this information is distributed to the Catalog file (!catalog.csv)
Expiry	The date the contract will expire.
Units	Number of units per contract.
Size	Size of the contract
Option Information - applicable to the ASX option and warrant markets only. Distributed to the Catalog file (!catalog.csv)
Writer	The issuer of the Warrant or Option (eg. Macquarie Bank).
Method	The payment method used for this security. (eg. EN = Endowment etc.).
Priced	The closing price on the underlying security.
Expiry	The Expiry date of the security.
Strike	The Strike price of the security.
Styled	The exercise style of the security. (A = American; E = European; L = Event Linked and S = Schedule)
Basket	Type of securities included in this instrument. (Eg. Share, Index etc.)
Amount	Number of securities included in the basket.
Ratio	The Exercise ratio for Warrants.
Income Information - applicable to the ASX income market only. This information is distributed to the Catalog file (!catalog.csv)
Coupon	This is the interest paid at regular intervals by the issue to the holder. Normally expressed as a percentage per annum (Eg. 11.5%)
Mature	This is the maturity date.
Paying	This indicates the intervals the coupon is paid. (D = Daily; 52 = Weekly; 12 = Monthly; 06 = Bi-monthly; 04 = Quarterly; 01 = Yearly etc.)
Regime	This is a specific category for a government bond. (AUT = Commonwealth of Australia; UK = United Kingdom; GOVT = United States Government etc.)
Valued	This is the face value of the bond. Generally in Australia this is $100.
Issuer	This is the issuing organisation of the bond.

Configuring Bodhi6 for Ascii/Csv

1. Install Bodhi6 using the installation instructions.
2. Once installed, launch Bodhi6. If this didn't happen automatically when you finished installation click the Bodhi6 icon on your desktop or select it from your Windows® Start menu (Start ➔ Infosoft ➔ Bodhi6)
3. Enter your details including email address and computer name then click the OK button.

   
   Bodhi6 can be installed on 2 computers with the same Registration details so it is important to give them individual Machine names.

4. Click the Register button to add your registration details.

   

   If you haven't received these details, click the Contact button and phone the number on the screen.

   

5. Enter your registrations details provided by JustData. Connect to the Internet then click the OK button.

   

   Bodhi6 will fetch your registration key from the JustData server.

   

6. If you have entered the details correctly a window will appear saying you are Registered. Click OK to continue.

   

7. The analysis software screen will be displayed.

   

8. Select Microsoft Excel (CSV) and any other formats you require from the list of analysis software, then click [x]. By selecting Microsoft® Excel, Bodhi6 will automatically choose the AsciiCsv format.

   

9. Bodhi6 is now configured to download your chosen data into the software format/s you've selected.

   

10. If you have purchased historical data, choose Tool > History > Load from the menu. This may take a few hours depending on the speed of your Internet connection and processing power of your PC.

    

    If you are trialing the software you can download 6-months of history.
    1. Click the Configure button.

       

    2. The Configuration screen will appear displaying the exchanges you are registered to download.

       

    3. Using your mouse, right-click over the word Active to display the Reset option and select Received.

       

    4. The Received date box will appear. This will be automatically set to a date 6-months in the past. Click the OK button to download 6-months of data or change this date using the drop-down box.
       Please Note: you will not be able to download data earlier than this date.

         

    5. When you're satisfied with the date you have chosen, click the OK button.
    6. Exit the Configuration screen by clicking on the [x] button.
11. Click the Catchup button to get the current data.

    

    If you are trialing the software click the Close button to continue downloading data.
    *If your antivirus displays a message, you need to allow for Bodhi6 data to download.

You have successfully configured Bodhi6 and imported 6-months of data into a Ascii/Csv format (c:\Data\AsciiCsv\ASX directory). From now on, you will only need to press the Catchup button in Bodhi6 each night to retrieve the latest data. The free trial will run for 30-days after installation.

How do I configure the Ascii/Csv format?

1. Open Bodhi6.
2. Click the Configure button. Put a tick in AsciiCsv (if it isn't already selected).

   

3. Right-click on the word AsciiCsv. The Configure Ascii/Csv screen will appear.

   

4. A number of tabs may appear along the top of this screen. The Trade and Common tabs are standard, the other product tabs will only appear if you've ticked the Market box on the Common tab.

   

   The tabs displayed will depend on what data you have selected to download. If you are only downloading Equity and Index markets, only tabs for these two will appear.

   

5. Place a tick in the boxes next to the information you require for each market (refer to the table above for descriptions of the fields).

   

6. Now choose the Date Format you require. YYYYMMDD (20200930) is the default setting but if you would prefer to use the Microsoft® general number format, select this option. When opening these files in Microsoft Excel you can format a general number to any date format you require (i.e. DD-MMM-YY = 29-Sep-20)
7. If you require a Header in either the Catalog and/or Trade files, tick the appropriate box/es in the Include Headers section of the window. A header puts the names of each field at the top of the record.
8. If you require a Prefix or a Suffix, tick the required box in the Modify Symbol section then click the Edit button to create these.
9. Tick the Groups box if you want to download into Group directories.
10. Choose whether you want to use NONE; MSCI or GICS sectors from the drop-down box.
11. Choose whether you want your Ascii/Csv files comma or tab delineated.