9
99atlantic
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>
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>