Script to run scanner and increment date?

Script to run scanner and increment date?

Jared Seaton
2021-10-29 19:26:50

I saw the following How-To, and I was wondering if it's possible to have the script increase/decrease the date of the scan and rerun until a certain date/number of days incremented? I want to scan historical dates at a specific hour, and it's pretty tedious to run it, wait, then adjust the date, and repeat.

https://www.quantshare.com/how-423-how-to-run-a-screen-or-a-watchlist-from-a-script

QuantShare
2021-11-08 09:47:08

Best Answer

Hi,

You can run a screen at a specific date/time using this function:
Screener.Run("", "name", "mm/dd/yyyy hh:mm:ss");

The script will look like this: (Just an example)

DateTime date = new DateTime(2021, 8, 20);
for(int i=0;i<20;i++)
{
string ddate = date.ToString("MM/dd/yyyy hh:mm:ss");
Screener.Run("", "name", ddate);
date = date.AddDays(1);
}

Jared Seaton
2021-11-12 20:51:11

Awesome, that was very helpful. What I've put together seems to work, but it's not outputing symbols. One thing I found, is that in the Output it's showing the time as 03/19/2020 04:30:00 when I am using "DateTime date = new DateTime(2020, 3, 19, 16, 30, 00);" . Should this show as 03/19/2020 16:30:00?

When I run the scan manually for 3/19/2020 16:30 I get one result.

DateTime date = new DateTime(2020, 3, 19, 16, 30, 00);

for(int i=0;i<3;i++)
{
string ddate = date.ToString("MM/dd/yyyy hh:mm:ss");
ScreenTask task = Screener.Run("", "15MHV", ddate);
date = date.AddDays(-1);
while(!task.IsCompleted)
{
App.Main.Sleep(500);
}
Global.Trace(date.ToString("MM/dd/yyyy hh:mm:ss"));
for(int j=0; j< task.ScreenResults.Length;j++)
{
string symbol = task.ScreenResults[j].Symbol;
Global.Trace(symbol);
}

}

QuantShare
2021-11-14 12:56:04

For the output, try using
MM/dd/yyyy HH:mm:ss
instead of
MM/dd/yyyy hh:mm:ss

to display the time in 24 hour format instead of 12 hour format

Jared Seaton
2021-11-15 19:12:28

That helped the timestamp display, thank you. However now it seems that it's not actually running the screener with the incrementing dates. I have the screener saved with 3/19/20 as the date, which does have one result. When I run the script, it prints out the same symbol from 3/19/20 for each date. Do I need to do the screener.run differently, or maybe move things around?

DateTime date = new DateTime(2020, 3, 19, 16, 30, 00);
for(int i=0;i<3;i++)
{
string ddate = date.ToString("MM/dd/yyyy HH:mm:ss");
ScreenTask task = Screener.Run("", "15MHV", ddate);
while(!task.IsCompleted)
{
App.Main.Sleep(500);
}
Global.Trace(date.ToString("MM/dd/yyyy HH:mm:ss"));
for(int j=0; j< task.ScreenResults.Length;j++)
{
string symbol = task.ScreenResults[j].Symbol;
Global.Trace(symbol);
}
date = date.AddDays(-1);
}

Get more messages

No more messages

Back


Trading Items Identify Spilts Screener Script MAE and MFE of a Trading System Relative Performance Chart - Dynamic assets and index Breakout With Volume and liquidity Optimizable Fibonacci Long and Short Trading System	How-to Lessons How to run a screen or a watchlist from a script How to execute a script at regular intervals How to get stocks for a particular index using the global script How to download and use U.S. stocks earnings data How to run QuantShare offline
Related Forum Threads Money Management Script variables and more Money Management script and exit options in the wizard Adding symbols and changing properties from script Accessing Symbol Info in Screener, Strategy script and in MM tool... Can I update the sector and industry information in the stock dat...	Blog Posts How to build and backtest a robust stock trading system QS Trading Software: Global Script Backtest Trading Strategies Programmatically and on Schedule Step by step on how to get free realtime/delayed data for stocks,... How to get buy and sell orders for a portfolio based on a trading...