How to add additional columns to Data grid?

[michaelz]

Hi, I am pretty new for this system, but I have some questions for historical data import and backtesting. Hope I can get some helps here.

Here is an example of Apple stock historical data:

Date,Open,High,Low,Close,Volume,Adj Close,CompanySentimentIndex
2010-08-17,250.08,254.63,249.20,251.97,15083200,251.97,1.2 2
2010-08-16,247.58,250.01,246.62,247.64,11350600,247.64,1.3 4
2010-08-13,251.65,251.88,249.09,249.10,12657400,249.10,0.9 8
2010-08-12,246.69,253.10,246.12,251.79,19083400,251.79,1.7 5
2010-08-11,255.40,255.69,249.81,250.19,22108400,250.19,2.1 2

Actually I have a new column called "CompanySentimentIndex", which indicates how good or how bad the company is in new/media on that day. I want to make it as an additional signal in my trading strategy. But how I provide this data to the system? Currently only Data/Open/high/low/Close/Volume are recognized by day bar during import.

I haven't figured out a way to add new columns, but is that possible?
If not possible, any workaround to import this new field and use it in trading strategies? Thanks for your helps!

[NinjaTrader_RyanM1]

Hello Michaels,

Welcome to the NinjaTrader forums!

CompanySentimentIndex isn't something you could import directly into the database.

You can use NinjaScript to program an indicator to read from a file and capture this value. The following reference samples can help with reading / writing from a file.

Using StreamReader to read from a text file
Using System.IO File properties to write to and read from a text file

[michaelz]

Thanks for your prompt reply. I will take a look of that.