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 332,034 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

  #791 (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


Trad3r View Post
Great work on this Journal.

Has anyone in this thread used Openoffice or Libra office to open the document.
Unfortunately I use Open Office which does not open the file and have tried to convert it to xls or xlsx but then I get an error 508 on some input tabs or Macro errors.


I can view it with the free Microsoft office viewer but can't save it after changes.

Unfortunately OpenOffice and Libra are not supported. You can't convert the file to .xls or .xlsx without breaking it. Most of the really fancy stuff is VBA...

Vvhg

Sent from my iPad using Tapatalk HD

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

Can you help answer these questions
from other members on NexusFi?
Ninja Mobile Trader VPS (ninjamobiletrader.com)
Trading Reviews and Vendors
ZombieSqueeze
Platforms and Indicators
My NT8 Volume Profile Split by Asian/Euro/Open
NinjaTrader
Deepmoney LLM
Elite Quantitative GenAI/LLM
Online prop firm The Funded Trader (TFT) going under?
Traders Hideout
 
Best Threads (Most Thanked)
in the last 7 days on NexusFi
Get funded firms 2023/2024 - Any recommendations or word …
60 thanks
Funded Trader platforms
43 thanks
NexusFi site changelog and issues/problem reporting
24 thanks
GFIs1 1 DAX trade per day journal
22 thanks
The Program
19 thanks
  #792 (permalink)
 lugopt 
Lisboa, Portugal
 
Experience: Beginner
Platform: TradeStation, NinjatTrader
Trading: ES, EURUSD
Posts: 31 since Mar 2012
Thanks Given: 7
Thanks Received: 36


Trad3r View Post
Unfortunately I use Open Office which does not open the file and have tried to convert it to xls or xlsx but then I get an error 508 on some input tabs or Macro errors.

Hi Trad3r, I'm not sure you are aware you can get Microsoft Office 2010 Home and Student version for $125 (or chepear on other budget sites) and you can install it up to 3 PCs. So it would be around $40 per PC.

Thank you,

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



rickr View Post
@vvhg

When I down load Version "4.3" (which I believe to be the latest) . . .

And I open the Overview Page it says it is version "v3.2Beta50" . . .

Is this an incorrect posting on the Summary Page . . . or is the link for download giving me an older version ?

Thx for this great tool . . .

Rick

@rickr, I just checked, it is the correct version, I just forgot to update the version number on the Overview tab...

vvhg

Hic Rhodos, hic salta.
Reply With Quote
Thanked by:
  #794 (permalink)
isildur1
united kingdom
 
Posts: 2 since Oct 2012
Thanks Given: 0
Thanks Received: 1

is there anyway of syncing your TT with this spreadsheet so that you dont have to manually fill in every trade data?

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


isildur1 View Post
is there anyway of syncing your TT with this spreadsheet so that you dont have to manually fill in every trade data?

Unfortunately not, or nothing I know of at least.

Vvhg


Sent from my iPad using Tapatalk HD

Hic Rhodos, hic salta.
Reply With Quote
  #796 (permalink)
 
Anatta's Avatar
 Anatta 
Toronto, ON, Canada
 
Experience: Intermediate
Platform: NinjaTrader
Broker: Global futures (Continum), IB, FXCM
Trading: ES 6E Forex ETF
Posts: 41 since Sep 2012
Thanks Given: 209
Thanks Received: 28

Does the spreadsheet have to be run in MS Excel 2010?
I run in MS Ofiice 2007. And it crash a few time .

Also, I tried to play around and try to use it for stock. On the instrument list, I could not change point value to a value below $17. Every time I chang it to any figure below 17, it would give me an error message when I save the sheet. The error message is " A fomula in this worksheet contains one or more invalid refrences .... "

Is it because the spreadsheet could only be used for futures as the point vlaue is above 20.

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


wipca201 View Post
Does the spreadsheet have to be run in MS Excel 2010?
I run in MS Ofiice 2007. And it crash a few time .

Also, I tried to play around and try to use it for stock. On the instrument list, I could not change point value to a value below $17. Every time I chang it to any figure below 17, it would give me an error message when I save the sheet. The error message is " A fomula in this worksheet contains one or more invalid refrences .... "

Is it because the spreadsheet could only be used for futures as the point vlaue is above 20.

2007 should be fine.
The error you get should not be there, it seems to be some kind of bug. I will try to reproduce and fix this.

Vvhg

Hic Rhodos, hic salta.
Reply With Quote
Thanked by:
  #798 (permalink)
 aqpinfo 
Orland Park,Illinois/USA
 
Experience: Intermediate
Platform: Ninja Trader
Trading: Emini SP
Posts: 43 since Jul 2012
Thanks Given: 7
Thanks Received: 26

I have not kept a daily tading journal in the past .Do i understand this correct that i can have it connected to ninja trader platform. to review my results at the end of day and over weekend. now this is just results does anyone keep a journal that might have premarket homework and a review of the day of what you did right or wrong while trading
what type of day it was trend, balance maybe the big picture info like weekly chart info daily chart info

any feed back would be appreciated as well as info on how to connect to ninja
Thank Bill

Reply With Quote
  #799 (permalink)
 NW27 
Newcastle, Australia
 
Experience: Intermediate
Platform: Multicharts 8 - Full Version
Broker: IB
Trading: SPI,FTSE100, 6E, 6A
Posts: 285 since Oct 2010
Thanks Given: 108
Thanks Received: 188


aqpinfo View Post
now this is just results does anyone keep a journal that might have premarket homework and a review of the day of what you did right or wrong while trading
what type of day it was trend, balance maybe the big picture info like weekly chart info daily chart info

Thank Bill

I couldn't find anything that did this style of thing, so I ended up making my own.
I got this far and became sidetracked on other things.
To give you an idea of what I keep, here are some screen shots.

Neil.

You put in the details for the instrument you are trading, this makes the trade entry easier and faster.


You create a strategy Entry AND/OR Exit, again makes the trade recording easier.
Apart from the fact that now it is written in stone so to speak.


As each trade is performed, you record the details (or at the end of the day)
Because you have already defined the general details above, it makes the entry of the trade details faster but also hopefully reminds you to stick to the rules.



Basically, you fill out the first section of the daily diary prior to the market open.
Then finish the rest and do a performance review

Reply With Quote
  #800 (permalink)
 aqpinfo 
Orland Park,Illinois/USA
 
Experience: Intermediate
Platform: Ninja Trader
Trading: Emini SP
Posts: 43 since Jul 2012
Thanks Given: 7
Thanks Received: 26


Mike thanks for your reply is that file available

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