MY Excel stock tracker

[amityt]

Thnx for this updated version.I am new to the board and would post feedback as relevant.
Thanks indeed !

 

[Prasanth.P]

Re: MY Excel stock tracker - UPDATED 1.3

Hai Amitkr
Thanks for the valued information
With regards
Prasanth.P

 

[Pebu]

Excellent work bro, I want to categorize my sheet by BANKS, REL GROUP,TATA GROUP in various sheets with volume and increase,decrease by color please guide me

 

[madhava36]

HINDUNILVR.NS
I am not getting data from ******.Please guide me with the proper code.
Thanks.

madhava36

 

[joenguyen]

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 ************* , 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 ***** 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

Thx for your great contribution!

 

[lalitkumawat]

hello to all

 

[k_sarathy]

Where can i find new symbols to add? i think the website name is replaced with ***

 

[excelcore]

Thanks for this xl files

 

[famtac]

Re: MY Excel stock tracker - UPDATED 1.3

hey amit, great post... one ting is sure., ur good at excel.. im a newbie.. can u suggest some formula with which i can maintain my portfolio in excel??
like daily buy sell along wid the prices so i know my nett holding position at any given point of time and also my profit or loss????

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 ************* , 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 ***** 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

 

[rajkumar555]

sir
i have joined the forum today.
iam just a beginner in stock markets.
I am really thrilled to see yr excel work book. it is simply great.
rajkumar