week & month results from IG download

• 09/19/2019 at 10:46 PM #108017
  Paul

  An attempt in excel to create a basic sheet to see real week & months results  automatically.

  From IG, goto history and download the profit/loss from the period you want, maximum a year.

  Copy the whole tradebreakdown sheet content to the TBD sheet in this excel file in cell A1

  In the sheet TradeAnalysis you see the results by week & month. Having this to work, it could easily be expanded.

  Probably would be nice to include a filter so it can filter results only for certain markets, using a dropdown with data validation.

  With the results, it’s easy to create graphs and more.

  3 users thanked author for this post.

  Magifina, jebus89, Edmond

  

  Paul

  Participant

  Topics: 40

  Replies: 812

  Been thanked: 660 times
  10/02/2019 at 2:24 PM #109095
  deletedaccount100622

  Hi Paul

  have you thought about using Edgewonk 

  I have been using it for a couple of years now, I am currently in the middle of writing a guide of how I use Edgewonk for a new trading site I am building but its not in place yet. I will attach a few images below

  There is a stack of features and I found it more informative than the Excel sheets I used run, plus the direct import from the IG.com Closed trades Excel export that you referenced makes it dead easy to add the trades

  2 users thanked author for this post.

  Paul, Magifina

  

  deletedaccount100622

  Participant

  Topics: 13

  Replies: 116

  Been thanked: 60 times
  10/02/2019 at 10:03 PM #109135
  Paul

  That’s a great tip! Excel feels limited and need a lot of work for this purpose.

  The screenshots show the program is definitely worthy to check it out. Thanks!

  

  Paul

  Participant

  Topics: 40

  Replies: 812

  Been thanked: 660 times
  10/10/2019 at 5:22 PM #109855
  Derek

  Hi Robo Futures Trader,

  Thanks for the tip. Is that an affiliate link? If so please disclose your relationship to the company you’re promoting, because it’s simply good style.

   

  

  Derek

  Participant

  Topics: 6

  Replies: 240

  Been thanked: 60 times
  10/10/2019 at 5:24 PM #109857
  Derek

  -deleted, because I found the edit button available on the desktop version of the site.

  

  Derek

  Participant

  Topics: 6

  Replies: 240

  Been thanked: 60 times
• Author
  Posts