I'm trying to extra the table information from here (more specifically,
column Month, Share, Nav)........obviously because of how it is setup I
can't do a straight up web query
http://tinyurl.com/fh8dc
It was suggested that maybe I could extract the data from the HTML on
the page
i.e.,
Code:
--------------------
<div class="ChartDataDiv"
<table class="ChartDataTable" id="Table1" cellspacing="0" cellpadding="0" border="1"
<tr
<td class="ChartDataHdr"Month End</td
<td class="ChartDataHdr"Share Price</td
<td class="ChartDataHdr"NAV</td
</tr
<tr
<td class="ChartDataCol"06/30/2005</td
<td class="ChartDataCol"$21.62</td
<td class="ChartDataCol"$24.43</td
</tr
<tr
<td class="ChartDataCol"07/31/2005</td
<td class="ChartDataCol"$22.16</td
<td class="ChartDataCol"$25.35</td
</tr
<tr
<td class="ChartDataCol"08/31/2005</td
<td class="ChartDataCol"$22.21</td
<td class="ChartDataCol"$25.43</td
</tr
<tr
<td class="ChartDataCol"09/30/2005</td
<td class="ChartDataCol"$23.40</td
<td class="ChartDataCol"$26.19</td
</tr
<tr
<td class="ChartDataCol"10/31/2005</td
<td class="ChartDataCol"$21.61</td
<td class="ChartDataCol"$24.21</td
</tr
<tr
<td class="ChartDataCol"11/30/2005</td
<td class="ChartDataCol"$21.30</td
<td class="ChartDataCol"$23.91</td
</tr
<tr
<td class="ChartDataCol"12/31/2005</td
<td class="ChartDataCol"$19.40</td
<td class="ChartDataCol"$21.18</td
</tr
<tr
<td class="ChartDataCol"01/31/2006</td
<td class="ChartDataCol"$20.66</td
<td class="ChartDataCol"$22.65</td
</tr
<tr
<td class="ChartDataCol"02/28/2006</td
<td class="ChartDataCol"$21.05</td
<td class="ChartDataCol"$22.09</td
</tr
<tr
<td class="ChartDataCol"03/31/2006</td
<td class="ChartDataCol"$21.22</td
<td class="ChartDataCol"$21.53</td
</tr
<tr
<td class="ChartDataCol"04/30/2006</td
<td class="ChartDataCol"$20.77</td
<td class="ChartDataCol"$21.87</td
</tr
<tr
<td class="ChartDataCol"05/31/2006</td
<td class="ChartDataCol"$20.95</td
<td class="ChartDataCol"$22.23</td
</tr
</table
</div
--------------------
But I'm not certain how I'd do that???
--
99atlantic
------------------------------------------------------------------------
99atlantic's Profile:
http://www.excelforum.com/member.php...o&userid=31194
View this thread:
http://www.excelforum.com/showthread...hreadid=552409