PlS Help ABT STOCK TRACKER

R

ronald_peterson

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

Pete_UK

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
 
R

ronald_peterson

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
 
A

Ardus Petus

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

Cheers,
--
AP

"ronald_peterson"
<[email protected]> a écrit dans
le message de (e-mail address removed)...
 
A

Ardus Petus

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"
<[email protected]> a écrit dans
le message de (e-mail address removed)...
 
R

ronald_peterson

hey is there is no body in the forum who could hlp me out on this????
Senior members pls hlp
 
P

Pete_UK

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
 
R

ronald_peterson

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
 
P

Pete_UK

ronald_peterson said:
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
Click to expand...

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
 
R

ronald_peterson

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
 
P

Pete_UK

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
 
P

Pete_UK

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
 
R

ronald_peterson

thanks buddy for puttin an effort. MY email id is
(e-mail address removed). and if possible instead of 50 make it for
200.
Id always b greatful to u for this hlp buddy.
Thanks and regards
 
R

ronald_peterson

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
 
P

Pete_UK

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help ABT Stock Auto Refresher 0
stock database and table design - pls help! 1

Top