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

You can use Transpose to change the data around as you want it.
Highlight all the data including headings, then click <copy. Move the
cursor to a blank area of the sheet below your existing data, then Edit
| Paste Special | Transpose (click) then OK and <Esc.

This should do what you want - you can then delete your original data.

Hope this helps.

Pete

thanks for replyin guys but if its possible pls hav a look at the
Tracker.
i can definitly change the data but could not refresh the transposed
data using the button GET DATA. Can u pls suggest something so that i
can transpose as well as refresh the transposed data.
THanks for all ur hlp


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

The VBA code of your sample Workbook is password protected, so there's
nothing I can do to amend it.

Cheers,
--
AP

"ronald_peterson"
<ronald_peterson.28mkgm_1149000001.1965@excelfor um-nospam.com a écrit dans
le message de news:
...

thanks for replyin guys but if its possible pls hav a look at the
Tracker.
i can definitly change the data but could not refresh the transposed
data using the button GET DATA. Can u pls suggest something so that i
can transpose as well as refresh the transposed data.
THanks for all ur hlp


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

hey Ardus, the code is goodwork. pls check it.
thanks


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

I'm sure it's good work, but it's password protected, so I can't have a look
at it to see how it works.

Cheers,
--
AP

"ronald_peterson"
<ronald_peterson.28mle3_1149001212.2835@excelfor um-nospam.com a écrit dans
le message de news:
...

hey Ardus, the code is goodwork. pls check it.
thanks


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

Hi,

Not totally sure about the flipping of data. I think you might be able
to achieve it by copying your data, then doing EditPaste
SpecialTranspose.

For the highlighting of positive and negative stocks, just do
Conditional Formatting. (FormatConditional Formatting). Set one
condition to greater than 0, the other to less than 0. Then add the
formatting that you want.

Hope that helps,

SamuelT


--
SamuelT
------------------------------------------------------------------------
SamuelT's Profile: http://www.excelforum.com/member.php...o&userid=27501
View this thread: http://www.excelforum.com/showthread...hreadid=546695