///We remove identical lines
public static List <IntradayTransfer> GetDataFromDb()
{
List <IntradayTransfer> intradayList = new List <IntradayTransfer>();
double previousPrice = -999;
using (var db = new ApplicationDbContext())
{
//3 - We add each item to our final list (26 first doesn;t contain RSI neither MACD calulation)
foreach (var item in db.Intraday)
{
if (item.P == previousPrice)
{
continue;
}
IntradayTransfer newIntraday = new IntradayTransfer()
{
Price = item.P,
};
intradayList.Add(newIntraday);
previousPrice = item.P;
}
}
//Calculate change from next day to current day
intradayList.Where((p, index) => CalculateFuture(p, index, intradayList)).ToList();
//Add RSI calculation to the list
TradeIndicator.CalculateRsiList(14, ref intradayList);
TradeIndicator.CalculateMacdList(ref intradayList);
return(intradayList.Skip(26).ToList());
}
