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

Full ASX Excel Spreadsheet, page-58

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

Top Stories

WC8

Pan Asia rebranding to 'clear confusion' after bagging $35M for Chile projects

OD6

Leo Lithium locks in US$116.3M with sale of Goulamina stake to Ganfeng

MIN

MinRes's Ellison knows he screwed up – for that reason, hunt for new Chair to be sped up

ACW

This biotech stock raised $11M in a risk-off environment. Its Alzheimer's drug could change the game

History-making uranium sample grades and an imminent drill run. Infini Resources is poised to transform in 2025

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

First 58 Last