Help to extract Leading Economic Indicators HTML data | Forex Factory

Options

Permalinks
Print Thread

Similar Threads

Lagging Indicators -vs- Leading Indicators 48 replies

FF html loading help 0 replies

Is there a way to extract a given set of candles on MT4? 1 reply

How do I extract price data and stoch values in MT4 ? 7 replies

Attachments: Help to extract Leading Economic Indicators HTML data
Exit Attachments

Help to extract Leading Economic Indicators HTML data

  • #1
  • First Post: Edited Oct 13, 2021 4:19pm Oct 12, 2021 6:05am | Edited Oct 13, 2021 4:19pm
Hi all,

I would like to check the Leading Economic Indicators (LEI) published data on the Conference Board, Business Cycle Indicators page at https://www.conference-board.org/data/bci.cfm

I'm only interested in the value of the U.S. data which is displayed within the html code below. So after reading the entire webpage into a string, how can I search for and extract ONLY the value of the U.S. data which in the example below is +0.9% ? In other words, what is the StringFind mql4 search code I can use to find ONLY the value of the U.S. data within the webpage string.

Inserted Code
<tr class="even"> <td align="center"> <a href="bcicountry.cfm?cid=1" title="U.S.">U.S.</a> </td> <td align="center"> <span class="small_indicator up_small">+0.9%</span> </td> <td align="center"> 23 Sep. 2021 </td> </tr>

I attached a screenshot of what the LEI data looks like on the webpage.

I read the data from the webpage into a string using the ReadWebPage() function call from v4 of Hanover's b600+ utility functions from "hanover --- extensible functions b600 (np).mqh" at https://www.forexfactory.com/thread/...d-related-tips

I attached the mqh file below.

Inserted Code
// With hanover --- extensible functions b600 (np).mqh in the \MQL4\Include directory
#include <hanover --- extensible functions b600 (np).mqh>
 
string webpagetext = ReadWebPage("https://www.conference-board.org/data/bci.cfm");

I will really appreciate it if anyone can help me with this. Thanks.
Attached Image
Attached File(s)
File Type: mqh hanover --- extensible functions b600 (np).mqh   331 KB | 280 downloads
  • #2
  • Edited 2:57am Oct 13, 2021 1:32am | Edited 2:57am
Quoting global3
how can I search for and extract ONLY the value of the U.S. data which in the example below is +0.9% ?
Inserted Code
    int pos = StringFind(webpagetext, ">U.S.<");
    pos = StringFind(webpagetext, "%<", pos);
    double us_figure = StringToDouble(StringSubstr(webpagetext, pos-3, 3));
    if(StringGetCharacter(webpagetext, pos-4) == '-')
        us_figure = -us_figure;
    printf("figure = %+0.1f%%", us_figure);
Return To Disorder
  • #3
  • Last Post: Edited 4:20pm Oct 13, 2021 6:35am | Edited 4:20pm
Thank you very much rockit. I tried your code and it worked perfectly.
0 traders viewing now