MY Excel stock tracker

[BigDaddy]

Re: MY Excel stock tracker - UPDATED 1.3

I'm not able to find the excel file. Can you please share the latest version available rite now.

Thanks !

Hil,

Still a noobie as far as trading is concerned so cant help much on that ground..
Am a techie so helping in a way I can ...

I coded an excel sheet capable of downloading quotes ...
So wanted to share it with all you friends..

If you have to closely track a list of scrips this will be of great help...

How to use:

1. UNZIP (using winzip... or whatever u like)
2. Double click on My Tracker.xls
3. A prompt(macro warning) will appear click on Enable macros
4. This sheet downloads data from Yahoo.co.in , so u have to use there symbols. The existing file contains the symbols I used to track.. You can delete them and put your own...
5.(If u r connected to the net )Now click on the Get Data button .. data will be refreshed.

I keep refreshing the data... and also refresh the data EOD.. everyday.

Tip: Login to Yahoo from your computer with the option Remember me on this computer selected... This way the excel sheet gives you LIVE NSE quotes .. BSE quotes are delayed by 15 mins

I hope you will like it...
Any issues please shout back

Thanks..
Amit

Upadated the program to handle more than one worksheet ... So stocks can be placed on diffrent sheets... to keep things clean... check out

Upadated to version 1.2 ... Now displays quotes like 1.21 , 1.26 etc... Initially it was showing only in multiple of 10

Updated to version 1.3 ... Added a sheet for INTRADAY informations

Version 1.4 ... Bug fixed ..

Hey Amit,

Gr8 utility. Downloaded it last nite and now playing with it. Amazing.

a small roadblock though.

If I have more than 48 scripts to view at the same time then I encounter the following problem.

The 49th script shows the rate of 50th script, the 50th script shows the rate of 51st script and so on.

Can u work out a soln. for the same.

Regards,
Sanjoy

 

[kb.manwatkar]

Dear , Not able to find out the excel file. can u guide on this pl..

 

[guptdeepak]

i need stock tracker in excel , please email me [email protected]

 

[prateekparhar]

i also need stock tracker in excel , please email me [email protected]

 

[Var_Nikh]

Pl send "[email protected]"

Regards

 

[khushi00]

I have also done some work in excel plz check

http://www.traderji.com/day-trading/67237-exploring-exploding-stocks-32.html

 

[johnnypareek]

I have also done some work in excel plz check

http://www.traderji.com/day-trading/67237-exploring-exploding-stocks-32.html

File deleted. can u plez again upload? or can send at johnnypareek (at) yaho0.c0m

 

[alagiri64]

Dear Amit!

If you could able to make similar Excel file for Commodities, would be much useful for commodity traders.

 

[preethnfo]

i also need stock tracker in excel , please email me anandeguru @ gmail dot com

 

[khushi00]

File deleted. can u plez again upload? or can send at johnnypareek (at) yaho0.c0m

File was deleted as it exceeded download limit
plz download from here

http://www.mediafire.com/?m7jg8ecfbynt2lp