[smf_addin] Digest Number 4645

EXCEL Stock Market Functions Add-in Group

5 Messages

Digest #4645

1a

Re: Net Worth Non Financial Corp Business from FRED by waterboy5555

1b

Re: Net Worth Non Financial Corp Business from FRED by "Randy Harmelink" rharmelink

2a

Yahoo earning calendar by descormiersg@videotron.ca

2b

Re: Yahoo earning calendar by "Randy Harmelink" rharmelink

2c

Re: Yahoo earning calendar by descormiersg@videotron.ca

Messages

1a

Re: Net Worth Non Financial Corp Business from FRED

Tue Nov 12, 2019 9:56 am (PST) . Posted by:

waterboy5555

hmmm i am putting the =smfGetCSVFile(D4) in an array so it is {=smf...} but it says error. what could i be doing wrong? thanks..

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

1b

Re: Net Worth Non Financial Corp Business from FRED

Tue Nov 12, 2019 11:56 am (PST) . Posted by:

"Randy Harmelink" rharmelink

Can you attach a workbook with just those two items in it?

On Tue, Nov 12, 2019 at 11:07 AM bopha99@... wrote:

>
> hmmm i am putting the =smfGetCSVFile(D4) in an array so it is {=smf...}
> but it says error. what could i be doing wrong? thanks.
>
>
>

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

2a

Yahoo earning calendar

Tue Nov 12, 2019 12:56 pm (PST) . Posted by:

descormiersg@videotron.ca

Hi Randy

Is it possible to get the earnings calendar from
<https://finance.yahoo.com/calendar/earnings?from=2019-11-10&to=2019-11-16&d
ay=2019-11-12>
https://finance.yahoo.com/calendar/earnings?from=2019-11-10&to=2019-11-16&da
y=2019-11-12 ?

I did try by RCHGetHTMLTable but it does not seem to work ? In advance thank
you.

Guy

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

2b

Re: Yahoo earning calendar

Tue Nov 12, 2019 2:59 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

For a given date, you can grab tables of 100 at a time by array-enterering
something like these over a range:

=RCHGetHTMLTable("
https://finance.yahoo.com/calendar/earnings?day=2019-11-12&offset=0&size=100
",">Reported")
=RCHGetHTMLTable("
https://finance.yahoo.com/calendar/earnings?day=2019-11-12&offset=100&size=100
",">Reported")
=RCHGetHTMLTable("
https://finance.yahoo.com/calendar/earnings?day=2019-11-12&offset=200&size=100",">Reported")

On Tue, Nov 12, 2019 at 1:56 PM descormiersg@... wrote:

>
> Is it possible to get the earnings calendar from
> https://finance.yahoo.com/calendar/earnings?from=2019-11-10&to=2019-11-16&day=2019-11-12
> ?
>
> I did try by RCHGetHTMLTable but it does not seem to work ? In advance
> thank you.
>
>
>

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

2c

Re: Yahoo earning calendar

Tue Nov 12, 2019 4:31 pm (PST) . Posted by:

descormiersg@videotron.ca

Thank you. It is super!

De : smf_addin@yahoogroups.com <smf_addin@yahoogroups.com>
Envoyé : 12 novembre 2019 18:00
À : smf_addin@yahoogroups.com
Objet : Re: [smf_addin] Yahoo earning calendar

For a given date, you can grab tables of 100 at a time by array-enterering something like these over a range:

=RCHGetHTMLTable("https://finance.yahoo.com/calendar/earnings?day=2019-11-12 <https://finance.yahoo.com/calendar/earnings?day=2019-11-12&offset=0&size=100> &offset=0&size=100",">Reported")

=RCHGetHTMLTable("https://finance.yahoo.com/calendar/earnings?day=2019-11-12 <https://finance.yahoo.com/calendar/earnings?day=2019-11-12&offset=100&size=100> &offset=100&size=100",">Reported")

=RCHGetHTMLTable("https://finance.yahoo.com/calendar/earnings?day=2019-11-12 <https://finance.yahoo.com/calendar/earnings?day=2019-11-12&offset=200&size=100> &offset=200&size=100",">Reported")

On Tue, Nov 12, 2019 at 1:56 PM descormiersg@... wrote:

Is it possible to get the earnings calendar from <https://finance.yahoo..com/calendar/earnings?from=2019-11-10&to=2019-11-16&day=2019-11-12> https://finance..yahoo.com/calendar/earnings?from=2019-11-10&to=2019-11-16&day=2019-11-12 ?

I did try by RCHGetHTMLTable but it does not seem to work ? In advance thank you.

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

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

Visit Your Group

• Privacy • Unsubscribe • Terms of Use