Donate to Remove ads

Got a credit card? use our Credit Card & Finance Calculators

Thanks to johnstevens77,Bhoddhisatva,scotia,Anonymous,Cornytiv34, for Donating to support the site

N/A error on price update

Discussions regarding financial software
vrdiver
Lemon Quarter
Posts: 2574
Joined: November 5th, 2016, 2:22 am
Has thanked: 552 times
Been thanked: 1212 times

N/A error on price update

#1705

Postby vrdiver » November 7th, 2016, 2:19 pm

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

kiloran
Lemon Quarter
Posts: 4092
Joined: November 4th, 2016, 9:24 am
Has thanked: 3234 times
Been thanked: 2827 times

Re: N/A error on price update

#1710

Postby kiloran » November 7th, 2016, 2:27 pm

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


Return to “Financial Software - Discussion”

Who is online

Users browsing this forum: No registered users and 10 guests