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 Big Mike with 1 posts (0 thanks)
    4. looks_4 Quick Summary with 1 posts (0 thanks)
    1. trending_up 5,342 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?
NT7 Indicator Script Troubleshooting - Camarilla Pivots
NinjaTrader
Strategy stop orders partially filled
EasyLanguage Programming
Trade idea based off three indicators.
Traders Hideout
Quantum physics & Trading dynamics
The Elite Circle
REcommedations for programming help
Sierra Chart
 
Best Threads (Most Thanked)
in the last 7 days on NexusFi
Just another trading journal: PA, Wyckoff & Trends
26 thanks
ApexTraderFunding.com experience and review
13 thanks
Trading with Intuition
12 thanks
EG Indicators
11 thanks
What is Markets Chat (markets.chat) real-time trading ro …
9 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,474 since Jun 2009
Thanks Given: 33,251
Thanks Received: 101,678

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



Join the free Markets Chat beta: one platform, all the trade rooms!

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