[smf_addin] Digest Number 4538

EXCEL Stock Market Functions Add-in Group

3 Messages

Digest #4538

1.1

New file uploaded to smf_addin by

2a

RCHGetHTMLtable by descormiersg@videotron.ca

2b

Re: RCHGetHTMLtable by "Randy Harmelink" rharmelink

Messages

1.1

New file uploaded to smf_addin

Tue May 7, 2019 11:52 am (PDT) . Posted by:

Hello,

This email message is a notification to let you know that
a file has been uploaded to the Files area of the smf_addin
group.

File : /Uploads by forum members/GurufFocus Updated Download Template.xlsx
Uploaded by : hamishthedenizen <dan-carroll@yahoo.com>
Description : An updated Financials download sheet that works with GuruFocus free version to give you last 4 years, TTM and last 5 Qs

You can access this file at the URL:
https://groups.yahoo.com/neo/groups/smf_addin/files/Uploads%20by%20forum%20members/GurufFocus%20Updated%20Download%20Template.xlsx

To learn more about file sharing for your group, please visit:
https://help.yahoo.com/kb/index?page=content&y=PROD_GRPS&locale=en_US&id=SLN15398

Regards,

hamishthedenizen <dan-carroll@yahoo.com>

Reply to sender . Reply to group . Reply via Web Post . All Messages (94) . Top ^

2a

RCHGetHTMLtable

Tue May 7, 2019 1:56 pm (PDT) . Posted by:

descormiersg@videotron.ca

Hi Randy

I use this web table to get the earning announcement date.

RCHGetHTMLTable("https://web.tmxmoney.com/earnings_cal.php?date="&TEXTE(G7;"
aaaa-mm-jj")&"&market=All";">Symbol")

Do you think it is possible to get it for a specific symbol ?

Tanks in advance

Guy

Reply to sender . Reply to group . Reply via Web Post . All Messages (2) . Top ^

2b

Re: RCHGetHTMLtable

Tue May 7, 2019 2:37 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

I don't see a way, because the web pages for individual ticker symbols are
built by a protected QuoteMedia API.

On Tue, May 7, 2019 at 1:57 PM descormiersg@... wrote:

>
>
> I use this web table to get the earning announcement date.
>
>
>
> RCHGetHTMLTable("https://web.tmxmoney.com/earnings_cal.php?date=
> "&TEXTE(G7;"aaaa-mm-jj")&"&market=All";">Symbol")
>
>
>
> Do you think it is possible to get it for a specific symbol ?
>
>
>
>
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (2) . Top ^

For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Visit Your Group

• Privacy • Unsubscribe • Terms of Use