Hi guys, one of my friends developed a Utility for importing Yahoo India
stock quotes into Excel. But it shows the data like this
ABAN.NS ABB.NS ABBP.NS
Open 1135.00 2600.00 278.80
High 1158.00 2600.00 295.00
Low 1112.30 2501.00 278.80
Current 1118.55 2542.70 292.80
Volume 45,045 40,848 93,823
And id like to have it the oher way ie
Stock Open High Low Current
Volume
ABAN.NS 1135.00 1158.00 1112.30 1118.55 45,045
ABB.NS 2600.00 2600.00 2501.00 2542.70 40,848
ABBP.NS 278.80 295.00 278.80 292.80 93,823
Im sure with so many developers here some one would be knowing how to
do it right? It can track any stock any indices,options etcs.
Being a stock trader i do not hav any detailed idea abt VBA or Excel.
So pls help? Also can any fellow boarder tell me how can i change the
colour of stock prices to green for positive and red for negetive?
source code: goodwork
Thanks
Regards
+-------------------------------------------------------------------+
|Filename: MyTracker 1[1].3.zip |
|Download:
http://www.excelforum.com/attachment.php?postid=4822 |
+-------------------------------------------------------------------+
--
ronald_peterson
------------------------------------------------------------------------
ronald_peterson's Profile:
http://www.excelforum.com/member.php...o&userid=34934
View this thread:
http://www.excelforum.com/showthread...hreadid=546695