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 Time-series Sum for the first Minutes/Hours of a Trading Day Number of Potential Splits per 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 add a trading indicator to a chart How to create trading rules based on Put and Call volume data
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 get buy and sell orders for a portfolio based on a trading... How to create buy and sell trading rules based on News Data How to create a trading indicator that uses stock news How to Switch On/Off Trading Rules in Your Stock Trading System How to Download Trading Data for Certain Securities Only