How to bulk import instruments from a txt file |
ArthaChitra has a import feature which facilates user to append instrumnet from a txt file. This is helpful in case user is appneding a large number of instruments.
Please follow the below steps to import a Instrument.txt file into ArthaChitra
The instrument txt file is a text file separated by ';' (semi-colon - without the ')
The header format for the txt file will be:
@Name;@Description;@InstrumentType;@Exchange;@Currency;@TickSize;@SessionTemplate;@Rollover;@PointValue;@DefaultQuantity;@QuantityDivisor};@Adapter Symbols;@Dividends;@Splits
The below table further clarifies the fields.
Field | Type | Description |
---|---|---|
Name | Max length 255 | |
Description | Max length 255 | |
Instrument Type | ||
Exchange | ||
Currency | ||
Tick size | Tick size of the instrument | |
Session Template | Session Template | |
Rollover | String value (applicable for Futures scripts only) | |
Point value | Point value of the instrument | |
Default quantity | Default quantity | |
Quantity divisor | Quantity divisor - this is reserved from fractional shares | |
Connection symbols | Connection symbol separated by ',' (comma - without the ') | |
Dividends | Date-Amount (separated by ',' (comma - without the ') | |
Splits | Date-Factor (separated by ',' (comma without the ') |
Note: Entries begining with '#' (without the ') are treated as comments and will be ignored
An Instrument List is a text file separated by ';' (semi-colon without the ') having 3 (three) fields namely
An example will be:
@InstrumentList;Cash;^NIFTY NSE,BERGEPAINT NSE,ONGC NSE,RELIANCE NSE,TVSMOTOR NSE,BANKNIFTY 05 2022 NSE
Note: The Instrument names must conform the naming convensions as mentioned here