Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
PlS Help ABT STOCK TRACKER
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to return the Number of shares for a given stock code for a given portfolio | Excel Discussion (Misc queries) | |||
Web Query With Multiple Stock Symbols & Stock Scouter | Excel Worksheet Functions | |||
How can I use Dutch (NL) stock MSN MoneyCentral Stock in Excel | Excel Worksheet Functions | |||
Excel Stock List | Excel Discussion (Misc queries) | |||
stock consignment tracker | Excel Worksheet Functions |