Jump to content

webscrape

Members
 View Profile  See their activity

  • Posts

    6

  • Joined

  • Last visited

 Content Type 

Posts posted by webscrape

    Help importXML google sheets

    in XML

    Posted

    THIS is what i get from the inspection : I AM after the red number below.  Can you please tell me what i should have ? 

    I tried :

    =importxml($B$1,"//tr[3]/td[2]")
    =importxml($B$1,"//tr[1]/td[2]")
    =importxml($B$1,"//table[0]/tr[1]/td[2]")

    BELOW IS INSPECTION OF TABLE :

    <div id="block-views-fund-unit-pricing-block-1" class="block block-views clearfix">
    <div class="content">
     
     
     
     
    <div class="required-fields accordion-holders add-style">
    <div class="field fund-unit-pricing-section accordion-section">
    <li>
    <div>
    <h2 id="tmf" class="field-label active">The Montgomery Fund</h2>
    <div class="fund-performance">FUND PERFORMANCE</div>
    <div class="holder">
    <div class="column first"><div class="field-content">Returns since inception</div><div class="field-content">97.92%</div></div>
    <div class="column"><div class="field-content">ASX 300 Accum. Index</div><div class="field-content">88.72%</div></div>
    <div class="column"><div class="field-content">Out/Under Performance </div><div class="field-content">9.20%</div></div>
    </div>
    </div>
     
     
    <div id="accordion-5" class="fund-unit-pricing-table accordion-section-content">
    <table>
    <thead>
    <tr>
    <th role="columnheader">DATE</th>
    <th role="columnheader">BUY</th>
    <th role="columnheader">REDEEM</th>
    <th role="columnheader" class="last-child">MID</th>
    </tr>
    </thead>
    <tbody>
    <tr>
    <td class="">10/09/18</td>
    <td class="">1.3877</td>
    <td class="">1.3808</td>
    <td class="last-child">1.3842</td>
    </tr>
    <tr class="collapsable">
    <td class="" style="overflow: hidden; display: table-cell;">07/09/18</td>
    <td class="" style="overflow: hidden; display: table-cell;">1.3917</td>
    <td class="" style="overflow: hidden; display: table-cell;">1.3847</td>
    <td class="last-child" style="overflow: hidden; display: table-cell;">1.3882</td>
    </tr>
    <tr class="collapsable">
    <td class="" style="overflow: hidden; display: table-cell;">06/09/18</td>
    <td class="" style="overflow: hidden; display: table-cell;">1.3928</td>
    <td class="" style="overflow: hidden; display: table-cell;">1.3858</td>
    <td class="last-child" style="overflow: hidden; display: table-cell;">1.3893</td>
    </tr>
    <tr class="collapsable">
    <td class="" style="overflow: hidden; display: table-cell;">05/09/18</td>
    <td class="" style="overflow: hidden; display: table-cell;">1.4067</td>
    <td class="" style="overflow: hidden; display: table-cell;">1.3997</td>
    <td class="last-child" style="overflow: hidden; display: table-cell;">1.4032</td>
    </tr>
    <tr class="collapsable">
    <td class="" style="overflow: hidden; display: table-cell;">04/09/18</td>
    <td class="" style="overflow: hidden; display: table-cell;">1.4124</td>
    <td class="" style="overflow: hidden; display: table-cell;">1.4053</td>
    <td class="last-child" style="overflow: hidden; display: table-cell;">1.4089</td>
    </tr>
    <tr class="collapsable">
    <td class="" style="overflow: hidden; display: table-cell;">03/09/18</td>
    <td class="" style="overflow: hidden; display: table-cell;">1.4085</td>
    <td class="" style="overflow: hidden; display: table-cell;">1.4015</td>
    <td class="last-child" style="overflow: hidden; display: table-cell;">1.4050</td>
    </tr>
    <tr class="collapsable">
    <td class="" style="overflow: hidden; display: table-cell;">31/08/18</td>
    <td class="" style="overflow: hidden; display: table-cell;">1.4105</td>
    <td class="" style="overflow: hidden; display: table-cell;">1.4035</td>
    <td class="last-child" style="overflow: hidden; display: table-cell;">1.4070</td>
    </tr>
    <tr class="collapsable">
    <td class="" style="overflow: hidden; display: table-cell;">30/08/18</td>
    <td class="" style="overflow: hidden; display: table-cell;">1.4118</td>
    <td class="" style="overflow: hidden; display: table-cell;">1.4047</td>
    <td class="last-child" style="overflow: hidden; display: table-cell;">1.4083</td>
    </tr>
    <tr class="collapsable">
    <td class="" style="overflow: hidden; display: table-cell;">29/08/18</td>
    <td class="" style="overflow: hidden; display: table-cell;">1.4104</td>
    <td class="" style="overflow: hidden; display: table-cell;">1.4034</td>
    <td class="last-child" style="overflow: hidden; display: table-cell;">1.4069</td>
    </tr>
    <tr class="collapsable">
    <td class="" style="overflow: hidden; display: table-cell;">28/08/18</td>
    <td class="" style="overflow: hidden; display: table-cell;">1.4079</td>
    <td class="" style="overflow: hidden; display: table-cell;">1.4009</td>
    <td class="last-child" style="overflow: hidden; display: table-cell;">1.4044</td>
    </tr>
    </tbody>
    </table>
    <div class="info-buttons" style="overflow: hidden; display: block;">
    <div class="buttons">
    <a role="button" href="http://investwith.montinvest.com/tmf-history" class="btn-download">Download Full History</a>
    <a role="button" class="btn-funds" href="/tmf">Learn More</a>
    </div>
    </div>
    </div>
    </li>
    </div>
    <div class="field fund-unit-pricing-section accordion-section">
    <li>
    <div>
    <h2 id="map" class="field-label">Montgomery Alpha Plus Fund</h2>
    <div class="fund-performance">FUND PERFORMANCE</div>
    <div class="holder">
    <div class="column first"><div class="field-content">Returns since inception</div><div class="field-content">-9.95%</div></div>
    <div class="column"><div class="field-content">RBA Cash Rate</div><div class="field-content">3.36%</div></div>
    <div class="column"><div class="field-content">Out/Under Performance</div><div class="field-content">-13.31%</div></div>
    </div>
    </div>
     
     
    <div id="accordion-121" class="fund-unit-pricing-table accordion-section-content">
    <table>
    <thead>
    <tr>
    <th role="columnheader">DATE</th>
    <th role="columnheader">BUY</th>
    <th role="columnheader">REDEEM</th>
    <th role="columnheader" class="last-child">MID</th>
    </tr>
    </thead>
    <tbody>
    <tr>
    <td class="">10/09/18</td>
    <td class="">0.8408</td>
    <td class="">0.8366</td>
    <td class="last-child">0.8387</td>
    </tr>
    <tr class="collapsable">
    <td class="">07/09/18</td>
    <td class="">0.8390</td>
    <td class="">0.8348</td>
    <td class="last-child">0.8369</td>
    </tr>
    <tr class="collapsable">
    <td class="">06/09/18</td>
    <td class="">0.8380</td>
    <td class="">0.8338</td>
    <td class="last-child">0.8359</td>
    </tr>
    <tr class="collapsable">
    <td class="">05/09/18</td>
    <td class="">0.8399</td>
    <td class="">0.8357</td>
    <td class="last-child">0.8378</td>
    </tr>
    <tr class="collapsable">
    <td class="">04/09/18</td>
    <td class="">0.8406</td>
    <td class="">0.8364</td>
    <td class="last-child">0.8385</td>
    </tr>
    <tr class="collapsable">
    <td class="">03/09/18</td>
    <td class="">0.8450</td>
    <td class="">0.8408</td>
    <td class="last-child">0.8429</td>
    </tr>
    <tr class="collapsable">
    <td class="">31/08/18</td>
    <td class="">0.8394</td>
    <td class="">0.8352</td>
    <td class="last-child">0.8373</td>
    </tr>
    <tr class="collapsable">
    <td class="">30/08/18</td>
    <td class="">0.8305</td>
    <td class="">0.8263</td>
    <td class="last-child">0.8284</td>
    </tr>
    <tr class="collapsable">
    <td class="">29/08/18</td>
    <td class="">0.8215</td>
    <td class="">0.8174</td>
    <td class="last-child">0.8194</td>
    </tr>
    <tr class="collapsable">
    <td class="">28/08/18</td>
    <td class="">0.8313</td>
    <td class="">0.8272</td>
    <td class="last-child">0.8293</td>
    </tr>
    </tbody>
    </table>
    <div class="info-buttons">
    <div class="buttons">
    <a role="button" href="http://investwith.montinvest.com/mapf-history" class="btn-download">Download Full History</a>
    <a role="button" class="btn-funds" href="/map">Learn More</a>
    </div>
    </div>
    </div>
    </li>
    </div>
    <div class="field fund-unit-pricing-section accordion-section">
    <li>
    <div>
    <h2 id="apply-to-invest-montgomery-private-fund" class="field-label">Montgomery [Private] Fund</h2>
    <div class="fund-performance">FUND PERFORMANCE</div>
    <div class="holder">
    <div class="column first"><div class="field-content">Returns since inception</div><div class="field-content">108.96%</div></div>
    <div class="column"><div class="field-content">ASX 200 Industrials Accum. Index</div><div class="field-content">120.82%</div></div>
    <div class="column"><div class="field-content">Out/Under Performance </div><div class="field-content">-11.86%</div></div>
    </div>
    </div>
     
     
    <div id="accordion-6" class="fund-unit-pricing-table accordion-section-content">
    <table>
    <thead>
    <tr>
    <th role="columnheader">DATE</th>
    <th role="columnheader">BUY</th>
    <th role="columnheader">REDEEM</th>
    <th role="columnheader" class="last-child">MID</th>
    </tr>
    </thead>
    <tbody>
    <tr>
    <td class="">06/09/18</td>
    <td class="">1.1942</td>
    <td class="">1.1883</td>
    <td class="last-child">1.1913</td>
    </tr>
    <tr class="collapsable">
    <td class="">05/09/18</td>
    <td class="">1.1942</td>
    <td class="">1.1883</td>
    <td class="last-child">1.1913</td>
    </tr>
    <tr class="collapsable">
    <td class="">04/09/18</td>
    <td class="">1.1942</td>
    <td class="">1.1883</td>
    <td class="last-child">1.1913</td>
    </tr>
    <tr class="collapsable">
    <td class="">03/09/18</td>
    <td class="">1.1942</td>
    <td class="">1.1883</td>
    <td class="last-child">1.1913</td>
    </tr>
    <tr class="collapsable">
    <td class="">31/08/18</td>
    <td class="">1.1942</td>
    <td class="">1.1883</td>
    <td class="last-child">1.1913</td>
    </tr>
    <tr class="collapsable">
    <td class="">30/08/18</td>
    <td class="">1.2091</td>
    <td class="">1.2030</td>
    <td class="last-child">1.2060</td>
    </tr>
    <tr class="collapsable">
    <td class="">29/08/18</td>
    <td class="">1.2091</td>
    <td class="">1.2030</td>
    <td class="last-child">1.2060</td>
    </tr>
    <tr class="collapsable">
    <td class="">28/08/18</td>
    <td class="">1.2091</td>
    <td class="">1.2030</td>
    <td class="last-child">1.2060</td>
    </tr>
    <tr class="collapsable">
    <td class="">27/08/18</td>
    <td class="">1.2091</td>
    <td class="">1.2030</td>
    <td class="last-child">1.2060</td>
    </tr>
    <tr class="collapsable">
    <td class="">24/08/18</td>
    <td class="">1.2091</td>
    <td class="">1.2030</td>
    <td class="last-child">1.2060</td>
    </tr>
    </tbody>
    </table>
    <div class="info-buttons">
    <div class="buttons">
    <a role="button" href="http://investwith.montinvest.com/mpf-history" class="btn-download">Download Full History</a>
    <a role="button" class="btn-funds" href="/apply-to-invest-montgomery-private-fund">Learn More</a>
    </div>
    </div>
    </div>
    </li>
    </div>
    <div class="field fund-unit-pricing-section accordion-section">
    <li>
    <div>
    <h2 id="mgf" class="field-label"> Montgomery Global Fund</h2>
    <div class="fund-performance">FUND PERFORMANCE</div>
    <div class="holder">
    <div class="column first"><div class="field-content">Returns since inception</div><div class="field-content">51.18%</div></div>
    <div class="column"><div class="field-content">MSCI World Net Total Return Index A$</div><div class="field-content">40.32%</div></div>
    <div class="column"><div class="field-content">Out/Under Performance </div><div class="field-content">10.86%</div></div>
    </div>
    </div>
     
     
    <div id="accordion-73" class="fund-unit-pricing-table accordion-section-content">
    <table>
    <thead>
    <tr>
    <th role="columnheader">DATE</th>
    <th role="columnheader">BUY</th>
    <th role="columnheader">REDEEM</th>
    <th role="columnheader" class="last-child">MID</th>
    </tr>
    </thead>
    <tbody>
    <tr>
    <td class="">07/09/18</td>
    <td class="">1.2639</td>
    <td class="">1.2576</td>
    <td class="last-child">1.2608</td>
    </tr>
    <tr class="collapsable">
    <td class="">06/09/18</td>
    <td class="">1.2560</td>
    <td class="">1.2497</td>
    <td class="last-child">1.2529</td>
    </tr>
    <tr class="collapsable">
    <td class="">05/09/18</td>
    <td class="">1.2690</td>
    <td class="">1.2627</td>
    <td class="last-child">1.2659</td>
    </tr>
    <tr class="collapsable">
    <td class="">04/09/18</td>
    <td class="">1.2867</td>
    <td class="">1.2803</td>
    <td class="last-child">1.2835</td>
    </tr>
    <tr class="collapsable">
    <td class="">03/09/18</td>
    <td class="">1.2854</td>
    <td class="">1.2790</td>
    <td class="last-child">1.2822</td>
    </tr>
    <tr class="collapsable">
    <td class="">31/08/18</td>
    <td class="">1.2857</td>
    <td class="">1.2792</td>
    <td class="last-child">1.2825</td>
    </tr>
    <tr class="collapsable">
    <td class="">30/08/18</td>
    <td class="">1.2784</td>
    <td class="">1.2720</td>
    <td class="last-child">1.2752</td>
    </tr>
    <tr class="collapsable">
    <td class="">29/08/18</td>
    <td class="">1.2791</td>
    <td class="">1.2727</td>
    <td class="last-child">1.2759</td>
    </tr>
    <tr class="collapsable">
    <td class="">28/08/18</td>
    <td class="">1.2672</td>
    <td class="">1.2609</td>
    <td class="last-child">1.2640</td>
    </tr>
    <tr class="collapsable">
    <td class="">27/08/18</td>
    <td class="">1.2664</td>
    <td class="">1.2600</td>
    <td class="last-child">1.2632</td>
    </tr>
    </tbody>
    </table>
    <div class="info-buttons">
    <div class="buttons">
    <a role="button" href="http://investwith.montinvest.com/mgf-history" class="btn-download">Download Full History</a>
    <a role="button" class="btn-funds" href="/mgf">Learn More</a>
    </div>
    </div>
    </div>
    </li>
    </div>
    <div class="field fund-unit-pricing-section accordion-section">
    <li>
    <div>
    <h2 id="mga" class="field-label">Montaka Global Access Fund</h2>
    <div class="fund-performance">FUND PERFORMANCE</div>
    <div class="holder">
    <div class="column first"><div class="field-content">Returns since inception</div><div class="field-content">19.5%</div></div>
    <div class="column"><div class="field-content">Montaka Global Fund (2)</div><div class="field-content">37.0%</div></div>
    <div class="column"><div class="field-content">Average Net Market Exposure</div><div class="field-content">47%</div></div>
    </div>
    </div>
     
     
    <div id="accordion-85" class="fund-unit-pricing-table accordion-section-content">
    <table>
    <thead>
    <tr>
    <th role="columnheader">DATE</th>
    <th role="columnheader">BUY</th>
    <th role="columnheader">REDEEM</th>
    <th role="columnheader" class="last-child">MID</th>
    </tr>
    </thead>
    <tbody>
    <tr>
    <td class="">01/08/18</td>
    <td class="">1.0943</td>
    <td class="">1.0943</td>
    <td class="last-child">1.0943</td>
    </tr>
    <tr class="collapsable">
    <td class="">01/07/18</td>
    <td class="">1.0926</td>
    <td class="">1.0926</td>
    <td class="last-child">1.0926</td>
    </tr>
    <tr class="collapsable">
    <td class="">30/06/18</td>
    <td class="">1.0926</td>
    <td class="">1.0926</td>
    <td class="last-child">1.0926</td>
    </tr>
    <tr class="collapsable">
    <td class="">01/06/18</td>
    <td class="">1.1748</td>
    <td class="">1.1748</td>
    <td class="last-child">1.1748</td>
    </tr>
    <tr class="collapsable">
    <td class="">01/05/18</td>
    <td class="">1.1172</td>
    <td class="">1.1172</td>
    <td class="last-child">1.1172</td>
    </tr>
    <tr class="collapsable">
    <td class="">01/04/18</td>
    <td class="">1.0925</td>
    <td class="">1.0925</td>
    <td class="last-child">1.0925</td>
    </tr>
    <tr class="collapsable">
    <td class="">01/03/18</td>
    <td class="">1.0841</td>
    <td class="">1.0841</td>
    <td class="last-child">1.0841</td>
    </tr>
    <tr class="collapsable">
    <td class="">01/02/18</td>
    <td class="">1.0551</td>
    <td class="">1.0551</td>
    <td class="last-child">1.0551</td>
    </tr>
    <tr class="collapsable">
    <td class="">01/01/18</td>
    <td class="">1.0629</td>
    <td class="">1.0629</td>
    <td class="last-child">1.0629</td>
    </tr>
    <tr class="collapsable">
    <td class="">01/12/17</td>
    <td class="">1.0896</td>
    <td class="">1.0896</td>
    <td class="last-child">1.0896</td>
    </tr>
    </tbody>
    </table>
    <div class="info-buttons">
    <div class="buttons">
    <a role="button" href="http://investwith.montinvest.com/mga-history" class="btn-download">Download Full History</a>
    <a role="button" class="btn-funds" href="/mga">Learn More</a>
    </div>
    </div>
    </div>
    </li>
    </div>
    </div>
     
     
     
     
     
    </div>
    </div>

    Help importXML google sheets

    in XML

    Posted

    =importxml($B$1,"//tr")   No result

    =importxml($B$1,"//td") No result

    =importxml($B$1,".")  ...gets everything not just the table that im after

    =importxml($B$1,"*")  ...gets everything not just the table that im after

    =importxml($B$1,"node()")   ...gets everything not just the table that im after

    Then i started doing alot of stuff randomly based on what i found on inspection of the data:

    NOne of these work:

    =importxml($B$1,"/[@class='fund-unit-pricing-table accordion-section-content']")

    =ImportXML(A1, "//Div[@class='fund-unit-pricing-table accordion-section-content']")
    =ImportXML(A1, "//td[@class='fund-unit-pricing-table accordion-section-content']")
    =ImportXML(A1, "//Div/tr/td[@class='fund-unit-pricing-table accordion-section-content']")
    =ImportXML(A1, "//div[@id='accordion-5'/@class='fund-unit-pricing-table accordion-section-content']")
    =ImportXML(A1, "//a[@class='fund-unit-pricing-table accordion-section-content']")
     
    And a few more .....

     

×
×
  • Create New...