Going with 60 minutes flow, Excel Tracker

SamFisher

Well-Known Member
#2
Update: Added a new excel file NiftyBook3Adds.xls, it supports additional adds(original file supported only 2 adds) Since system supports max 3 adds I have modified the excel to support it.
 
#4
hello,
plz clarifty if possible for trade on 15.09.08 LONG @4062.

In excel sheet u have exited @4155..?? No adds?? Profit of 93 points.??
How and on which date?

Or it was the difference of Pure and Aggresive.
 
Last edited:

SamFisher

Well-Known Member
#5
hello,
plz clarifty if possible for trade on 15.09.08 LONG @4062.

In excel sheet u have exited @4155..?? No adds?? Profit of 93 points.??
How and on which date?

Or it was the difference of Pure and Aggresive.

This is the exact point of exit from long and entry to long
http://www.traderji.com/equities/21903-going-60min-flow-473.html#post223727

Why no adds? I just started trading on 15th onwords in this system.

PS: This thread is not for discussion on the trade because I am not an expert, Just thought of providing a way to manage record the trade on excel file. Hope you understand :)
 
#6
Thnx cleared to me.

A suggestion in excel sheet u can put dates and time as "insert comment" when ever we are addings in our trades.
If u think, it would be easier to understand for the beginners.
 

SamFisher

Well-Known Member
#7
Thnx cleared to me.

A suggestion in excel sheet u can put dates and time as "insert comment" when ever we are addings in our trades.
If u think, it would be easier to understand for the beginners.
Hi Anup,
Yes your suggestion is valid but the idea behind this excel file is to help active traders who are actually following the trade according the the 60 min flow thread. If you are a trader you hardly interested in storing time of adds etc as there are other things to worry about.

Yes it could be great if someone tracks these changes along with the time of adds etc, that would then be a nice flow tool for anyone trying to learn the 60 minutes flow along with the corresponding chart. :)
 

SamFisher

Well-Known Member
#8
There was a bug in the excel file with 4 adds, Updated file attached on the first post. Please use that.

If you just want to keep using existing excel file with your data, and want to have support for 4 adds then do this....

  • First open your excel file
  • Make a back up copy in case something goes wrong
  • Go to menu 'Tools/Protection/Unprotect Sheet'
  • Click on the cell 'I7' (= eye 7)
  • Copy the following formula and paste it to the I7 Cell
  • =IF(B7="L",IF(F7="",IF(E7="",IF(D7="",IF(C7="",0,1),2),3),4),IF(P7="",IF(O7="",IF(N7="",IF(M7="",0,1),2),3),4))
  • Hit enter
  • Now drag the I7 Cell till I100(=eye 100)
  • Now protect your sheet from menu 'Tools/Protection/Protect Sheet'
  • Click ok to the dialogue displayed
  • Save the excel sheet.

If above is confusing please download the file and enter all your trades to the excel file.

:)