Using another source

[Tenspeed39355]

Good morning guys. I am using a program named XLQ that looks in Yahoo
and brings back the NET ASSET VALUE or the MKT VALUE of any fund that I enter. With the Mkt value there is no problem but with the NET ASSET VALUE sometimes there is a problem due to the fact that the fund does not have a symbol for the net asset value. I have the value in a ss that I am able to download from the ETFs site. My question is if xlq can not find the value at Yahoo how can I then direct the formula to my ss so I can have the number in a cell?
The xlq formula is =xlqprice(B3). Thanks for any help with this.
Max

[grichey]

is xlq an excel addin?

[Bob Phillips]

Maybe

=IF(ISERROR(xlqprice(B3)),0,xlqprice(B3))