NexusFi: Find Your Edge


Home Menu

 





Trading Metrics for journals/record keeping


Discussion in Psychology and Money Management

Updated
      Top Posters
    1. looks_one vvhg with 354 posts (690 thanks)
    2. looks_two madLyfe with 202 posts (104 thanks)
    3. looks_3 petrmac with 73 posts (106 thanks)
    4. looks_4 Big Mike with 35 posts (165 thanks)
      Best Posters
    1. looks_one PandaWarrior with 75 thanks per post
    2. looks_two Big Mike with 4.7 thanks per post
    3. looks_3 vvhg with 1.9 thanks per post
    4. looks_4 petrmac with 1.5 thanks per post
    1. trending_up 334,957 views
    2. thumb_up 1,509 thanks given
    3. group 234 followers
    1. forum 946 posts
    2. attach_file 252 attachments




 
Search this Thread

Trading Metrics for journals/record keeping

  #771 (permalink)
akshri250
Muri, Jharkhand, India
 
Posts: 8 since Jan 2011
Thanks Given: 11
Thanks Received: 1


vvhg View Post
Perhaps I could help you with modifications? Especially if they are in fact improvements.

Vvhg


Sent from my iPad using Tapatalk HD


First of all, how I can change all the $ signs to "Rs." sign??
regards

Reply With Quote

Can you help answer these questions
from other members on NexusFi?
How to apply profiles
Traders Hideout
ZombieSqueeze
Platforms and Indicators
Better Renko Gaps
The Elite Circle
REcommedations for programming help
Sierra Chart
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
28 thanks
Tao te Trade: way of the WLD
24 thanks
Bigger Wins or Fewer Losses?
23 thanks
GFIs1 1 DAX trade per day journal
21 thanks
  #772 (permalink)
 
vvhg's Avatar
 vvhg 
Northern Germany
 
Experience: Intermediate
Platform: NT
Trading: FDAX, CL
Posts: 1,583 since Mar 2011
Thanks Given: 1,016
Thanks Received: 2,824


akshri250 View Post
First of all, how I can change all the $ signs to "Rs." sign??
regards

You would have to change the formatting of every cell holding $ formattimg, including some hidden sheet, then you would have to change some formatting strings in the code. It's all not too difficult but it would probably take you a long time and I doubt it is worth the time spent.

Vvhg


Sent from my iPad using Tapatalk HD

Hic Rhodos, hic salta.
Reply With Quote
  #773 (permalink)
 
perryg's Avatar
 perryg 
Rechovot
 
Experience: Advanced
Platform: NinjaTrader
Broker: CQG
Trading: Index,Currency and Energy futures
Posts: 1,644 since Jan 2010
Thanks Given: 508
Thanks Received: 6,288


How do I transfer my journal data from version 4.1 to version 4.3 I should imagine this will be necessary each time a new version is released.

Reply With Quote
  #774 (permalink)
 
perryg's Avatar
 perryg 
Rechovot
 
Experience: Advanced
Platform: NinjaTrader
Broker: CQG
Trading: Index,Currency and Energy futures
Posts: 1,644 since Jan 2010
Thanks Given: 508
Thanks Received: 6,288


perryg View Post
How do I transfer my journal data from version 4.1 to version 4.3 I should imagine this will be necessary each time a new version is released.

Am I correct in saying that it is done via the "Overview" sheet, by using the Import Old Journals

Reply With Quote
  #775 (permalink)
 
vvhg's Avatar
 vvhg 
Northern Germany
 
Experience: Intermediate
Platform: NT
Trading: FDAX, CL
Posts: 1,583 since Mar 2011
Thanks Given: 1,016
Thanks Received: 2,824


perryg View Post
How do I transfer my journal data from version 4.1 to version 4.3 I should imagine this will be necessary each time a new version is released.

Have a look in Post#2, there is a little migration guide.
If you have any further questions or you feel the migration guide is missing sth, just give a shout.

vvhg

Hic Rhodos, hic salta.
Reply With Quote
  #776 (permalink)
 
perryg's Avatar
 perryg 
Rechovot
 
Experience: Advanced
Platform: NinjaTrader
Broker: CQG
Trading: Index,Currency and Energy futures
Posts: 1,644 since Jan 2010
Thanks Given: 508
Thanks Received: 6,288


vvhg View Post
Have a look in Post#2, there is a little migration guide.
If you have any further questions or you feel the migration guide is missing sth, just give a shout.

vvhg

I have read post #2, and there is absolutely no explanation of how to import from one version to the next. It points one to an importer, and that is only for importing data from NT (by the way I get error messages from it it seems useless for me - have posted this error sometime ago in the thread but no response).
I have now used the "import old journal" on the Overview sheet, it does import the info, but it also import the BUG from version 4.1 that you corrected in ver 4.3 (the "Max MAE to display ticks").

Reply With Quote
Thanked by:
  #777 (permalink)
 
vvhg's Avatar
 vvhg 
Northern Germany
 
Experience: Intermediate
Platform: NT
Trading: FDAX, CL
Posts: 1,583 since Mar 2011
Thanks Given: 1,016
Thanks Received: 2,824


perryg View Post
I have read post #2, and there is absolutely no explanation of how to import from one version to the next. It points one to an importer, and that is only for importing data from NT (by the way I get error messages from it it seems useless for me - have posted this error sometime ago in the thread but no response).
I have now used the "import old journal" on the Overview sheet, it does import the info, but it also import the BUG from version 4.1 that you corrected in ver 4.3 (the "Max MAE to display ticks").


Sorry, you are right, there was no description in post #2. I added there that it is in fact the import old journal button.
As to the importer, I can't really help there as it is by @petrmac who doesn't seem to be around too regularly...

The bug shouldn't get imported, I will have a closer look hopefully sometime today or tomorrow ...


vvhg

Hic Rhodos, hic salta.
Reply With Quote
Thanked by:
  #778 (permalink)
 
DarkPoolTrading's Avatar
 DarkPoolTrading   is a Vendor
 
Posts: 1,036 since May 2012
Thanks Given: 1,244
Thanks Received: 1,326


vvhg View Post
So you basically want to chart your daily P/L if its negative? The easiest would be to have a pivot table pulling out a daily P/L and then only use the negative numbers for plotting....
You can do that on the same tab just out of sight to the right.

vvhg

Hi vvhg,

Thanks for the advice, sorry for only getting a chance to reply now. I still cant figure out a way to do this (maybe I didn't explain the problem properly?). The issue lies in the fact that on my trade stats sheet, each line represents an individual trade. It is simple enough to add a column to indicate the drawdown, but then when I try create a chart off of that column, it doesn't summarise daily but instead charts every line item. I dont care if I had an intraday drawdown, what I care about is whether or not I was in a drawdown at the end of the day.

For example if I have 3 trades today with the 1st one being a loss of $100, then the next two having a profit of $200 each. At the end of the day there was no drawdown and I was positive $300. When I chart the drawdown chart it will show that todays drawdown was -$100 (ie: from the 1st trade of the day). But that is not corrrect because by the end of the day that drawdown no longer exists.

I have attached a spreadsheet to try and illustrate the issue.

Thanks for your time on this, I appreciate it.

Attached Files
Elite Membership required to download: test.xlsx
Follow me on Twitter Reply With Quote
  #779 (permalink)
 
vvhg's Avatar
 vvhg 
Northern Germany
 
Experience: Intermediate
Platform: NT
Trading: FDAX, CL
Posts: 1,583 since Mar 2011
Thanks Given: 1,016
Thanks Received: 2,824


DarkPoolTrading View Post
Hi vvhg,

I have attached a spreadsheet to try and illustrate the issue.

Thanks for your time on this, I appreciate it.

@DarkPoolTrading, I sent you a PM.

vvhg

Hic Rhodos, hic salta.
Reply With Quote
Thanked by:
  #780 (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


Hi @vvhg, can you confirm 4.3:


Is still latest version?

Thx kindly!

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 Started this thread Reply With Quote




Last Updated on June 1, 2023


© 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