Overall Statistics
Total Trades
46
Average Win
0.79%
Average Loss
-0.66%
Compounding Annual Return
-91.555%
Drawdown
19.000%
Expectancy
-0.667
Net Profit
-18.543%
Sharpe Ratio
-9.878
Loss Rate
85%
Win Rate
15%
Profit-Loss Ratio
1.19
Alpha
-2.234
Beta
-0.142
Annual Standard Deviation
0.224
Annual Variance
0.05
Information Ratio
-8
Tracking Error
0.258
Treynor Ratio
15.601
Total Fees
$0.00
using System.Globalization;

namespace QuantConnect {


   public class YahooCsv : BaseData
    {
        public decimal Open = 0;
        public decimal High = 0;
        public decimal Low = 0;
        public decimal Close = 0;
//        public decimal AdjustedClose = 0;
        public decimal Volume = 0;

        public YahooCsv()
        {
            this.Symbol = "";
        }
        
        /// <summary>
        /// Return the URL external source for the data: QuantConnect will download it an read it line by line automatically:
        /// </summary>
        public override SubscriptionDataSource GetSource(SubscriptionDataConfig config, DateTime date, bool isLive)
        {
            //QUANDL WRAPPER ON YAHOO FINANCE API TO SORT DATA:
            //https://www.quandl.com/api/v1/datasets/YAHOO/INDEX_SPY.csv?trim_start=2000-01-01&trim_end=2014-12-03&sort_order=asc
            //return new SubscriptionDataSource("https://www.quandl.com/api/v1/datasets/YAHOO/" + config.Symbol + ".csv?trim_start=" + startDate + "&trim_end=" + endDate + "&sort_order=asc&exclude_headers=true", SubscriptionTransportMedium.RemoteFile);
            
            
            //var startDate = "1433769540";
            //var endDate = "1433781240";
            
            // download a single, consistent chunk of data, we could set this up to download once a week
            // the important this is that whe GetSorce is called, we give back the same URL when we don't want it
            // to be redownloaded, and a different one when we do want it to be redownloaded. The GetSource
            // function will be called for every tradeable date of the backtest.
            //var startDate = (int) (new DateTime(2015, 06, 01).Subtract(new DateTime(1970, 1,1)).TotalMilliseconds / 1000);
            //var endDate = (int) (new DateTime(2015, 07, 01).Subtract(new DateTime(1970, 1,1)).TotalMilliseconds / 1000);
            
            // here's an example of download data once a month
            var month = new DateTime(date.Year, date.Month, 01);
            var startDate = (int) (month.Subtract(new DateTime(1970, 1,1)).TotalMilliseconds / 1000);
            var endDate = (int) (month.AddMonths(1).Subtract(new DateTime(1970, 1,1)).TotalMilliseconds / 1000);
            
            var url = "http://newnode-pnucci.rhcloud.com/stock/yahoocsv?s=" + config.Symbol + "&d1=" + startDate + "&d2=" + endDate;
            System.Console.Error.WriteLine("DATA SOURCE:: " + url);
            
            return new SubscriptionDataSource(url, SubscriptionTransportMedium.RemoteFile);
        }
        
        /// <summary>
        /// Convert each line of the file above into an object.
        /// </summary>
        public override BaseData Reader(SubscriptionDataConfig config, string line, DateTime date, bool isLive)
        {
            YahooCsv yBar = new YahooCsv();

            try
            {
                string[] data = line.Split(',');
                //Required.
                yBar.Symbol = config.Symbol;
                //yBar.Time = DateTime.ParseExact(data[0], "yyyy-MM-dd", CultureInfo.InvariantCulture);
                yBar.Time = new DateTime(1970, 1, 1, 0, 0, 0, 0).AddMilliseconds(ulong.Parse(data[0])*1000);
                
                //User configured / optional data on each bar:
                yBar.Open = Convert.ToDecimal(data[1]);
                yBar.Close = Convert.ToDecimal(data[2]);
                yBar.High = Convert.ToDecimal(data[3]);
                yBar.Low = Convert.ToDecimal(data[4]);
                yBar.Volume = Convert.ToDecimal(data[5]);
                //yBar.AdjustedClose = Convert.ToDecimal(data[6]);
                
                //This is the value the engine uses for portfolio calculations
                yBar.Value = yBar.Close;
            }
            catch {   
            }

            return yBar;
        }
    }
}                        
using System;
using System.Collections;
using System.Collections.Generic; 
using QuantConnect.Securities;  
using QuantConnect.Models;   

namespace QuantConnect 
{   
    public class TestYahooCsv : QCAlgorithm
    {   
        private const string _symbol = "ITUB4F.SA";
        ExponentialMovingAverage emaFast;// = new MyEMA(15);
        ExponentialMovingAverage emaSlow;// = new MyEMA(50);
        
        public override void Initialize()
        {
            SetStartDate(2015, 6, 1);
            SetEndDate(2015, 7, 1);
            SetCash(5000);
            //Quandl Indexes 
            AddData<YahooCsv>(_symbol, Resolution.Minute);
            
            emaFast = EMA(_symbol, 15);
            emaSlow = EMA(_symbol, 50);
        }



        private DateTime previous;

        /// <summary>
        /// Yahoo Daily Bars Event Handler: Daily bars arrive here for processing.
        /// </summary>
        public void OnData(YahooCsv data)
        {
            //Log("data! "+data.Time);
            int holdings = Portfolio[_symbol].Quantity;
            
            
            const decimal tolerance = 0.00015m;
            
            // we only want to go long if we're currently short or flat
            if (holdings <= 0)
            {
                // if the fast is greater than the slow, we'll go long
                if (emaFast > emaSlow * (1 + tolerance)){
                    Log("BUY  >> " + Securities[_symbol].Price);
                    SetHoldings(_symbol, 1.0);
                }
            }

            // we only want to liquidate if we're currently long
            // if the fast is less than the slow we'll liquidate our long
            if (holdings > 0 && emaFast < emaSlow){
                Log("SELL >> " + Securities[_symbol].Price);
                Liquidate(_symbol);    
            }
            
            /*if (holdings <= 0){
                if (emaFast.EMA > emaSlow.EMA){
                    Order(_symbol, Math.Abs(holdings)+70);
                }
            } else if (holdings >= 0){
                if (emaFast.EMA < emaSlow.EMA){
                    Order(_symbol,-(holdings+70));
                }
            }*/
            
            /*
            
            // a couple things to notice in this method:
            //  1. We never need to 'update' our indicators with the data, the engine takes care of this for us
            //  2. We can use indicators directly in math expressions
            //  3. We can easily plot many indicators at the same time


            // only once per day
            if (previous.Date == data.Time.Date) return;

            // define a small tolerance on our checks to avoid bouncing
            const decimal tolerance = 0.00015m;
            var holdings = Portfolio[_symbol].Quantity;

            // we only want to go long if we're currently short or flat
            if (holdings <= 0)
            {
                // if the fast is greater than the slow, we'll go long
                if (fast > slow * (1 + tolerance))
                {
                    Log("BUY  >> " + Securities[_symbol].Price);
                    SetHoldings(_symbol, 1.0);
                }
            }

            // we only want to liquidate if we're currently long
            // if the fast is less than the slow we'll liquidate our long
            if (holdings > 0 && fast < slow)
            {
                Log("SELL >> " + Securities[_symbol].Price);
                Liquidate(_symbol);    
            }

            Plot(_symbol, "Price", data.Value);
            Plot("Ribbon", "Price", data.Value);
            
            // easily plot indicators, the series name will be the name of the indicator
            Plot(_symbol, fast, slow);
            Plot("Ribbon", ribbon);

            previous = data.Time;
            */
        }
    }
}