N/A error on price update

Discussions regarding financial software
Post Reply
vrdiver
Lemon Quarter
Posts: 2943
Joined: November 5th, 2016, 2:22 am

N/A error on price update

Post by vrdiver »

I'm using v 10.94b of the Excel HYPTUS which has proved excellent for automating data updates.

I have two shares (ACN and VZ) which are populated with "N/" when using the "Get Yahoo Prices" update button and a pop up dialogue that states
"Run-time error '13':
type mismatch"

The data sheet entry is:
A B C
/equity/Accenture_Plc Accenture ACN Services ACN

kiloran
Lemon Quarter
Posts: 3865
Joined: November 4th, 2016, 9:24 am

Re: N/A error on price update

Post by kiloran »

vrdiver wrote:I'm using v 10.94b of the Excel HYPTUS which has proved excellent for automating data updates.

I have two shares (ACN and VZ) which are populated with "N/" when using the "Get Yahoo Prices" update button and a pop up dialogue that states
"Run-time error '13':
type mismatch"

The data sheet entry is:
A B C
/equity/Accenture_Plc Accenture ACN Services ACN
Accenture Plc is not quoted in London, it's NYSE:
https://uk.finance.yahoo.com/q?s=ACN&ql=0

The HYPTUSS is hard-coded to LSE only. Sorry!

--kiloran

vrdiver
Lemon Quarter
Posts: 2943
Joined: November 5th, 2016, 2:22 am

Re: N/A error on price update

Post by vrdiver »

kiloran wrote:
vrdiver wrote:I'm using v 10.94b of the Excel HYPTUS which has proved excellent for automating data updates.
.
.
.

The HYPTUSS is hard-coded to LSE only. Sorry!

--kiloran

OK - many thanks for letting me know.

Also apologies for duplicate post - hit the wrong key!

VRD

Post Reply

Return to “Financial Software - Discussion”