I'm tracking my trades in an excel sheet. Each row represents a new trade and since I trade on different markets I have a column where I specify which market the trade been initiated on. My question is if anyone know if theres a possibility to chart the P/L for each market? I've solved how to get a chart for all my trade. Can anybody help me with this? Thx in advance.
Excel has a charting function built in, here's some information on how to use it: http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=209 That should do what you need. If you're wanting to chart prices, technical indicators etc and use them in conjunction with Excel, Sierrachart does a great job of it.