Going with 60 minutes flow, Excel Tracker

SamFisher · #1 23rd September 2008, 09:39 AM

Hello Friends,
If anyone trading Great Saint's 'Going with 60 minutes flow', I have built a excel file to track positions. I am using it so might be usefull for anyone following it. So posted it here.

Sample:

Good luck

SamFisher · #2 1st October 2008, 04:28 PM

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.

rkkarnani · #3 2nd October 2008, 05:56 AM

Simply awesome friends!!! Great initiative!!!

anupsoni · #4 2nd October 2008, 10:55 AM

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.

SamFisher · #5 2nd October 2008, 11:22 AM

Quote:

Originally Posted by anupsoni

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/219...tml#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

anupsoni · #6 2nd October 2008, 11:38 AM

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 · #7 2nd October 2008, 12:12 PM

Quote:

Originally Posted by anupsoni

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 · #8 7th October 2008, 02:39 PM

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.

GORAI · #9 7th October 2008, 08:47 PM

amazing!!!

The Following 24 Users Say Thank You to SamFisher For This Useful Post:
Ank!t007 (26th September 2008), chachi (2nd October 2008), chintan786 (7th October 2008), faith (2nd October 2008), gvnarendra (2nd October 2008), kapil123 (7th October 2008), kr1nitin (27th September 2008), MaxX (25th September 2008), mayur1154 (1st October 2008), milkyblack (24th September 2008), Muktha (23rd September 2008), novice1 (23rd September 2008), rajendrani (19th October 2008), rajfal (7th October 2008), rakeshluthra430 (1st October 2008), rkkarnani (2nd October 2008), saharadirect (23rd October 2008), sandeep721 (8th October 2008), segul (2nd October 2008), senty (29th October 2008), ShiftyNifty (7th October 2008), SMART_Trader (1st October 2008), TVENKAT (2nd October 2008), VJAY (23rd September 2008)

The Following User Says Thank You to rkkarnani For This Useful Post:
SamFisher (2nd October 2008)

The Following 2 Users Say Thank You to SamFisher For This Useful Post:
AmritaBasu (7th November 2008), anupsoni (2nd October 2008)

The Following User Says Thank You to anupsoni For This Useful Post:
SamFisher (2nd October 2008)

The Following User Says Thank You to SamFisher For This Useful Post:
anupsoni (2nd October 2008)

The Following 2 Users Say Thank You to SamFisher For This Useful Post:
AmritaBasu (7th November 2008), VJAY (7th October 2008)

The Following User Says Thank You to GORAI For This Useful Post:
SamFisher (8th October 2008)