MY Excel stock tracker

famtac · #**141** 9th February 2008, 11:48 AM

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

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

rajkumar555 · #**142** 10th February 2008, 12:28 PM

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

vishluck · #**143** 17th May 2008, 07:12 PM

Dear Mr. Amith,
Thanks for this wonderfull excel.
I need ur help. Will it be possible for u to provide the 3 months average volume of each stock which is entered in the excel sheet.

Like below:
Get Data Stock
Open
High
Low
Current Price
Volume
Three months average volume.

I can find this in ***** finance. I am sure u will be able to provide it as well. Pls confirm if this is possible

Indrajeet · #**144** 14th June 2008, 02:27 PM

Hey.... cool stuff... keep it up!!!!

godisherbhul · #**145** 21st June 2008, 11:43 PM

Hi
It is a well done job. But i want to know that how to add new stocks of my choice in the work sheet.

Please let me know.
with lots of thanks,
godisherbul.

xumit · #**146** 24th June 2008, 03:03 PM

Great script, but I just want to know, which site is used to fetch data's(site seemed to be **** means banned by admin)

talk2prv · #**147** 9th August 2008, 09:18 PM

Hi Amit,

Thanks for the excel Utility. Great work!

Praveen

Similar Threads for: MY Excel stock tracker
Thread	Thread Starter	Forum	Replies	Last Post
Need BSE Stock Price List in Electronic form (Excel, CSV format)	gharesh	End of Day	6	24th September 2008 10:24 AM
An anatomy of the Stock Market! - Bull & Bear Market Cycles	Traderji	Trading Psychology	57	6th July 2008 02:32 PM
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