protected void WriteSP500HistoricalData()
{
int count = SP500_historical_price_list.Count;
var csv = new StringBuilder();
csv.AppendLine("Date,P");
for (int i = 0; i < count; i++)
{
Date_Price_Pair dp = SP500_historical_price_list[i];
var newLine = string.Format("{0},{1:0.00}", dp.Date.ToShortDateString(), dp.Price);
csv.AppendLine(newLine);
}
//mut.WaitOne(); //wait until safe to enter; prior thread has completed writing.
try
{
String file_name = results_folder + "sp.csv";
File.WriteAllText(file_name, csv.ToString());
//mut.ReleaseMutex();
}
catch (System.Exception exp)
{
Log("File write error for file name '" + "' Error '" + exp.Message + "'", LogLevel.Warning);
}
}
protected override void OnBarUpdate()
{
int BarIndex = BarsInProgress;
bool bFinishedProcessingAllData = false;
Boolean bLastSymbol = BarIndex == (symbol_list.Count - 1);
DateTime current_bar_date = Times[BarIndex][0].Date;
if (bLastSymbol &&
(((CurrentBar + 1) == Count) || (current_bar_date == TestingEndDate))) //we are on the last bar to process
{
Debug.WriteLine("bFinished trigger");
bFinishedProcessingAllData = true;
}
String debug_txt1 = "Date=" + Times[BarIndex][0].Date.ToShortDateString() + "BarIndex=" + BarIndex.ToString() + "CurrentBar=" + CurrentBar.ToString() + "Count=" + Count.ToString();
Debug.WriteLine(debug_txt1);
//NOTE: Index 1 is always S&P 500
if ((BarIndex >= 1 /*1*/) && (BarIndex < (symbol_list.Count))) //Start at index=1 since we want to ignore the primary/dummy instrument
{
DateTime date_to_process = Times[BarIndex][0].Date; //need to wait FutureValueDaysToLookAhead days before we can make calcs
if ((date_to_process >= TestingStartDate) && (date_to_process <= TestingEndDate)) // && (CurrentBar >= (20))) //give 20 days of buffer
{
int SP500_index = 1;
if (BarIndex == SP500_index)
{
Date_Price_Pair date_price = new Date_Price_Pair();
date_price.Date = date_to_process;
date_price.Price = Closes[BarIndex][0];
SP500_historical_price_list.Add(date_price);
}
else //non S&P500 symbols
{
TradeScannerResult scan_result = new TradeScannerResult();
double OpenPriceToday = Opens[BarIndex][0];
double ClosePriceToday = Closes[BarIndex][0];
double SP500_Open = Opens[SP500_index][0];
double SP500_Close = Closes[SP500_index][0];
try
{
scan_result.Date = date_to_process;
scan_result.Symbol = symbol_list[BarIndex];
scan_result.Description = company_name_list[BarIndex];
scan_result.Open = OpenPriceToday;
scan_result.Close = ClosePriceToday;
scan_result.PercentChange_Today = (((ClosePriceToday / OpenPriceToday) - 1.0) * 100.0);
scan_result.SP500_PercentChange_Today = (((SP500_Close / SP500_Open) - 1.0) * 100.0);
scan_result.Compare_SP500_Today = scan_result.PercentChange_Today - scan_result.SP500_PercentChange_Today;
scan_result.PercentChange_1Day = PctChange(BarIndex, 1);
scan_result.PercentChange_2Day = PctChange(BarIndex, 2);
scan_result.PercentChange_5Day = PctChange(BarIndex, 5);
scan_result.PercentChange_10Day = PctChange(BarIndex, 10);
scan_result.PercentChange_15Day = PctChange(BarIndex, 15);
scan_result.PercentChange_20Day = PctChange(BarIndex, 20);
scan_result.Compare_SP500_1Day = scan_result.PercentChange_1Day - PctChange(SP500_index, 1);
scan_result.Compare_SP500_2Day = scan_result.PercentChange_2Day - PctChange(SP500_index, 2);
scan_result.Compare_SP500_5Day = scan_result.PercentChange_5Day - PctChange(SP500_index, 5);
scan_result.Compare_SP500_10Day = scan_result.PercentChange_10Day - PctChange(SP500_index, 10);
scan_result.Compare_SP500_15Day = scan_result.PercentChange_15Day - PctChange(SP500_index, 15);
scan_result.Compare_SP500_20Day = scan_result.PercentChange_20Day - PctChange(SP500_index, 20);
scan_result.Green_5Day = GetPercentOfGreenDays(BarIndex, 5);
scan_result.Green_10Day = GetPercentOfGreenDays(BarIndex, 10);
scan_result.Green_15Day = GetPercentOfGreenDays(BarIndex, 15);
scan_result.Green_20Day = GetPercentOfGreenDays(BarIndex, 20);
PopulateParamatersForIndicator(IndicatorEnum.indicator_BOLLINGER);
//Indicator_FutureValueChange_Pair indicator_pair = GetIndicatorValue(indicator_list[i], BarIndex, 0, date_to_process);
double indicator_value_today = 0.0;
scan_result.Indicator_Name = "BOLL";
scan_result.Strategy_Name = Strategy_Description; // Strategy_Num.ToString();
double boll_0 = ComputeBollinger(BarIndex, 0);
double boll_1 = ComputeBollinger(BarIndex, 1);
double boll_2 = ComputeBollinger(BarIndex, 2);
double boll_3 = ComputeBollinger(BarIndex, 3);
double boll_4 = ComputeBollinger(BarIndex, 4);
double boll_5 = ComputeBollinger(BarIndex, 5);
double boll_10 = ComputeBollinger(BarIndex, 10);
double boll_15 = ComputeBollinger(BarIndex, 15);
double boll_20 = ComputeBollinger(BarIndex, 20);
indicator_value_today = boll_0;
scan_result.Indicator_Today = indicator_value_today;
double boll_0_chg = boll_1 - boll_0;
double boll_min = -1.0;
double boll_max = -0.75;
bool boll_in_range = (boll_0 > boll_min) && (boll_0 < boll_max);
double boll_min_change = 0.05;
double boll_max_change = 0.25;
bool boll_change_in_range = (boll_0_chg > boll_min_change) && (boll_0_chg < boll_max_change);
bool boll_declining_3dys = (boll_3 > boll_2) && (boll_2 > boll_1) && (boll_0 > boll_1);
scan_result.Indicator_Change_1Day = indicator_value_today - boll_1;
scan_result.Indicator_Change_2Day = indicator_value_today - boll_2;
scan_result.Indicator_Change_5Day = indicator_value_today - boll_5;
scan_result.Indicator_Change_10Day = indicator_value_today - boll_10;
scan_result.Indicator_Change_15Day = indicator_value_today - boll_15;
scan_result.Indicator_Change_20Day = indicator_value_today - boll_20;
double RSI_val = RSI(BarsArray[BarIndex], 14, 3)[0]; //get the indicator val from n days ago
scan_result.RSI = RSI_val;
bool bBuy = false;
switch (Strategy_Num)
{
case 1: //declining boll for 3, then up spike
if (boll_in_range && boll_change_in_range)
{
//strat1 (declining boll for 3, then up spike)
if (boll_declining_3dys)
{
Console.WriteLine("\nstrat1\n");
bBuy = true;
}
}
break;
case 2: //boll up spike
if (boll_in_range && boll_change_in_range)
{
Console.WriteLine("\nstrat2\n");
bBuy = true;
}
break;
case 3: //boll crossing -1 threshold, but not too far
if ((boll_1 < -1.1) && (boll_0 > -0.9) && (boll_0 < -0.7))
{
Console.WriteLine("\nstrat3\n");
bBuy = true;
}
break;
case 4: //boll in range, today's change < -0.5% and SP500 change > 0%
if (boll_in_range && (scan_result.PercentChange_Today < -0.5) && (scan_result.SP500_PercentChange_Today > 0.0))
{
Console.WriteLine("\nstrat4\n");
bBuy = true;
}
break;
case 5: //strat3 + Today 0.75-1.25 and SP500Change 0.5 - 1.0
if ((boll_1 < -1.1) && (boll_0 > -0.9) && (boll_0 < -0.7) && (scan_result.PercentChange_Today > 0.75) &&
(scan_result.PercentChange_Today < 1.25) &&
(scan_result.SP500_PercentChange_Today > 0.5) &&
(scan_result.SP500_PercentChange_Today < 1.0))
{
Console.WriteLine("\nstrat5\n");
bBuy = true;
}
break;
case 6: //boll up spike + Today < -1.5 + SP500Change < -0.75
if (boll_in_range && boll_change_in_range && (scan_result.PercentChange_Today < -1.5) && (scan_result.SP500_PercentChange_Today < -0.75))
{
Console.WriteLine("\nstrat6\n");
bBuy = true;
}
break;
case 7: //strat3 + Today 0.5-2.0 and SP500Change 0.5 - 3.0
if ((boll_1 < -1.1) && (boll_0 > -0.9) && (boll_0 < -0.7) && (scan_result.PercentChange_Today > 0.5) &&
(scan_result.PercentChange_Today < 2.0) &&
(scan_result.SP500_PercentChange_Today > 0.5) &&
(scan_result.SP500_PercentChange_Today < 3.0))
{
Console.WriteLine("\nstrat7\n");
bBuy = true;
}
break;
default:
break;
}
String signal_name = scan_result.Symbol + "-" + Strategy_Num.ToString() + "-" + DaysToHold.ToString() + "-" + StopLossPercent.ToString();
//Check to see if time to sell
if (Trade_Status[BarIndex] == "InProgress")
{
//if ((date_to_process > trig.TradeDate)) // && (date_to_process <= trig.TradeDate.AddDays(trig.DaysToHold)))
//{
DaysSincePurchase[BarIndex]++;
if (DaysSincePurchase[BarIndex] == DaysToHold) //Use input parameter rather than reading from file trig.DaysToHold //Set Exit for end of nth day
{
Trade_Status[BarIndex] = "Idle";
ExitLong(BarIndex, NumShares[BarIndex], signal_name, signal_name);
DaysSincePurchase[BarIndex] = -1;
}
//}
}
else if (bBuy)
{
if (scan_result.Close < AmountPerTrade) //if price is greater than max per trade, then we cannot purchase
{
TradeTriggerByDate trig = new TradeTriggerByDate();
trig.Symbol = scan_result.Symbol;
trig.TradeDate = scan_result.Date;
trig.DaysToHold = DaysToHold;
trade_triggers.Add(trig);
Trade_Status[BarIndex] = "InProgress";
DaysSincePurchase[BarIndex] = 0;
//trig.Status = "InProgress";
NumShares[BarIndex] = (int)(AmountPerTrade / scan_result.Close);
EnterLong(BarIndex, NumShares[BarIndex], signal_name);
trade_scanner_results.Add(scan_result);
}
}
}
catch
{
Console.WriteLine("Caught exception");
}
}
}
}
if (bFinishedProcessingAllData == true)
{
uid = rnd.Next(100000, 999999).ToString();
results_folder = results_folder + "_" + uid + "\\";
DirectoryInfo di2 = Directory.CreateDirectory(results_folder);
WriteTradeScannerResults();
//WriteTradeTriggers();
WriteSP500HistoricalData();
}
}
