Australia's largest stock trading and investment forum Australia's #1 stock forum

WilliamWonka Thankyou for that. I did consider another column to...

First 58 Last

Share
Profile

Follow
SonicBlast

2,361 Posts.

32

05/03/17

22:30

Post #: 23113544
Share

Originally posted by WilliamWonka ↑

Sonic,

You can change the format of any of the columns after the data has downloaded, what you cant change is the position of the columns as then they will be filled with the incorrect data. The other 10 sheets are filled with data when the update button is pushed then copied into the all sheet.

The market cap is not great, this is just the raw data from yahoo. You could write a little formula in a new column to display the the number into the format you mention.

Also the slowness is due to yahoo servers being slow.

Expand

WilliamWonka
Thankyou for that. I did consider another column to convert. Yeah I was after SOI but will see what I can do.
Thanks to everyone.
Sonic
Upvote

Reply

There are more pages in this discussion • 21 more messages in this thread...

First 58 Last