Forum Discussion
Help with M query hanging
Hi Interkoubess
What the M query is doing is scrpaing the HL.co.uk site of all funds and prices.
Site address is ....
... the page is scraped. At each 'sectorid=' the value is changed for next value in SectorIDs table.
For the SectorIDs table I copied the values from the page source (see below)
<div class="large-5 medium-5 columns end padding-left-none medium-padding-left medium-padding-right-none"><div class="select_wrap"><select id="search-sector" name="sectorid" class="default"><option value="">Search by sector</option>
<option value="121">Asia Pacific Ex Japan</option>
<option value="114">Asia Pacific Inc Japan</option>
<option value="155">China/ Greater China</option>
<option value="111">Europe Excluding UK</option>
<option value="102">Europe Including UK</option>
<option value="117">European Smaller Companies</option>
<option value="115">Flexible Investment</option>
<option value="150">GBP Corporate Bond</option>
<option value="151">GBP High Yield</option>
<option value="152">GBP Strategic Bond</option>
<option value="109">Global</option>
<option value="106">Global Bonds</option>
<option value="112">Global Emerging Markets</option>
<option value="156">Global Emerging Markets Bond</option>
<option value="139">Global Equity Income</option>
<option value="126">Guaranteed/Protected</option>
<option value="113">Japan</option>
<option value="132">Japanese Smaller Companies</option>
<option value="133">Latin America</option>
<option value="137">Mixed Investment 0-35% Shares</option>
<option value="131">Mixed Investment 20-60% Shares</option>
<option value="107">Mixed Investment 40-85% Shares</option>
<option value="123">Money Market</option>
<option value="999">N/A</option>
<option value="110">North America</option>
<option value="130">North American Smaller Cos</option>
<option value="71">Offshore</option>
<option value="400">Pension Trusts</option>
<option value="108">Property</option>
<option value="138">Short Term Money Market</option>
<option value="129">Specialist</option>
<option value="136">Targeted Absolute Return</option>
<option value="134">Technology & Telecoms</option>
<option value="101">UK All Companies</option>
<option value="104">UK Equity & Bond Income</option>
<option value="103">UK Equity Income</option>
<option value="127">UK Gilt</option>
<option value="135">UK Index Linked Gilt</option>
<option value="118">UK Smaller Companies</option>
<option value="48">Unclassified</option>
<option value="157">Volatility Managed</option>
</select></div></div>
I hope this all makes sense.
While I run my code it hangs frequently. If you can help it would be very much appreciated
Thanks!
Hi
Please may anyone help me out. I'd very much appreciate it
Thanks
- Interkoubess8 years agoSolution Sage
Hi KM007,
I did not understand very well what you are trying to do.
Please could you explain with your expected results and I will try to help or call experts of M to help you.
Ninter
- KM0078 years agoHelper II
Hi Interkoubess
See pic below
For each sector (smaller red box) in the list eg 'Asia Pacific Ex Japan' I want to download the Funds Listed (bigger red box)
Does this help you understand what I want to achieve?
Much appreciate your help!
Thanks