MY Excel stock tracker

[pnsonavane]

no sir i want this for excel 2007

 

[zulu3in]

Amazing Sheet bro. Billion claps to u. I Love Excel and i respect people like you who works on excel

 

[oliveegree]

Hi amit,

I have a project in financial tool.its been outsourced to me.I saw ur excel tracker and the work you have done is good.Its a paid project...will you be interested to work on it... contact me at [email protected],09861311173..
thanks
shailesh

 

[sprintravi75]

thanks man i have not tried but appears to be too good

 

[pa_sundar]

Thanks for sharing the code

 

[averagecalls]

Re: MY Excel stock tracker - UPDATED 1.3

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

thanks to the efforts of all those people who save the money of those learners and small traders by their efforts. thanks a lot. thanks from heart.

 

[khardik]

Is there a way that we can get all the yahoo symbols for all the bse and nse stocks for yahoo?

Rgds,
Hardik Kanabar

 

[karthikg25]

Hi,
Its a wonderful tool and thanks for the contribution!

Jus wanted an info frm u. How to get quotes for my stock; where i get the symobls.

Say I want quote for bharti airtel, tried copying BHARTIARTL.BO as given in yahoo money but dint get quotes.

If you can tel me wher can i find symbols, it will be a gr8 help.

 

[ravinder_1215]

Hi,
Its a wonderful tool and thanks for the contribution!

Jus wanted an info frm u. How to get quotes for my stock; where i get the symobls.

Say I want quote for bharti airtel, tried copying BHARTIARTL.BO as given in yahoo money but dint get quotes.

If you can tel me wher can i find symbols, it will be a gr8 help.

try bhartiart.ns (nse symbol of bharti airtel)

thanks!

 

[siddharthalagh]

:thumb: Thanks. excellent tool.

:clap: