NexusFi: Find Your Edge


Home Menu

 





TRADESTATION CSI DATA HELP


Discussion in EasyLanguage Programming

Updated
      Top Posters
    1. looks_one Gann Trader with 7 posts (1 thanks)
    2. looks_two Lampert with 3 posts (3 thanks)
    3. looks_3 cbritton with 1 posts (1 thanks)
    4. looks_4 Quick Summary with 1 posts (0 thanks)
    1. trending_up 4,160 views
    2. thumb_up 5 thanks given
    3. group 1 followers
    1. forum 11 posts
    2. attach_file 0 attachments




 
Search this Thread

TRADESTATION CSI DATA HELP

(login for full post details)
  #1 (permalink)
Gann Trader
New York, USA
 
Posts: 22 since Jan 2012
Thanks Given: 9
Thanks Received: 2

I hope I am not posting in the wrong thread but I need help formatting some 3rd party data for TS

I would like to exclude the last 2 lines in this data sample . I am aware that the instructions has to be written in the attributes folder and that ( ,, ) needs to be written on the header line, but I am not sure how to do it correctly. Below in my sample data you will see there are 9 columns of data, representing
date open high Low close, volume open interest, I would like to exclude the last 2 columns

199503,461.45000000

I can delete them using Excel, but I wanted to know if there was a easier way using either the attribute folder, or including some instructions in the header line within the data

date open high Low close, volume open interest
19950103,821.75000000,822 .50000000,820.75000000,82 2.00000000, 48984, 211544,199503,461.45000000

THANKS VERY MUCH

Reply With Quote

Can you help answer these questions
from other members on NexusFi?
Trader Dale [email protected] or Scammer Dale
Trading Reviews and Vendors
Request for MACD with option to use different MAs for fa …
NinjaTrader
The space time continuum and the dynamics of a financial …
Emini and Emicro Index
NT7 Indicator Script Troubleshooting - Camarilla Pivots
NinjaTrader
 
Best Threads (Most Thanked)
in the last 7 days on NexusFi
Tao te Trade: way of the WLD
30 thanks
Supertradersams Thread Journal on NQ/MNQ
25 thanks
Deaddogs Stock Trading
23 thanks
GFIs1 1 DAX trade per day journal
22 thanks
Daytrading ES & NQ
13 thanks

(login for full post details)
  #3 (permalink)
 
cbritton's Avatar
 cbritton 
Atlanta, Georgia
 
Experience: Intermediate
Platform: NT
Broker: DDT
Trading: ZN, ZB
Posts: 230 since Mar 2010
Thanks Given: 152
Thanks Received: 256


If you want to exclude those last two columns from every line, then awk ( AWK - Wikipedia, the free encyclopedia) is the best command line tool to do the job. There are versions for windows that will work.

Regards,
-C

“Strategy without tactics is the slowest route to victory. Tactics without strategy is the noise before defeat.” - Sun Tzu
Reply With Quote
The following user says Thank You to cbritton for this post:
(login for full post details)
  #4 (permalink)
Gann Trader
New York, USA
 
Posts: 22 since Jan 2012
Thanks Given: 9
Thanks Received: 2

Thanks very much for your advise, I will look into implementing your idea

Reply With Quote
(login for full post details)
  #5 (permalink)
Gann Trader
New York, USA
 
Posts: 22 since Jan 2012
Thanks Given: 9
Thanks Received: 2

I just reviewed the details on the website, but since I am not a programmer, I will not be able to follow those instructions. I am sure that there must be a easier way to accomplish this task. The instructions in the Tradestation manual reads.

"Consecutive delimiters allow fields to be omitted from individual lines of data. In other words, if a header reads: 'Symbol', 'Category','Exchange','Description','PriceScale', you would have a data line that looks like this: MSFT, Stock, Nasdaq ,, 1/100. This would allow you to omit the entry for the Description. This can be done for any field or for multiple fields."

So it appears that a double comma (,,) has to be included, but I am not exactly sure how to do this, I have been experimenting but it has not worked yet so far

Reply With Quote
(login for full post details)
  #6 (permalink)
 
Lampert's Avatar
 Lampert 
Calgary, Canada
 
Experience: Intermediate
Platform: Multicharts
Broker: IB, IQFeed
Trading: GC
Posts: 76 since Nov 2011
Thanks Given: 73
Thanks Received: 142

GT - I don't think the double comma will work because it is intended for the data rows, not the header row.

I think that if you just add two more field names called "Other", then the data should work. In other words, the header row and one row of data would look like this:
"Date","Open","High","Low","Close","Volume","Openint","Other","Other"
19950103,821.75000000,822 .50000000,820.75000000,822.00000000,48984,211544,199503,461.45000000
Here are links to the guidelines for using ASCII data in Tradestation. If you have a lot of data files, you can put the header row in a "parameter file" to be used by all the data files. This would eliminate the need to add a header row to each data file. But I have never tried this approach.
ASCII 3rd Party Data Guidelines

Field Order - 3rd Party Data
Len

Reply With Quote
The following user says Thank You to Lampert for this post:
(login for full post details)
  #7 (permalink)
Gann Trader
New York, USA
 
Posts: 22 since Jan 2012
Thanks Given: 9
Thanks Received: 2

hi Lampert
Thanks a million times, you are the absolute BEST, you are an absolute Genius, I will implement your idea and yes I have a lot of data files 10 years for each commodity. I dont quite understand what you meant by placing this information in a header instead of placing it in each commodity file, but I will start by trying it with one data folder first, hopefully it will also remove those extra zeroes or perhaps it does not matter

Reply With Quote
(login for full post details)
  #8 (permalink)
Gann Trader
New York, USA
 
Posts: 22 since Jan 2012
Thanks Given: 9
Thanks Received: 2

hi Lampert
I took your advise and tried the header as you suggested but the data is not appearing properly on the chart, I am not sure if its because of the extra zeroes in the price data

Reply With Quote
(login for full post details)
  #9 (permalink)
Gann Trader
New York, USA
 
Posts: 22 since Jan 2012
Thanks Given: 9
Thanks Received: 2

Hi Lampert
Great news, it works, I just had to write some instructions to the CAL folder regarding the exchange, thanks for your help

Reply With Quote
The following user says Thank You to Gann Trader for this post:
(login for full post details)
  #10 (permalink)
 
Lampert's Avatar
 Lampert 
Calgary, Canada
 
Experience: Intermediate
Platform: Multicharts
Broker: IB, IQFeed
Trading: GC
Posts: 76 since Nov 2011
Thanks Given: 73
Thanks Received: 142


GT - Glad to hear that you got it to work. PS - the zeroes should not make any difference.


Len

Reply With Quote
The following user says Thank You to Lampert for this post:





Last Updated on March 27, 2012


© 2024 NexusFi™, s.a., All Rights Reserved.
Av Ricardo J. Alfaro, Century Tower, Panama City, Panama, Ph: +507 833-9432 (Panama and Intl), +1 888-312-3001 (USA and Canada)
All information is for educational use only and is not investment advice. There is a substantial risk of loss in trading commodity futures, stocks, options and foreign exchange products. Past performance is not indicative of future results.
About Us - Contact Us - Site Rules, Acceptable Use, and Terms and Conditions - Privacy Policy - Downloads - Top
no new posts