Amit's Stock Tracker improved version 1.5

#31
johnbest said:
Hi Amit,

Nice tool.........And that too with Excel...Hats off to you.....Gem ;)

Well tell me one thing what about the various BSE Indices.....:p
When tried only SENSEX data was downloaded....What about others? :D

Have a nice day
JohnBest

You have to enter the yahoo symbol ... you want the data for.

eg.
^BSESN = BSE Sensex
BSE-SMLCAP.BO = BSE Small-Cap

Go to
http://in.finance.yahoo.com/l

Make Type as Indices and search the rest.

Regds
Amit
 
#32
Hi there

Sorry for being late.... but this too works


BSE Code Your Code
SENSEX SENSEX
BSE100 BSE100
BSE200 BSE200
BSE500 BSE500
BSEIT BSE IT
BSECD BSE CD
BSEFMC BSEFMC
BSECG BSE CG
BSEHC BSE HC
TECK TECK
BSEPSU BSEPSU
BANKEX BANKEX
AUTO AUTO
METAL METAL
OILGAS OILGAS
MIDCAP MIDCAP
SMLCAP SMLCAP


Have a nice day
JohnBest
 
#33
Hi,

I have downloaded your software and it is really good.
Rows instead of columns are better.

I request you to do the following changes so that it is really helpful for intra-day sheet.

01. Automatic update from Yahoo since Yahoo offers realtime quotes for registered users. Update option can be left to users to mention in seconds.

02. Total value of stock bought & sold.

03. Average trade price i.e value devided by volume ( quantity traded ).

03. Previous day close of the stock in addition to High, low, close

04. Can I use the filte to browse stocks during intra-day?

05. Can I sort the rows in excel during intraday ?

06. any method by which I can hace Nifty Futures quotes in Excel

07. I have Excel from Office 97 - can this file be saved in that version?

If you can improve the version as suggested by me, it is really helpful to me as well for others.

Please reply me to [email protected]

Regards
Vazu
 
Last edited:
#34
Amit,

Your Stock Tracker improved version 1.7 were really good one.

But I am having connection problem. As I am using this file from my Office to update my Portfolio everyday. But now a days yahoo.com is blocked at my office. So I am not able download the latest price of shares added.

So is there any other way for this Query?

Eagarly waiting for your positive reply. You can reply me at [email protected]

Thanks in advance.
 
#35
Hi,

I have recently downloaded it. it's really good . Is it possible to add pivot points based on last days data or atleast the yesterdays low and high in the watchlist ?
 
#38
Amit,

Your Stock Tracker improved version 1.7 were really good one.

But I am having connection problem. As I am using this file from my Office to update my Portfolio everyday. But now a days yahoo.com is blocked at my office. So I am not able download the latest price of shares added.

So is there any other way for this Query?

Eagarly waiting for your positive reply. You can reply me at [email protected]

Thanks in advance.

Yahoo blocked :eek:
Usually they block mail.yahoo.com
U sure u cant access http://in.finance.yahoo.com
 
#40
Re: Amit's Stock Tracker improved version 1.7

Hi,

Why don't you add a column in intra-day for prev.close and also auto-refreshing.?

These will be great tools for intra-day.

Thankz a lot for your software!

Regards
Vazu
 

Similar threads