1

I am trying to use the google finance function within Google Sheets to return the share price for Vital Healthcare Property Trust which is listed on the New Zealand stock exchange.

Here is the instrument in question:

For all other instruments on the NZ stock exchange, it just works. For example:

=googlefinance("NZE:MEL")
=googlefinance("NZE:GNE")
=googlefinance("NZE:RYM")

These all return as expected, but 

=googlefinance("NZE:VHP")

returns #N/A.

Out of desperation, I've tried all of the following ticker combinations:

VHP
VHP.NZ
VHP.NZE
VHP.NZSE
VHP:NZ
VHP:NZE
VHP:NZSE
NZ.VHP
NZE.VHP
NZSE.VHP
NZ:VHP
NZE:VHP
NZSE:VHP

Why does this specific instrument not return a value correctly?

And how do I fix it/work around it?

pnuts
  • 58,317
  • 11
  • 87
  • 139
Jake McInteer
  • 11
  • 1
  • Rather than a programming question this looks to be something related to the Google Finance service. Have you considered to ask about this on [quant.se]? – Rubén Jul 01 '18 at 00:31
  • Your instrument should be available @ [googlefinance](https://finance.google.com) – TheMaster Jul 01 '18 at 09:07

1 Answers1

0

Why does this specific instrument not return a value correctly?

No idea.

how do I fix it/work around it?

Perhaps:

=1*substitute(index(importxml("https://www.nzx.com/instruments/VHP","//h1"),2,),"$","")
pnuts
  • 58,317
  • 11
  • 87
  • 139