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
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