OHLC Data for downloading to Excel.csv

November 20th, 2009, 02:20 PM

Mike, your forum is amazing. This morning I decided to try to export data from NT into text files so I could work on coding simple patterns into TS in order to do easy P-L analysis. I find the NT strategy writing and analysis interface too hard at this point.

So I managed to get your strategy to output fine after a few hiccups, but now want to now how to get it to first erase all previous data and then append in the new run. I've been on the MS C+ area but just can't understand anything there. I've managed to delete the file but then it only prints out one line.

If you could show me how to write that out properly would be much appreciated.

November 20th, 2009, 02:39 PM

Something like this:

Code

                            
        protected override void Initialize()
        {
            CalculateOnBarClose = true;            
            logfile= @"c:\temp\ninja.txt";    
            File.Delete(logfile);
            log=File.CreateText(logfile);            
        }

November 20th, 2009, 04:20 PM

sam028

Something like this:

Code

                            
        protected override void Initialize()
        {
            CalculateOnBarClose = true;            
            logfile= @"c:\temp\ninja.txt";    
            File.Delete(logfile);
            log=File.CreateText(logfile);            
        }

Thanks. Of course. I thought maybe there was a different word I should be using. But also I didn't know about File.CreateText.

Apologies for multiple posts. Had connection timeout problems and some of them were not showing.

PS What seems to work is to put the File.Delete in the Initialize Section but the File.Append in the OnBarUpdate section.

Now it works great. I can export intraday data to a file and read it in TS where I can much more easily code in and evaluate simple ideas in strategies versus indicators. This single thing will save me hours/weeks of delays in testing which I have basically avoided since moving to Ninja a year ago when TS closed down accounts to people in certain Canadian provinces for reasons which I have never been able to determine (no doubt local financial industry lobbying).

November 20th, 2009, 04:45 PM

No problem.
Some tuto.examples in C#, here, easy to read, easy to find, good website.

November 22nd, 2009, 06:51 PM

sam028

No problem.
Some tuto.examples in C#, here, easy to read, easy to find, good website.

Sam thank for link.

Downside: now I have no more excuses!

December 6th, 2009, 06:11 PM

If you want to do analysis in Excel, I highly recommend XLQ:

XLQ

It's capable of getting quotes from IB and IQFeed, plus way more. XLQ is far superior to the Excel capabilities supplied by IB and IQFeed.

If you're just looking to download quotes into a CSV file, you could also consider QCollector:

Tradeworks Software

It can pull quotes from eSignal or IQFeed and create CSV files.

suprsnipes

Hi Big Mike,

I have a question regarding this code. I appreciate the effort you have put into this and had no problem setting this up but I was hoping you could answer a question for me.

As the data is stored in a .txt file do you have any suggestions as to how I could access this file and use the data within Excel in real-time for further analysis?

Regards,
suprsnipes

OHLC Data for downloading to Excel.csv

Discussion in NinjaTrader

OHLC Data for downloading to Excel.csv