Forum Discussion
Help with M query hanging
Hi KM007,
The error I have got is below:
Expression.Error: The name 'SectorIDs pt1' wasn't recognized. Make sure it's spelled correctly.
Do you really have
'SectorIDs pt1'
Could you please explain what you want to do and we can figure out another approach...
Ninter
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!
- KM0078 years agoHelper II
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