NZDX Information

[jmsnz]

Hi,

Pretty new to all of this, so please be gentle.

Where would I get a (nicely) formatted list of NZDX items that showed the basics of:
Code
Company Name
Maturity Type
Maturity Date
Coupon Yield
Buy Yield
Sell Yield
Volume

I have been to the NZX site but it is slightly deficient in some of that.

Thanks.

[Alan3285]

Hi jmsnz, and Welcome!

Hi,

Pretty new to all of this, so please be gentle.

Where would I get a (nicely) formatted list of NZDX items that showed the basics of:
Code
Company Name
Maturity Type
Maturity Date
Coupon Yield
Buy Yield
Sell Yield
Volume

I have been to the NZX site but it is slightly deficient in some of that.

Thanks.

As far as I know, this is the closest you can get on the NZX site:

http://www.nzx.com/markets/all-secur...ricebysecurity

It has everything you asked for except that it is codes, not company name, and has no maturity information.

If you really want all that in one place, the easiest way to go is probably to have a spreadsheet import that page automatically, then take the info from there into another sheet where you would pull in the company name, and maturity info from another sheet. Since that is static data, it doesn't change very often and when it does you could maintain it manually quite easily.

HTH,

Alan.

[jmsnz]

Alan,

Thanks for that, I had already found that NZX link.

Have now also found a better list on the DirectBroking site.

Cheers

[Alan3285]

Hi jmsnz,

Alan,

Thanks for that, I had already found that NZX link.

Have now also found a better list on the DirectBroking site.

Cheers

What is that link? If you could post it here, then those that follow gain from the knowledge too.

Thanks,

Alan.

[CJ]

I think ASB securities also provides the info but i dont think it is that details.

[Alan3285]

I think ASB securities also provides the info but i dont think it is that details.

That's right - there is nothing that has all of those fields in one place on the ASB site that I can find.

Alan.

[jmsnz]

Alan,

I found something like I was looking for at https://www.directbroking.co.nz/Dire...dinterest.aspx

Not sure I would call it 'nicely formatted' but I have got it into something that will serve my needs.

Cheers

[Alan3285]

Alan,

I found something like I was looking for at https://www.directbroking.co.nz/Dire...dinterest.aspx

Not sure I would call it 'nicely formatted' but I have got it into something that will serve my needs.

Cheers

Cool - Good find!

Alan.