NexusFi: Find Your Edge


Home Menu

 





determine monthly p/l from spread sheet


Discussion in Traders Hideout

Updated
      Top Posters
    1. looks_one malibu with 7 posts (0 thanks)
    2. looks_two Itchymoku with 3 posts (1 thanks)
    3. looks_3 Quick Summary with 1 posts (0 thanks)
    4. looks_4 Big Mike with 1 posts (0 thanks)
    1. trending_up 5,322 views
    2. thumb_up 1 thanks given
    3. group 2 followers
    1. forum 10 posts
    2. attach_file 4 attachments




 
Search this Thread

determine monthly p/l from spread sheet

  #1 (permalink)
 
malibu's Avatar
 malibu 
toronto canada
 
Experience: Advanced
Platform: Matlab + NT + TS
Trading: FOREX
Posts: 65 since Jul 2013
Thanks Given: 9
Thanks Received: 17

Can someone please tell me how (software or whatever) to produce monthly returns from the attached spreadsheet?

Attached Files
Elite Membership required to download: audusd_trades.xls
Started this thread Reply With Quote

Can you help answer these questions
from other members on NexusFi?
Trade idea based off three indicators.
Traders Hideout
REcommedations for programming help
Sierra Chart
Pivot Indicator like the old SwingTemp by Big Mike
NinjaTrader
ZombieSqueeze
Platforms and Indicators
Exit Strategy
NinjaTrader
 
Best Threads (Most Thanked)
in the last 7 days on NexusFi
Spoo-nalysis ES e-mini futures S&P 500
33 thanks
Just another trading journal: PA, Wyckoff & Trends
26 thanks
Tao te Trade: way of the WLD
24 thanks
Bigger Wins or Fewer Losses?
23 thanks
GFIs1 1 DAX trade per day journal
19 thanks
  #3 (permalink)
 
malibu's Avatar
 malibu 
toronto canada
 
Experience: Advanced
Platform: Matlab + NT + TS
Trading: FOREX
Posts: 65 since Jul 2013
Thanks Given: 9
Thanks Received: 17


Is this sheet maybe more applicable????

I just need to be able to generate that in, say, june of 2005 the account grew by x% (unrealized and realized). I am so disgusted by this whole thing.

Attached Files
Elite Membership required to download: audusd_alt_trades_list.xls
Started this thread Reply With Quote
  #4 (permalink)
 
malibu's Avatar
 malibu 
toronto canada
 
Experience: Advanced
Platform: Matlab + NT + TS
Trading: FOREX
Posts: 65 since Jul 2013
Thanks Given: 9
Thanks Received: 17

Like this, Itchy???

Attached Files
Elite Membership required to download: audusd_trades_list_Alt_Alt.xls
Started this thread Reply With Quote
  #5 (permalink)
 
malibu's Avatar
 malibu 
toronto canada
 
Experience: Advanced
Platform: Matlab + NT + TS
Trading: FOREX
Posts: 65 since Jul 2013
Thanks Given: 9
Thanks Received: 17

thanks, itchy.

Started this thread Reply With Quote
  #6 (permalink)
 Itchymoku 
Philadelphia
 
Experience: None
Platform: corded black telephone
Trading: ticker tape
Posts: 2,894 since Apr 2012
Thanks Given: 1,683
Thanks Received: 3,681

Trying to figure it out from adding or subtracting from a total equity is just going to give you a heart attack.

R.I.P. Joseph Bach (Itchymoku), 1987-2018.
Please visit this thread for more information.
Reply With Quote
  #7 (permalink)
 
Big Mike's Avatar
 Big Mike 
Manta, Ecuador
Site Administrator
Developer
Swing Trader
 
Experience: Advanced
Platform: Custom solution
Broker: IBKR
Trading: Stocks & Futures
Frequency: Every few days
Duration: Weeks
Posts: 50,444 since Jun 2009
Thanks Given: 33,217
Thanks Received: 101,608

Your first attachment has the individual % return for each trade it seems, but it is missing correct dates.

Fix the dates, and then you can do it in Excel easily but simply graphing the F column "% return" grouping by month.

Mike

We're here to help: just ask the community or contact our Help Desk

Quick Links: Change your Username or Register as a Vendor
Searching for trading reviews? Review this list
Lifetime Elite Membership: Sign-up for only $149 USD
Exclusive money saving offers from our Site Sponsors: Browse Offers
Report problems with the site: Using the NexusFi changelog thread
Follow me on Twitter Visit my NexusFi Trade Journal Reply With Quote
  #8 (permalink)
 
malibu's Avatar
 malibu 
toronto canada
 
Experience: Advanced
Platform: Matlab + NT + TS
Trading: FOREX
Posts: 65 since Jul 2013
Thanks Given: 9
Thanks Received: 17

thanks yall

Started this thread Reply With Quote
  #9 (permalink)
 
malibu's Avatar
 malibu 
toronto canada
 
Experience: Advanced
Platform: Matlab + NT + TS
Trading: FOREX
Posts: 65 since Jul 2013
Thanks Given: 9
Thanks Received: 17

ok so I have made another sheet which I think fits the bill... but...
I dont know how to group the returns by month... please help

Attached Files
Elite Membership required to download: testtest.xls
Started this thread Reply With Quote
  #10 (permalink)
 Itchymoku 
Philadelphia
 
Experience: None
Platform: corded black telephone
Trading: ticker tape
Posts: 2,894 since Apr 2012
Thanks Given: 1,683
Thanks Received: 3,681


How to Make a Graph With Months in Excel | Chron.com

R.I.P. Joseph Bach (Itchymoku), 1987-2018.
Please visit this thread for more information.
Reply With Quote
Thanked by:




Last Updated on August 7, 2015


© 2024 NexusFi™, s.a., All Rights Reserved.
Av Ricardo J. Alfaro, Century Tower, Panama City, Panama, Ph: +507 833-9432 (Panama and Intl), +1 888-312-3001 (USA and Canada)
All information is for educational use only and is not investment advice. There is a substantial risk of loss in trading commodity futures, stocks, options and foreign exchange products. Past performance is not indicative of future results.
About Us - Contact Us - Site Rules, Acceptable Use, and Terms and Conditions - Privacy Policy - Downloads - Top
no new posts