Automatically create field names for columns in ASCII import

Automatically create field names for columns in ASCII import

Bryan Pettitt
2011-02-05 15:56:42

When doing an ASCII import using a csv file, is there a way to have it automatically create and fill in the field names?
I am importing 34 fields and it is very intensive to create the field names and then manually assign them to the columns.

QuantShare
2011-02-07 05:01:49

Yes it is possible.
In the parser settings form, click on "Pre-Script".

You can update field names (Parser columns) using the function "Content.SetDatabaseAndField".
If the database/field do not exist then it will be created.

Example:
The first line of the CSV data is:
Symbol;Date;PER;PEG;PS;PC

In the Pre-Script you can type:

PreScriptRow row = Content.Rows[0];
row.IsIgnoreLine = true;
int columnStarts = 2;
for(int i=columnStarts;iClose) for example.

Get more messages

No more messages

Back


Trading Items Industry and Sector Information for the US Stock Market Historical EOD data for Saudi stocks Put/Call Ratio for Individual Stocks EOD Data - End of day data for U.S. Stock Market Intraday Data for Major Stock Exchanges	How-to Lessons How to import trading data from CSV files How to automatically draw Fibonacci Retracement for each new stoc... How to quickly select stocks based on the last value of a databas... How to automatically arrange charts? How to create a watchlist
Related Forum Threads ASCII IMPORT -HOW CANCWE DELETE DATA FOR A WRONG DATE Need downloaded or ascii import of nse equities that trade in fut... Create and Export each database for each market ASCII Import Limitation Monthly/weekly summation for a custom database field	Blog Posts How to Automatically Import Local Data Into QuantShare Automatically create historical quotes charts How to Create Custom Metrics for Your Trading Positions Create custom metrics for the statistical data analysis tool Different Ticker Symbols for Each Data Source