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 331,911 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

  #701 (permalink)
Planinmotion
Brisbane Qld
 
Posts: 2 since Mar 2012
Thanks Given: 1
Thanks Received: 1

This is the best Trading journal spreadsheet that I have ever seen. Thankyou so much for this, just what I was looking for and more!

Reply With Quote

Can you help answer these questions
from other members on NexusFi?
Build trailing stop for micro index(s)
Psychology and Money Management
Ninja Mobile Trader VPS (ninjamobiletrader.com)
Trading Reviews and Vendors
My NT8 Volume Profile Split by Asian/Euro/Open
NinjaTrader
Exit Strategy
NinjaTrader
Are there any eval firms that allow you to sink to your …
Traders Hideout
 
Best Threads (Most Thanked)
in the last 7 days on NexusFi
Get funded firms 2023/2024 - Any recommendations or word …
59 thanks
Funded Trader platforms
36 thanks
NexusFi site changelog and issues/problem reporting
22 thanks
The Program
20 thanks
GFIs1 1 DAX trade per day journal
19 thanks
  #702 (permalink)
 
petrmac's Avatar
 petrmac 
Czech Republic
 
Experience: Beginner
Platform: NinjaTrader
Trading: E7, M6E
Posts: 175 since Jun 2011
Thanks Given: 275
Thanks Received: 211

I had finally some time to update the importer.
The main new feature I added is the ability to import also the trades made by ATM strategy.
I refactored the way the trades are grouped: now I group the trades based on the entry time. Whenever there is a trade with same entry time it is added as another car.

So the program should now meaningfully group the trades from strategies and manual trading alike.

It exports to an older version of journal (still probably some link problem in V4). But there is a workaround: save to a new file and then import from the journal v 4:-)

Attached Files
Elite Membership required to download: ResultsImport.zip
Visit my NexusFi Trade Journal Reply With Quote
  #703 (permalink)
 
keymoo's Avatar
 keymoo 
Bedford, UK
 
Experience: Beginner
Platform: SierraChart/TT Feed
Trading: NQ
Posts: 129 since Mar 2012
Thanks Given: 212
Thanks Received: 215


hi vvhg,

When I launch the v 4.0 spreadsheet I get this message immediately. Do you know what I need to do? I'm using Excel 2010.

[img]https://nexusfi.com/v/syxszd.png[/img]

Follow me on Twitter Reply With Quote
  #704 (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,399 since Jun 2009
Thanks Given: 33,173
Thanks Received: 101,538


keymoo View Post
hi vvhg,

When I launch the v 4.0 spreadsheet I get this message immediately. Do you know what I need to do? I'm using Excel 2010.

What version of Microsoft Excel are you using?

EDIT: Oops, I see you said 2010.

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
  #705 (permalink)
 tenlar 
Germany
 
Experience: Intermediate
Platform: NinjaTrader
Broker: IB / Kinetick
Trading: Emini NQ
Posts: 1 since Feb 2010
Thanks Given: 6
Thanks Received: 0


keymoo View Post
hi vvhg,

When I launch the v 4.0 spreadsheet I get this message immediately. Do you know what I need to do? I'm using Excel 2010.

[img]https://nexusfi.com/v/syxszd.png[/img]

Hi,

i got the same Error Message....

in my case a missing Acrobat Reader was the Problem.

Tenlar

Reply With Quote
  #706 (permalink)
 
keymoo's Avatar
 keymoo 
Bedford, UK
 
Experience: Beginner
Platform: SierraChart/TT Feed
Trading: NQ
Posts: 129 since Mar 2012
Thanks Given: 212
Thanks Received: 215


tenlar View Post
Hi,

i got the same Error Message....

in my case a missing Acrobat Reader was the Problem.

Tenlar

I don't have Adobe Acrobat Reader. Do you think that might be the problem? Seems a little odd. I don't really want to install that to be honest.

Follow me on Twitter Reply With Quote
  #707 (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


tenlar View Post
Hi,

i got the same Error Message....

in my case a missing Acrobat Reader was the Problem.

Tenlar


keymoo View Post
I don't have Adobe Acrobat Reader. Do you think that might be the problem? Seems a little odd. I don't really want to install that to be honest.


Hmmm, that seems very strange, I don't know why a missing Adobe reader should lead to such an error, I will investigate and hopefully come up with a fix...

vvhg

Hic Rhodos, hic salta.
Reply With Quote
  #708 (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

Version 4.1


Hopefully the issue with Acrobat is fixed now, I removed a reference to Acrobat.

vvhg

Hic Rhodos, hic salta.
Attached Files
Elite Membership required to download: Journal 4.1.rar
Reply With Quote
  #709 (permalink)
naveen
mumbai
 
Posts: 10 since Feb 2011
Thanks Given: 4
Thanks Received: 0

I am trying to understand and use your Trading Journal to improve my trading and would like to thank you for creating it.

I am from india and i trade in stock cash market. How should i modify the commissions table for my use?

Tick size is 0.05.

Commission is charged in % of volume, like if i am buying 1000 shares of each worth 100 then commission would be 0.03 % of 100000 i.e 30.

and there are extra charges depending on this commission.

Earlier i used my formulas to calculate commissions. If i want to use this then in which all places i have to modify ur trading journal?

Reply With Quote
  #710 (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



naveen View Post
I am trying to understand and use your Trading Journal to improve my trading and would like to thank you for creating it.

I am from india and i trade in stock cash market. How should i modify the commissions table for my use?

Tick size is 0.05.

Commission is charged in % of volume, like if i am buying 1000 shares of each worth 100 then commission would be 0.03 % of 100000 i.e 30.

and there are extra charges depending on this commission.

Earlier i used my formulas to calculate commissions. If i want to use this then in which all places i have to modify ur trading journal?

Hello @naveen,

to accommodate for stock commissions the journal would need some adaptions as futures commissions are generally calculated differently.
There are two possibilities:
1. the easier modification would be to type in the commissions by hand on the journal tab. Obviously you would have to manually calculate them before.
2. Adapt the instrument tab commission round turn column to show % (e.g. .03%) and then adapt the commission column formula to calculate along the lines of: price*shares*%

If you could provide a round turn example calculation I will try to implement this for you as soon as I have the time...

vvhg

Hic Rhodos, hic salta.
Reply With Quote
Thanked by:




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