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

Top Stories

ACW

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

HotCopper Highlights: Your most watched stocks for Week 47, 2024

Week 47 Wrap: HotCopper users' most watched; Brent lifts on Putin's scary letter; RFK dents CSL

WC8

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

SIG

Dale Gillham's weekly wrap: Sigma-Chemist Warehouse merger creates pharma powerhouse

GRL

To make modern missiles, you need 3D Printing. And in that gold rush, Amaero is selling shovels

BTH

Bigtincan's Board backs Investcorp offer: Why a NASDAQ listing could be game-changing

MIN

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

LPE

Sales growth pushes Lovisa's fortunes (and shares) upwards

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

SPONSORED BY