Forums ProRealTime English forum General trading discussions Anyone any good with excel here? Reply To: Anyone any good with excel here?

#70041

@GraHal ive got em in a pivot table as well, the main problem is that i need X axis to just be dates from 01.01.2016 -> todays date (Edit: Or it can just be “Jan 2016, Feb 2016, Mar 2016 etc on the X axis, but i still need it to “show trades” on the correct dates so i can see the correlation between them)

And i need the trades to be plotted in on the correct dates that they where taken. If 2 trades happened the same day i need both trades to be on same day (even if its the same algo)

Does this make sense?

In other words: i want EQ lines of 7 algos in the same graph/Chart!

 

I got the data (i think), i just need to know how i can plot dates into X axis and then place the trades on the correct trades.