how to remove non trading day entries

how to remove non trading day entries

ivanf
2017-04-05 19:58:33

Hi All,

newbie question

I am importing Metastock data using the published QS process, however my data provider includes non trading days ( like public holidays) in the data , which is a pain.

I'm not a coder, but could somebody help with a method of removing these entries, ideally as a pre or post script during importation.

I'm already running a pre-script to append a letter to the symbol ( see below) , so I don't want this to somehow break if I was to add a script to remove the non trading days

for(int i=0;i<Content.Rows.Length;i++)
{
Content.Rows[i].Data[0] = Content.Rows[i].Data[0] + ".AX";
}

thanks in advance
Ivan

QuantShare
2017-04-06 04:14:06

Hi Ivan,

If on these days (public holidays) the reported volume is 0 then you can add a line in the pre-script to check for the volume and ignore the line accordingly.

ivanf
2017-04-06 19:03:08

ok thanks for the reply , could you provide me the code to do this please ?

QuantShare
2017-04-07 03:43:02

Best Answer

That depends on the data you have but it should be something like:

int volumeIndex = 5;
for(int i=0;i < Content.Rows.Length;i++)
{
if(Content.Rows[i].Data[volumeIndex] == "0")
{
Content.Rows[i].IsIgnoreLine = true;
}
}

ivanf
2017-04-07 07:38:49

thanks ! works as I needed

Get more messages

No more messages

Back


Trading Items Number of IPOs per Day - Trading Composite Number of Potential Splits per Trading Day Time-series Sum for the first Minutes/Hours of a Trading Day Tax Implications for Your Trading System Forex Trading Indicator - Better than expected Economic Calendar ...	How-to Lessons How to generate buy/sell signals from a trading system How to plot the number of stock tweets per day How to get trading orders from a portfolio programmatically How to create trading rules based on Put and Call volume data How to add a metric in the trading system simulation report
Related Forum Threads How to determine if the a given day is a trading day? How to create a Trading Object How to get the last day of the month in C# How to edit a trading system i've downloaded from shared server? Day trading system	Blog Posts How to create buy and sell trading rules based on News Data How to get buy and sell orders for a portfolio based on a trading... How to Download Trading Data for Certain Securities Only How to create a trading system, screen and composite using earnin... Day Trading: A trading system that combines intraday and EOD data