Page 1 of 1

N/A error on price update

Posted: November 7th, 2016, 2:19 pm
by vrdiver
I'm using v 10.94b of the Excel HYPTUS which has proved excellent for automating data updates.

I have a share (VZ) which is 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 D E F
/equity/Verizon_Communications_Inc Verizon Communications VZ Telecom VZ

where column F (CSI) is blank.

Any suggestions on how to fix this much appreciated

VRD

Re: N/A error on price update

Posted: November 7th, 2016, 2:27 pm
by kiloran
vrdiver wrote:
The data sheet entry is:
A B C D E F
/equity/Verizon_Communications_Inc Verizon Communications VZ Telecom VZ

where column F (CSI) is blank.
VRD
Same issue.... Verizon is NYSE

--kiloran