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

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

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

hey ardes the password is "goodwork". Can u now pls take a look.
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

Too much dependant upon Yahoo queries results.
I give up!

Sorry,
--
AP

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

hey ardes the password is "goodwork". Can u now pls take a look.
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

hey is there is no body in the forum who could hlp me out on this????
Senior members pls 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

Using the procedure Copy | Paste Special | Transpose is like fixing the
values in a different orientation - they are not linked to the original
values. There is, however, a TRANSPOSE function which you might be able
to use instead - that way, the values in the transposed table will be
linked to the original table.

Assuming that your macro does allow for the values in the original
table to be refreshed, then linking the transposed table in this way
would enable those values to be refreshed also.

Hope this helps - I'm not sure I know what you mean by "senior
members".

Pete

can u pls tel me how can i use the transpose funcation which will also
link it to the main table? If possible pls tel me the steps.
thanks.
Regards


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

ronald_peterson wrote:
can u pls tel me how can i use the transpose funcation which will also
link it to the main table? If possible pls tel me the steps.
thanks.
Regards


--
ronald_peterson

I can give you a method to link directly to the table - can you please
let me know:

a) the name of the sheet that the data is currently on
b) the range of cells that the data currently occupies (eg A2 to X15)
c) if you want the transposed data on the same sheet or a different
sheet - if different, then what name will you use for this second
sheet?
d) which cell you want the transposed data to start from.

Pete

thanks for replyin pete, answers to ur questions are,
a) the name of the sheet that the data is currently on-my tracker 1.3
b) the range of cells that the data currently occupies (eg A2 to X15)
depending on the no of stocks(say 3)
c) if you want the transposed data on the same sheet or a different
sheet - if different, then what name will you use for this second
sheet? same sheet
d)
which cell you want the transposed data to start from.= any cell

At the begining of the thread iv uploaded the workbook, i can ensure
there is no virus in it, not in the macro. So pls hav a look make the
changes and then pls upload it here.or mail me.
pls reply.
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

Have downloaded your files - will email back to you when I have it set
up later tonight (for me). I'll make it capable of reading up to 50
stocks - hope this will suffice.

Pete

ronald_peterson wrote:
thanks for replyin pete, answers to ur questions are,
a) the name of the sheet that the data is currently on-my tracker 1.3
b) the range of cells that the data currently occupies (eg A2 to X15)
depending on the no of stocks(say 3)
c) if you want the transposed data on the same sheet or a different
sheet - if different, then what name will you use for this second
sheet? same sheet
d)
which cell you want the transposed data to start from.= any cell

At the begining of the thread iv uploaded the workbook, i can ensure
there is no virus in it, not in the macro. So pls hav a look make the
changes and then pls upload it here.or mail me.
pls reply.
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 have completed your worksheet, but emails to you bounce back, and I
am not part of Excel Forum so I can't send the file to you that way.

Send me your email address to pashurst <at auditel <dot net (you
should be able to work that out), so that I can send the completed file
to you.

Pete

Pete_UK wrote:
Have downloaded your files - will email back to you when I have it set
up later tonight (for me). I'll make it capable of reading up to 50
stocks - hope this will suffice.

thanks buddy for puttin an effort. MY email id is
. and if possible instead of 50 make it for
200.
Id always b greatful to u for this hlp buddy.
Thanks and regards


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

u don hav to worry my frnd 50stck will also. iv given my id as well as
hav sent u a mail. pls check and thanks again


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

Have sent the file to you with 50 stock capability. I can increase this
to 200, but please check that the file I have sent works okay first.

Pete

ronald_peterson wrote:
u don hav to worry my frnd 50stck will also. iv given my id as well as
hav sent u a mail. pls check and thanks again


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