MY Excel stock tracker

krisbangalore · #**131** 10th January 2008, 07:19 AM

Hi
Thanks for the superb software. I mostly do bits and piece trading in BSE
So from where I can get the market code and other details for the shares that i am holding

itsmerahul · #**132** 10th January 2008, 11:39 AM

from where we can get the symbols

amityt · #**133** 11th January 2008, 08:30 PM

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

Prasanth.P · #**134** 11th January 2008, 08:33 PM

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

Pebu · #**135** 16th January 2008, 05:58 PM

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 · #**136** 17th January 2008, 12:36 PM

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

madhava36

joenguyen · #**137** 17th January 2008, 02:42 PM

Quote:

Originally Posted by amitkr

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 ..

Code:

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 · #**138** 17th January 2008, 02:46 PM

hello to all

k_sarathy · #**139** 29th January 2008, 01:38 PM

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

excelcore · #**140** 1st February 2008, 07:47 PM

Thanks for this xl files

Similar Threads for: MY Excel stock tracker
Thread	Thread Starter	Forum	Replies	Last Post
An anatomy of the Stock Market! - Bull & Bear Market Cycles	Traderji	Trading Psychology	59	30th November 2008 12:42 AM
Need BSE Stock Price List in Electronic form (Excel, CSV format)	gharesh	End of Day	8	1st November 2008 07:55 AM
FREE Stock Charts with Excel	TATrader	Technical Analysis	4	16th June 2008 11:16 AM
Indian Stock Markets	hometypist	Equities	9	16th January 2008 05:37 PM
The Deadly Art Of Stock Manipulation Pt1	Joeblack	Trading Psychology	28	29th July 2007 09:13 AM