Trading Metrics for journals/record keeping - futures io
futures io futures trading



Trading Metrics for journals/record keeping


Discussion in Psychology and Money Management

Updated
      Top Posters
    1. looks_one vvhg with 354 posts (687 thanks)
    2. looks_two madLyfe with 202 posts (104 thanks)
    3. looks_3 petrmac with 73 posts (105 thanks)
    4. looks_4 Big Mike with 35 posts (161 thanks)
      Best Posters
    1. looks_one PandaWarrior with 71.5 thanks per post
    2. looks_two Big Mike with 4.6 thanks per post
    3. looks_3 vvhg with 1.9 thanks per post
    4. looks_4 petrmac with 1.4 thanks per post
    1. trending_up 234,596 views
    2. thumb_up 1,485 thanks given
    3. group 221 followers
    1. forum 940 posts
    2. attach_file 252 attachments




Welcome to futures io: the largest futures trading community on the planet, with well over 125,000 members
  • Genuine reviews from real traders, not fake reviews from stealth vendors
  • Quality education from leading professional traders
  • We are a friendly, helpful, and positive community
  • We do not tolerate rude behavior, trolling, or vendors advertising in posts
  • We are here to help, just let us know what you need
You'll need to register in order to view the content of the threads and start contributing to our community.  It's free and simple.

-- Big Mike, Site Administrator

(If you already have an account, login at the top of the page)

 
Search this Thread
 

Trading Metrics for journals/record keeping

(login for full post details)
  #901 (permalink)
Boston, MA / USA
 
Experience: Intermediate
Platform: NinjaTrader
Trading: ES
 
Posts: 246 since Apr 2013
Thanks: 2,695 given, 368 received

Using @petrmacs importer results-import.zip in post #702 with Journal 4.5
https://futures.io/psychology-money-management/4884-trading-metrics-journals-record-keeping-71.html

Cannot import NinjaTrader data into existing journal.

If new csv data is appended to existing journal, lots of Excel errors are generated, corrupting the journal.
If importer creates a new file then:
1. Migrating new into old does not work.
2. Migrating old into new does not work.

The instructions in post #702 suggests to make a new file and import. Does that mean make a new file and migrate using the button in the overview tab? Or is there another way to Import data into the journal?

Any help would be much appreciated.
Can the importer source code be posted?

Reply With Quote
The following user says Thank You to Camdo for this post:
 
(login for full post details)
  #902 (permalink)
Des Moines, Iowa
 
Experience: None
Platform: Ninja, TOS
Broker: AMP/CQG, TOS
Trading: CL, TF, GC
 
madLyfe's Avatar
 
Posts: 1,644 since Feb 2011
Thanks: 9,220 given, 1,015 received


Camdo View Post
Using @petrmacs importer results-import.zip in post #702 with Journal 4.5
https://futures.io/psychology-money-management/4884-trading-metrics-journals-record-keeping-71.html

Cannot import NinjaTrader data into existing journal.

If new csv data is appended to existing journal, lots of Excel errors are generated, corrupting the journal.
If importer creates a new file then:
1. Migrating new into old does not work.
2. Migrating old into new does not work.

The instructions in post #702 suggests to make a new file and import. Does that mean make a new file and migrate using the button in the overview tab? Or is there another way to Import data into the journal?

Any help would be much appreciated.
Can the importer source code be posted?

i havnt used this in a long time so im not really of any help. i know @vvhg has been missing in action for awhile and im not sure why yet.

with all the cloud stuff out it would be cool to have a google drive or the free version of MS office in the cloud version done up. then there will be no more version updates from MS office to worry about. plus it will be free and everyone has access to it. not sure of the excel smiths around anymore.

dont believe anything you hear and only half of what you see

\_(ツ)_/

(╯□)╯︵ ┻━┻
Visit my futures io Trade Journal Reply With Quote
The following 2 users say Thank You to madLyfe for this post:
 
(login for full post details)
  #903 (permalink)
Garland Utah / United States
 
Experience: Intermediate
Platform: NinjaTrader
Trading: Futures, CL
 
Posts: 2 since Jun 2014
Thanks: 11 given, 1 received

Very long read but well worth it, thanks to all. And a special to @vvhq, all I can say is WOW. This is more HIGH tech than I can comprehend, it will be a learning experience. Also thanks to @petrmac for the importer. Just starting SIM trading so no trades to input in, but looking forward to using it.

Reply With Quote
The following user says Thank You to sand53 for this post:
 
(login for full post details)
  #904 (permalink)
Washington DC
 
Experience: Intermediate
Platform: InvestorRT
Broker: TD Ameritrade, AMP/CQG
Trading: ES
 
Posts: 206 since Aug 2014
Thanks: 74 given, 269 received

TDA reduced my ES commission today. When I round trip commission in "Instrument List" sheet, commission on all past trades are changed. How do I enter a new commission schedule in the excel spreadsheet without effecting the past trades?

Reply With Quote
The following user says Thank You to cogito for this post:
 
(login for full post details)
  #905 (permalink)
Durham, NC
 
 
Posts: 48 since Oct 2014
Thanks: 0 given, 21 received

Is there a version of the Excel template that isn't a .rar file?

Reply With Quote
 
(login for full post details)
  #906 (permalink)
Poland
 
Experience: Intermediate
Platform: Multicharts Easy Language
Broker: AMP, LMAX
Trading: MES, ES
 
Posts: 17 since Jul 2009
Thanks: 14 given, 0 received

Hello,
maybe someone know how to do something like this in the journal (printable basic information about the trade and screenshot of the trade)?
Like here: trading-journal-spreadsheet.com/wp-content/gallery/default/tradesummary.jpg
Any ideas?
Thanks
Alex

Reply With Quote
 
(login for full post details)
  #907 (permalink)
Brisbane, Queensland, Australia
 
 
Posts: 121 since Aug 2013
Thanks: 75 given, 97 received

Greatly appreciate the work that was done by those in this thread...in Journal 4.5...and to tangibly return the favour I have quickly built a file on the concepts in J4.5 but with a good dose of psychology trading...(mainly because this is where I personally make all my errors...). The following summary is only for my last 4 trades so ignore the stats...but the summary does outline the variables I have added to those started in J4.5...(thanks again to the group for the idea of followed rules and not followed rules)...anyway for what it is worth here is the screen shot...hope it helps someone like this thread has helped me...Cheers BlueRoo


Reply With Quote
The following 2 users say Thank You to BlueRoo for this post:
 
(login for full post details)
  #908 (permalink)
india+maharashtra
 
 
Posts: 2 since Feb 2015
Thanks: 2 given, 0 received

hi everyone, can anyone post a journal where there is an option also to take adds in an open position and then can do the multiple exits... currrently what i am looking from first page is only position and multiple exits.

Reply With Quote
 
(login for full post details)
  #909 (permalink)
Czech Republic
 
Experience: Beginner
Platform: NinjaTrader
Trading: E7, M6E
 
petrmac's Avatar
 
Posts: 175 since Jun 2011
Thanks: 275 given, 210 received

Hello,

haven't been around for some time, so sorry for not answering messages and such. I have created a github project for the source code of the importer, if anyone has the appetite to change it himself.
The address of the project is: https://github.com/petrmac/NTResultsImport
Should be set up as public project so feel free to change or contribute to your liking. In case you have any issues accessing it, please let me know.

Since time constrained, I will not have much time to fix it myslef, so I can't promise it will be mainatained going forward. I might be able to fix the current issues and port it to work with the latest 4.5 version.



Cheers

Petr

Visit my futures io Trade Journal Reply With Quote
The following user says Thank You to petrmac for this post:
 
(login for full post details)
  #910 (permalink)
Tampa FL
 
Experience: Intermediate
Platform: Ninja Trader
Trading: Futures
 
Posts: 4 since Mar 2015
Thanks: 3 given, 1 received

Hi I traid to open the file for the Journal trade but I could not ....... what program do you use to open this file?

thanks

Reply With Quote
 
(login for full post details)
  #911 (permalink)
Site Administrator
Swing Trader
Data Scientist & DevOps
Manta, Ecuador
 
Experience: Advanced
Platform: My own custom solution
Trading: Emini Futures
 
Big Mike's Avatar
 
Posts: 49,339 since Jun 2009
Thanks: 32,016 given, 96,540 received


ECHOTRADER View Post
Hi I traid to open the file for the Journal trade but I could not ....... what program do you use to open this file?

thanks

Latest version of WinRAR

WinRAR archiver, a powerful tool to process RAR and ZIP files

Mike

We're here to help -- just ask

For the best trading education, watch our webinars
Searching for trading reviews? Review this list

Follow us on Twitter, YouTube, and Facebook

Support our community as an Elite Member:
https://futures.io/elite/
Follow me on Twitter Visit my Facebook Visit my futures io Trade Journal Reply With Quote
The following user says Thank You to Big Mike for this post:
 
(login for full post details)
  #912 (permalink)
Bamberg, Germany
 
Experience: Beginner
Platform: Sierra Chart
Broker: IB, SierraCharts data
Trading: MES, FDXM
 
Posts: 1,090 since Oct 2014
Thanks: 14,950 given, 2,589 received

Over the past few months I have used various journaling files and I know there are excellent excel files on this thread but I use Excel for Mac 2011, which had problems with the macros, and TWS so I wanted my own simple solution. I created my own "macro free lite" journal that tracks:
Sum %R
Avg %R
compares different instruments and systems
equity curve over 12 months
compares performance over days of the week
Sum %R for trading results

Here is the journal if anyone is interested. There are directions included, no macros, no protection so it can be easily modified and its for Mac excel 2011.

Attached Files
Register to download File Type: xlsx PL-worksheet2015.xlsx (913.8 KB, 641 views)
Visit my futures io Trade Journal Reply With Quote
The following 11 users say Thank You to JohnS for this post:
 
(login for full post details)
  #913 (permalink)
MN
 
Experience: Intermediate
Platform: NinjaTrader
 
Posts: 103 since Mar 2010
Thanks: 461 given, 81 received


JohnS View Post
Over the past few months I have used various journaling files and I know there are excellent excel files on this thread but I use Excel for Mac 2011, which had problems with the macros, and TWS so I wanted my own simple solution. I created my own "macro free lite" journal that tracks:
Sum %R
Avg %R
compares different instruments and systems
equity curve over 12 months
compares performance over days of the week
Sum %R for trading results

Here is the journal if anyone is interested. There are directions included, no macros, no protection so it can be easily modified and its for Mac excel 2011.

This is great! Thank you very much!!!

rptrader

Reply With Quote
The following user says Thank You to rptrader for this post:
 
(login for full post details)
  #914 (permalink)
Tehran/Iran
 
Experience: Intermediate
Platform: NinjaTrade
Trading: Stocks, CFDs, Futures
 
Posts: 1 since Jul 2015
Thanks: 0 given, 0 received

Hi fellows !
Great thanks to you Mike and other guys for the great effort you put into making this wonderful journal.
The thing I and my friends as beginners encountered first while seeing this threat is that there are a lot to take in this threat, which makes journaling and understanding this template a very difficult and cumbersome thing to do !
What I'm trying to say is that, it would be awesome to make a tutorial video on applying journaling in this template, explaining all the details and how to dos in 15 to 30 minutes ! do you think it's possible guys ? anyone wanna help us through ?

Reply With Quote
 
(login for full post details)
  #915 (permalink)
London UK
 
Experience: None
Platform: Ninja Trader 7
Broker: AMP, CQG
Trading: NQ
 
Posts: 100 since Jul 2014
Thanks: 36 given, 38 received

Thank you all who contributed to this journal.
May I ask off more detailed explanation regarding Benchmark? please?
In "Readme" is stated - Maximum favorable excursion while in the trade (before exit)

Is my understanding correct if let say am in long position and the price is rising and I close the trade for a currant price and the price didn't made any higher (recent) swing my Benchmark should be 0. Because I close it for the highest price possible at that moment with limit order. With market order I should state it as 1.
However if I am again in long position and the price create a swing and start retracing downwards and then I close my trade (let say I was hoping for break through of Resistance and it didn't happen) I should count the amount of ticks from the high of the swing's high to my close level which could be let say 20 ticks so I should enter 20 as my Benchmark. Is that correct please?

Another Question would be:
How do I enter 3 entry positions if I am entering as a ladder entry and then close all positions at once. So I build first trial position with initial SL and then once the position prove correct I enter another contract and if done correctly my SL should be above the second entry so in theory I am not risking any of my portfolio money. And then if the second position prove correct third contract is entered on the same bases as the second one. Therefore I have used only one SL and I have scaled in to the trade.
Should I journal it as 3 separate trades?

And the last question:
Is there a way how to add another "Comment/Thoughts" field. I am taking screenshots after the trade and make videos and I would like to Hyperlink them to the journal. Or should I make a separate file including all the comments and thoughts and screenshots and video and place only the hyperlink into the journal? I am not very good with Excel that is why I am asking such a questions.

Thank you for your (whoever you are ) kind answer and your time to do so.

Visit my futures io Trade Journal Reply With Quote
 
(login for full post details)
  #916 (permalink)
Site Moderator
London UK
 
Experience: Beginner
Platform: CQG
Broker: S5
Trading: Futures
 
xplorer's Avatar
 
Posts: 5,264 since Sep 2015
Thanks: 13,183 given, 12,392 received


milosv View Post
Thank you all who contributed to this journal.
May I ask off more detailed explanation regarding Benchmark? please?
In "Readme" is stated - Maximum favorable excursion while in the trade (before exit)

Is my understanding correct if let say am in long position and the price is rising and I close the trade for a currant price and the price didn't made any higher (recent) swing my Benchmark should be 0. Because I close it for the highest price possible at that moment with limit order. With market order I should state it as 1.
However if I am again in long position and the price create a swing and start retracing downwards and then I close my trade (let say I was hoping for break through of Resistance and it didn't happen) I should count the amount of ticks from the high of the swing's high to my close level which could be let say 20 ticks so I should enter 20 as my Benchmark. Is that correct please?

Another Question would be:
How do I enter 3 entry positions if I am entering as a ladder entry and then close all positions at once. So I build first trial position with initial SL and then once the position prove correct I enter another contract and if done correctly my SL should be above the second entry so in theory I am not risking any of my portfolio money. And then if the second position prove correct third contract is entered on the same bases as the second one. Therefore I have used only one SL and I have scaled in to the trade.
Should I journal it as 3 separate trades?

And the last question:
Is there a way how to add another "Comment/Thoughts" field. I am taking screenshots after the trade and make videos and I would like to Hyperlink them to the journal. Or should I make a separate file including all the comments and thoughts and screenshots and video and place only the hyperlink into the journal? I am not very good with Excel that is why I am asking such a questions.

Thank you for your (whoever you are ) kind answer and your time to do so.

hi milosv

regarding question 1 on MFE I believe your understanding to be correct.

For question 3 (Excel) I write my own comments directly in Excel cells (e.g. one comment per trade), and I do use the hyperlink formula for screenshots, you can use it for videos as well.

I hope it helps, I will let somebody else take up the other question

Reply With Quote
The following 2 users say Thank You to xplorer for this post:
 
(login for full post details)
  #917 (permalink)
New City, NY 10956
 
Experience: Intermediate
Platform: IRT/Sierra/Stage5 Trading
Trading: futures
 
Posts: 12 since May 2011
Thanks: 9 given, 1 received

Hi

I am trying to add upto 5 exits. can someone please explain how I can add upto 5 exits. I tried to do it but nothing is calculating after I add cells and make the changes. thanks.

J.

Follow me on Twitter Reply With Quote
 
(login for full post details)
  #918 (permalink)
Lviv, Ukraine
 
 
Posts: 18 since Mar 2016
Thanks: 1 given, 3 received

I suppose that any trading is need to keep on a Profit factor, an Avg. Profit to Avg. Loss Ratio, a % of Profitable Trades.

Reply With Quote
 
(login for full post details)
  #919 (permalink)
atlanta, georgia, usa
 
Experience: Advanced
Platform: tradestation
Trading: futures
 
Posts: 5 since Jul 2015
Thanks: 0 given, 1 received

Sorry, this is a long thread... i thought I'd just cut right to it... I'm looking around for a new trading journal and i like the looks of this one you've put together. I use Rithmic/Multicharts, so my question is can I automatically import my trades into the software? I was doing this in Tradervue, but I'm not going to pay $50 a month anymore. Thanks.

Reply With Quote
 
(login for full post details)
  #920 (permalink)
NANTES + WESTERN FRANCE
 
 
Posts: 1 since Dec 2016
Thanks: 2 given, 1 received


Big Mike View Post
I'm on a mission to improve my Excel trade journal.

I'd like to hear input on what metrics you guys measure in your journal. For instance:
  • Sharpe ratio
  • Expectancy
  • Win/Loss Dollar Ratio
  • Win Percentage
  • Dollar gain per trade put on
  • Account balance
  • Risk % per trade
  • Maximum drawdown
  • Realized MAE/MFE
  • Unrealized MFE (benchmark potential)

I was reading Brett's "Enhancing Traders Performance" book and it gave me the idea to consider categorizing days themselves, like uptrend, downtrend, reversal day, range bound, etc. I was wondering, do any of you guys do this and what have you found?

Mike

My actual trading journal is very simple as of a beginner's one.
You can see it
Thanks for the detailed exemple and sharing your ideas.
I find categorizing days a great idea. I will adopt it.
Justin TC

Attached Files
Register to download File Type: docx JTC Paper trading 2016.docx (51.1 KB, 206 views)
Reply With Quote
The following user says Thank You to Justin TC for this post:
 
(login for full post details)
  #921 (permalink)
bs as , argentina
 
Experience: Intermediate
Platform: ninja trader
Trading: CL
 
Posts: 22 since Sep 2016
Thanks: 15 given, 17 received

Hi, thanks for this amazing excel. I am trying to start use it, but I am having problems. When I use the 2nd row in the journal, my results are out of sense. I tried in different excels versions and i have the same problem.

Thank you in advance

Attached Thumbnails
Click image for larger version

Name:	excel.png
Views:	451
Size:	151.3 KB
ID:	239695  
Reply With Quote
 
(login for full post details)
  #922 (permalink)
Site Moderator
London UK
 
Experience: Beginner
Platform: CQG
Broker: S5
Trading: Futures
 
xplorer's Avatar
 
Posts: 5,264 since Sep 2015
Thanks: 13,183 given, 12,392 received


Cesar12 View Post
Hi, thanks for this amazing excel. I am trying to start use it, but I am having problems. When I use the 2nd row in the journal, my results are out of sense. I tried in different excels versions and i have the same problem.

Thank you in advance

Hi Cesar - are you able to attach a version of the file with some data that show the problem?

Reply With Quote
 
(login for full post details)
  #923 (permalink)
bs as , argentina
 
Experience: Intermediate
Platform: ninja trader
Trading: CL
 
Posts: 22 since Sep 2016
Thanks: 15 given, 17 received


xplorer View Post
Hi Cesar - are you able to attach a version of the file with some data that show the problem?

Hi xplorer. I am sorry for my bad english. I attached my version. The problem is 2nd row in the journal. the results are bad calculated, i dont understand why.

thank you!

Attached Files
Register to download File Type: zip Journal 4.5.zip (1.04 MB, 252 views)
Reply With Quote
The following user says Thank You to Cesar12 for this post:
 
(login for full post details)
  #924 (permalink)
Site Moderator
London UK
 
Experience: Beginner
Platform: CQG
Broker: S5
Trading: Futures
 
xplorer's Avatar
 
Posts: 5,264 since Sep 2015
Thanks: 13,183 given, 12,392 received


Cesar12 View Post
Hi xplorer. I am sorry for my bad english. I attached my version. The problem is 2nd row in the journal. the results are bad calculated, i dont understand why.

thank you!

There are some hidden columns in the spreadsheet where other entries are stored - but they appear to be entries related to a different instrument.

See the picture with the cells circled in red.

If you unhide those columns and remove those values it should work.


Reply With Quote
The following 2 users say Thank You to xplorer for this post:
 
(login for full post details)
  #925 (permalink)
bs as , argentina
 
Experience: Intermediate
Platform: ninja trader
Trading: CL
 
Posts: 22 since Sep 2016
Thanks: 15 given, 17 received


xplorer View Post
There are some hidden columns in the spreadsheet where other entries are stored - but they appear to be entries related to a different instrument.

See the picture with the cells circled in red.

If you unhide those columns and remove those values it should work.


really thank you for your help! It is working well right now. This was my mistake.

thank you xplorer!

Reply With Quote
The following user says Thank You to Cesar12 for this post:
 
(login for full post details)
  #926 (permalink)
Site Moderator
London UK
 
Experience: Beginner
Platform: CQG
Broker: S5
Trading: Futures
 
xplorer's Avatar
 
Posts: 5,264 since Sep 2015
Thanks: 13,183 given, 12,392 received


Cesar12 View Post
really thank you for your help! It is working well right now. This was my mistake.

thank you xplorer!

No problem, glad you sorted it

Reply With Quote
 
(login for full post details)
  #927 (permalink)
bs as , argentina
 
Experience: Intermediate
Platform: ninja trader
Trading: CL
 
Posts: 22 since Sep 2016
Thanks: 15 given, 17 received

This excel is amazing! It is very important tool in my road to become a professional trader! Really thank everyone who did this work! I want to ask if there are more excel like this but for options or stocks

Sent using the futures.io mobile app

Reply With Quote
 
(login for full post details)
  #928 (permalink)
NYC NY
 
 
Posts: 1 since May 2017
Thanks: 1 given, 0 received

Just found this and thank you very much. I have everything pretty much setup except that I also trade forex. Having an issue with the instrument setup. Sometime i trade mini and other times I will use micro lots. Suggestions on how to setup EUR/USD pair as an example. Thanks

Reply With Quote
 
(login for full post details)
  #929 (permalink)
Site Moderator
London UK
 
Experience: Beginner
Platform: CQG
Broker: S5
Trading: Futures
 
xplorer's Avatar
 
Posts: 5,264 since Sep 2015
Thanks: 13,183 given, 12,392 received


alyzar View Post
Just found this and thank you very much. I have everything pretty much setup except that I also trade forex. Having an issue with the instrument setup. Sometime i trade mini and other times I will use micro lots. Suggestions on how to setup EUR/USD pair as an example. Thanks

Try adjusting the value in column AZ (Point Value) and BA (Tick Size). The spreadsheet uses those to give you PnL so by varying those numbers you should get the result you want in Forex as well.

Reply With Quote
 
(login for full post details)
  #930 (permalink)
Dallas, TX
 
Experience: Intermediate
Platform: TradeStation/Sierra Chart
Broker: Tradestation
Trading: ES
 
ChrisTinaBruce's Avatar
 
Posts: 65 since Oct 2012
Thanks: 43 given, 32 received

Anyone use this spreadsheet in Google Sheets? I do not have Excel and opening the file I am seeing Invalid inputs such as instruments tab, etc.

Follow me on Twitter Visit my Facebook Reply With Quote
 
(login for full post details)
  #931 (permalink)
Los Angeles CA
 
 
Posts: 1 since Dec 2016
Thanks: 0 given, 0 received

Just came across this journal. It is exactly what I have been looking for. Thank you to all you put this together. I am wondering if there is any continuing support for this as the last post is a little older. Thank you for any response.

Elkidd

Reply With Quote
 
(login for full post details)
  #932 (permalink)
Site Moderator
London UK
 
Experience: Beginner
Platform: CQG
Broker: S5
Trading: Futures
 
xplorer's Avatar
 
Posts: 5,264 since Sep 2015
Thanks: 13,183 given, 12,392 received


elkidd14 View Post
Just came across this journal. It is exactly what I have been looking for. Thank you to all you put this together. I am wondering if there is any continuing support for this as the last post is a little older. Thank you for any response.

Elkidd

There is no formal support as most people are just donating their time. If you need something simply ask.

Reply With Quote
 
(login for full post details)
  #933 (permalink)
London, England
 
Experience: Intermediate
Platform: MetaTrader
Broker: InfinityBrokers/Transact
Trading: ES
 
Posts: 17 since Nov 2009
Thanks: 2 given, 2 received


xplorer View Post
There is no formal support as most people are just donating their time. If you need something simply ask.

Is there an Upload utility available for Ninja 8?

Thanks.

Reply With Quote
 
(login for full post details)
  #934 (permalink)
Site Moderator
London UK
 
Experience: Beginner
Platform: CQG
Broker: S5
Trading: Futures
 
xplorer's Avatar
 
Posts: 5,264 since Sep 2015
Thanks: 13,183 given, 12,392 received


nkp9999 View Post
Is there an Upload utility available for Ninja 8?

Thanks.

What do you mean by Upload utility for NT8?

Reply With Quote
 
(login for full post details)
  #935 (permalink)
London, England
 
Experience: Intermediate
Platform: MetaTrader
Broker: InfinityBrokers/Transact
Trading: ES
 
Posts: 17 since Nov 2009
Thanks: 2 given, 2 received


xplorer View Post
What do you mean by Upload utility for NT8?

OOPs, sorry, I wanted to load the journal from Ninja 8 trade data. There is a utility that allows you to load data in NT7(I have not used it), called ResultsImport.

I was hoping that there would be one to extract the Ninja 8 trades in CSV format and then upload this data into the Journal.

Apologies for not being clear

Thanks.

Reply With Quote
The following user says Thank You to nkp9999 for this post:
 
(login for full post details)
  #936 (permalink)
Site Moderator
London UK
 
Experience: Beginner
Platform: CQG
Broker: S5
Trading: Futures
 
xplorer's Avatar
 
Posts: 5,264 since Sep 2015
Thanks: 13,183 given, 12,392 received


nkp9999 View Post
OOPs, sorry, I wanted to load the journal from Ninja 8 trade data. There is a utility that allows you to load data in NT7(I have not used it), called ResultsImport.

I was hoping that there would be one to extract the Ninja 8 trades in CSV format and then upload this data into the Journal.

Apologies for not being clear

Thanks.

No problem. Sorry I can't help, it's not a functionality I'm familiar with.

Reply With Quote
 
(login for full post details)
  #937 (permalink)
London England
 
 
Posts: 2 since Mar 2015
Thanks: 0 given, 1 received

Hello everyone!

I've used this spreadsheet for years, awesome journal - does everything you could need!

I have a strange problem though with it this year, I have 5 years of trading history completed but it doesn't seem to like going on to a 6th year, when I try and input trades for 2020 it doesn't create a new year in "Time Period statistics" like normal. Has anyone had that issue before? Have I maxed out the sheet or does it just not like 2020? It updates the stats on the journal page including equity curve etc for this year, just has a problem with the time period tab?


Thanks in advance to anyone that knows the issue

Reply With Quote
 
(login for full post details)
  #938 (permalink)
Site Moderator
London UK
 
Experience: Beginner
Platform: CQG
Broker: S5
Trading: Futures
 
xplorer's Avatar
 
Posts: 5,264 since Sep 2015
Thanks: 13,183 given, 12,392 received


DanT01 View Post
Hello everyone!

I've used this spreadsheet for years, awesome journal - does everything you could need!

I have a strange problem though with it this year, I have 5 years of trading history completed but it doesn't seem to like going on to a 6th year, when I try and input trades for 2020 it doesn't create a new year in "Time Period statistics" like normal. Has anyone had that issue before? Have I maxed out the sheet or does it just not like 2020? It updates the stats on the journal page including equity curve etc for this year, just has a problem with the time period tab?


Thanks in advance to anyone that knows the issue

Hi, there's more than one spreadsheet mentioned in this thread. You should specify exactly which one you are using.

Reply With Quote
 
(login for full post details)
  #939 (permalink)
London England
 
 
Posts: 2 since Mar 2015
Thanks: 0 given, 1 received


xplorer View Post
Hi, there's more than one spreadsheet mentioned in this thread. You should specify exactly which one you are using.

Ah apologies, you make a very good point! The big Mike original journal that you helped Cesar fix an issue with on the page before

Reply With Quote
The following user says Thank You to DanT01 for this post:
 
(login for full post details)
  #940 (permalink)
Site Moderator
London UK
 
Experience: Beginner
Platform: CQG
Broker: S5
Trading: Futures
 
xplorer's Avatar
 
Posts: 5,264 since Sep 2015
Thanks: 13,183 given, 12,392 received


DanT01 View Post
Ah apologies, you make a very good point! The big Mike original journal that you helped Cesar fix an issue with on the page before

I just tried it and I am experiencing the same issue, it seems it won't go beyond Year 5.

I couldn't find anything obvious/easy such as a setting to change to extend the calculations beyond that and I don't have time to analyze the code, sorry.


I would have said 'your best bet is to get in touch with the author' but it looks like he has not logged on since 2015.

It's probably not ideal but you may want to consider creating a 2nd file and starting the next 5 years there. Either that or someone else who has the time can dig into the file for you and find out how to extend the system to more than just 5 years, sorry I can't do it right now.

Good luck.

Reply With Quote
The following 3 users say Thank You to xplorer for this post:
 
(login for full post details)
  #941 (permalink)
Prague, Czechia
 
Experience: Intermediate
Platform: Sierra Chart
Broker: Sierra Data
Trading: GBL
 
Posts: 26 since Jan 2019
Thanks: 0 given, 15 received

Great journal! (Journal 4.5) Thanks for hard work.

I have one question. I'm trading with (eurex) everything is settled and calculated in EUR. How can I change a currency everywhere to ?

Thanks

Reply With Quote


futures io Trading Community Psychology and Money Management > Trading Metrics for journals/record keeping


Last Updated on April 29, 2020


Upcoming Webinars and Events
 

Journal Challenge!

February
 

Battlestations!

March
     



Copyright © 2021 by futures io, s.a., Av Ricardo J. Alfaro, Century Tower, Panama, +507 833-9432, info@futures.io
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.
no new posts