4 Messages
Digest #4475
Messages
Wed Jan 30, 2019 10:46 am (PST) . Posted by:
kitiany
For years, I have used
RCHGetTableCell("https://www.bloomberg.com/markets/rates-bonds/government-bonds/us?dummy="&<Date>,3,"Treasury Yields","3 Month",,,0) but stopped working.
I tested Alt+Shift+d+d+w, and entered the URL, and it looks like bloomberg.com now requires CAPTCHA and other anti-robot security protocols.
Thus I have tried to go to marketwatch or financial times site.
For some reason, I can't get
RCHGetTableCell(https://www.marketwatch.com/investing/Bond/TMUBMUSD03M?countrycode=BX",3,"3 Month Treasury",,,,0) to work on any index values. Perhaps there is no table.
I have resorted to using smfGetTagContent for the first time but have been stumped the the long strings that get returned.
If Randy or someone else can help out with some hints, I would greatly appreciate it.
Thanks,
Kit
RCHGetTableCell("https://www.bloomberg.com/markets/rates-bonds/government-bonds/us?dummy="&<Date>,3,"Treasury Yields","3 Month",,,0) but stopped working.
I tested Alt+Shift+d+d+w, and entered the URL, and it looks like bloomberg.com now requires CAPTCHA and other anti-robot security protocols.
Thus I have tried to go to marketwatch or financial times site.
For some reason, I can't get
RCHGetTableCell(https://www.marketwatch.com/investing/Bond/TMUBMUSD03M?countrycode=BX",3,"
I have resorted to using smfGetTagContent for the first time but have been stumped the the long strings that get returned.
If Randy or someone else can help out with some hints, I would greatly appreciate it.
Thanks,
Kit
Wed Jan 30, 2019 11:24 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Your search term of "3 Month Treasury" isn't a good one, as it would
position you on the title of the web page, far from the data you're trying
to extract.. And the yield you're after isn't even in a table, so
RCHGetTableCell() won't do the trick.
Either of these appear to work:
=smfStrExtr(RCHGetWebData("
https://www.marketwatch.com/investing/Bond/TMUBMUSD03M?countrycode=BX
","name=""price""",100),"content=""","""",1)
=smfGetTagContent("
https://www.marketwatch.com/investing/Bond/TMUBMUSD03M?countrycode=BX
","bg-quote",1,"class=""intraday__data""",,,,1)
On Wed, Jan 30, 2019 at 11:49 AM Kitiany@... wrote:
> For years, I have used
>
> RCHGetTableCell("
> https://www.bloomberg.com/markets/rates-bonds/government-bonds/us?dummy="&<Date>,3,"Treasury
> Yields","3 Month",,,0) but stopped working.
>
> I tested Alt+Shift+d+d+w, and entered the URL, and it looks like
> bloomberg.com now requires CAPTCHA and other anti-robot security
> protocols.
>
> Thus I have tried to go to marketwatch or financial times site.
>
> For some reason, I can't get
>
> RCHGetTableCell(
> https://www.marketwatch.com/investing/Bond/TMUBMUSD03M?countrycode=BX",3,"3
> Month Treasury",,,,0) to work on any index values. Perhaps there is no
> table.
>
> I have resorted to using smfGetTagContent for the first time but have been
> stumped the the long strings that get returned.
>
> If Randy or someone else can help out with some hints, I would greatly
> appreciate it.
>
>
>
position you on the title of the web page, far from the data you're trying
to extract.. And the yield you're after isn't even in a table, so
RCHGetTableCell() won't do the trick.
Either of these appear to work:
=smfStrExtr(RCHGetWebData("
https://www.marketwatch.com/investing/Bond/TMUBMUSD03M?countrycode=BX
","name=""price""",100),"content=""","""",1)
=smfGetTagContent("
https://www.marketwatch.com/investing/Bond/TMUBMUSD03M?countrycode=BX
","bg-quote",1,"class=""intraday__data""",,,,1)
On Wed, Jan 30, 2019 at 11:49 AM Kitiany@... wrote:
> For years, I have used
>
> RCHGetTableCell("
> https://www.bloomberg.com/markets/rates-bonds/government-bonds/us?dummy="&<Date>,3,"Treasury
> Yields","3 Month",,,0) but stopped working.
>
> I tested Alt+Shift+d+d+w, and entered the URL, and it looks like
> bloomberg.com now requires CAPTCHA and other anti-robot security
> protocols.
>
> Thus I have tried to go to marketwatch or financial times site.
>
> For some reason, I can't get
>
> RCHGetTableCell(
> https://www.marketwatch.com/investing/Bond/TMUBMUSD03M?countrycode=BX",3,"
> Month Treasury"
> table.
>
> I have resorted to using smfGetTagContent for the first time but have been
> stumped the the long strings that get returned.
>
> If Randy or someone else can help out with some hints, I would greatly
> appreciate it.
>
>
>
Wed Jan 30, 2019 5:54 pm (PST) . Posted by:
kitiany
Thanks!
I just switched to Windows 10, which I dislike, but discovered that IE 11 opens the source code with Microsoft Edge. (not Notepad, which I am comfortable with). But I now see Edge has an advantage of selecting the element and going right to the line of code with inspect element.
Kit
I just switched to Windows 10, which I dislike, but discovered that IE 11 opens the source code with Microsoft Edge. (not Notepad, which I am comfortable with). But I now see Edge has an advantage of selecting the element and going right to the line of code with inspect element.
Kit
Thu Jan 31, 2019 12:30 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Inspect won't always do the job. I believe that is based on the RENDERED
source code of the web page, not the DELIVERED source code of the web page.
On Wed, Jan 30, 2019 at 6:54 PM Kitiany@... wrote:
> I just switched to Windows 10, which I dislike, but discovered that IE 11
> opens the source code with Microsoft Edge. (not Notepad, which I am
> comfortable with). But I now see Edge has an advantage of selecting the
> element and going right to the line of code with inspect element.
>
>
>
source code of the web page, not the DELIVERED source code of the web page.
On Wed, Jan 30, 2019 at 6:54 PM Kitiany@... wrote:
> I just switched to Windows 10, which I dislike, but discovered that IE 11
> opens the source code with Microsoft Edge. (not Notepad, which I am
> comfortable with). But I now see Edge has an advantage of selecting the
> element and going right to the line of code with inspect element.
>
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar