 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
Mac Forum / Applications / Excel / September 2007MSNStockQuote
One week ago this function stopped returning values for preferred shares. Has something changed. On 8/27/07 4:52 PM, in article 746A3FEB-1156-4A43-97D5-0F004F395E5E@microsoft.com, "Bighitter" > One week ago this function stopped returning values for preferred shares. Has > something changed. Which function? Web queries work fine for me.  SignatureBob Greenblatt [MVP], Macintosh bobgreenblattATmsnDOTcom For example =MSNStockQuote("rpa.pr.a","Last Price","CA") returns 0.0 and one week ago it worked. All data requests return zero (ie "ask" and on all preferreds that I try) Thanks for your reply Wayne > On 8/27/07 4:52 PM, in article > 746A3FEB-1156-4A43-97D5-0F004F395E5E@microsoft.com, "Bighitter" > > > One week ago this function stopped returning values for preferred shares. Has > > something changed. > Which function? Web queries work fine for me. Bob One additional item. The symbol for preferreds seems to have different results like "rpa.pr.a" returns the correct name and "rpa-a" returns some values. A week ago " rpa-a" format worked for all stocks Wayne > On 8/27/07 4:52 PM, in article > 746A3FEB-1156-4A43-97D5-0F004F395E5E@microsoft.com, "Bighitter" > > > One week ago this function stopped returning values for preferred shares. Has > > something changed. > Which function? Web queries work fine for me. Bob You have not responded to this problem. Something changed with this function as it now yields erratic results for preferred shares. A month ago it was consistent. If you can be of help Thanks Wayne > Bob > One additional item. The symbol for preferreds seems to have different [quoted text clipped - 11 lines] > > > something changed. > > Which function? Web queries work fine for me. On 9/18/07 1:46 PM, in article 2CD3AD67-5072-4A2E-8986-2C17B145214E@microsoft.com, "Bighitter" > Bob > [quoted text clipped - 22 lines] >>>> something changed. >>> Which function? Web queries work fine for me. Again, I ask, which function? What formula are you using, what wrong results do you get? Have you checked with MSN? They frequently change access codes for web queries. SignatureBob Greenblatt [MVP], Macintosh bobgreenblattATmsnDOTcom again - an example =MSNStockQuote("rpq.pr.a","Ask Price","CA") wether its "Ask" or "last" or "volume" or anything else, they did work for all preferred shares but a couple of weeks ago it stopped working (but sometimes it does!!) Wayne > On 9/18/07 1:46 PM, in article > 2CD3AD67-5072-4A2E-8986-2C17B145214E@microsoft.com, "Bighitter" [quoted text clipped - 29 lines] > do you get? Have you checked with MSN? They frequently change access codes > for web queries. On 9/19/07 12:06 AM, in article 1F14E9CC-D04C-4449-B60D-8E63A1CED780@microsoft.com, "Bighitter" > again - an example > [quoted text clipped - 39 lines] >> do you get? Have you checked with MSN? They frequently change access codes >> for web queries. Near as I can tell that function is part of an add-in for Excel 2002. Are you aware you are posting in a Macintosh forum? I can find no references to this add-in in Mactopia. Again, have you checked with MS to make sure they have not changed any functionality? SignatureBob Greenblatt [MVP], Macintosh bobgreenblattATmsnDOTcom |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.