PDA

View Full Version : Using another source



Tenspeed39355
06-25-2008, 05:26 AM
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
06-25-2008, 05:30 AM
is xlq an excel addin?

Bob Phillips
06-25-2008, 05:32 AM
Maybe

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