Chi-X Stock Prices Download Into Excel

• 5 July 2021

• #2

Austwide

Joined

14 October 2017

Posts

240

Reactions

329

Hi Dubbo, welcome to the forum.

Are you doing this in Excel or google sheets version of excel?

When you say you use BHP.AX, what is the full cell content as I am unable to load directly into Excel?

 

Upvote 0

• 6 July 2021

• #3

D

Dubbo123

Joined

5 July 2021

Posts

5

Reactions

0

Yes I have a spreadsheet (Excel) that I use to update the prices and .AX returns Australian stocks, but I have got one on the Australian CHI-X exchange and that suffix does not work. So yeah wondering if there is another suffix I need to use?

 

Attachments

• Capture.PNG

  46.8 KB · Views: 10

Upvote 0

• 6 July 2021

• #4

Austwide

Joined

14 October 2017

Posts

240

Reactions

329

As far as I can tell, neither Yahoo or google provide CHI-X quotes.

There is little price difference between ASX and CHI-X normally, and with the 20 min delay, take that as zero difference for trading.

Many brokers such as Commsec use either to get the best price. Some only use one or the other.

I think you are only getting EOD data so it make no difference anyhow.

 

Upvote 0

• 13 July 2021

• #5

D

Dubbo123

Joined

5 July 2021

Posts

5

Reactions

0

OK, so being more specific, if the stock is only traded on CHI-X how can I retrieve the daily price? If not possible so be it.

 

Upvote 0

• 13 July 2021

• #6

Austwide

Joined

14 October 2017

Posts

240

Reactions

329

Specifically, FPAY not possible.

 

Upvote 0

• 15 July 2021

• #7

D

Dubbo123

Joined

5 July 2021

Posts

5

Reactions

0

ok Thanks if it is not possible so be it, Thanks for setting me straight,

 

Upvote 0

• 16 July 2021

• #8

W

wabbit

Joined

11 July 2005

Posts

251

Reactions

12

As the data is published, you can use VBA in Excel to scrape the CHI-X webpage to retrieve the data… easy.

 

Upvote 0

• 4 August 2021

• #9

K

KevinBB

Joined

4 December 2010

Posts

522

Reactions

1,130

@Dubbo123 I'm not sure if this is what you are after, but the Chi-X web site has a list of all stocks listed on Chi-X Australia, together with their daily closing prices.

The list can be downloaded in .csv format.
This page: https://www.chi-x.com.au/trading-information/tradable-securities

KH

 

Upvote 0

• 12 August 2021

• #10

D

Dubbo123

Joined

5 July 2021

Posts

5

Reactions

0

THANK YOU everyone, much apricated.

 

Upvote 0