[NPMUG] [uva-mess] Excel 2004 for Mac and web pages

[Robert Peirce]

On Sep 9, 2009, at 9:25 PM, Will Martin wrote:

> Hi, Robert.
>
> I wish I could help, but your description of the feature is a  
> little vague. Would you mind providing an actual URL to one of the  
> Web pages you are talking about, and a description of the specific  
> data somehow linked between the URL and the spreadsheet? It might  
> give the rest of us more to go on.


This URL is used to get the CBOE Volatility Index (VIX).  In Windows  
Excel, you can actually select that item from the web page.  That is  
all you will get, and as far as I have been able to determine you  
will get it no matter where it ends up on the page.  Excel 2004 for  
Mac loads the entire page and the VIX data drifts up and down  
depending on what other information the CBOE chooses to include in  
its page. The cells for High, Low and Close are always next to one  
another but they may move up or down a couple of lines in the  
spreadsheet each day.  This means you must always check to be sure  
the data you extracted is the data you actually wanted.

http://www.cboe.com/data/mktstat.aspx
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://davesevick.com/pipermail/npmug/attachments/20090909/b07f10f8/attachment-0001.htm