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
Got a credit card? use our Credit Card & Finance Calculators
Thanks to Rhyd6,eyeball08,Wondergirly,bofh,johnstevens77, for Donating to support the site
N/A error on price update
-
- Lemon Quarter
- Posts: 2574
- Joined: November 5th, 2016, 2:22 am
- Has thanked: 552 times
- Been thanked: 1212 times
-
- Lemon Quarter
- Posts: 4112
- Joined: November 4th, 2016, 9:24 am
- Has thanked: 3250 times
- Been thanked: 2855 times
Re: N/A error on price update
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
-
- Lemon Quarter
- Posts: 2574
- Joined: November 5th, 2016, 2:22 am
- Has thanked: 552 times
- Been thanked: 1212 times
Re: N/A error on price update
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
Return to “Financial Software - Discussion”
Who is online
Users browsing this forum: No registered users and 17 guests