6 Messages
Digest #4269
Messages
Mon Dec 18, 2017 7:13 pm (PST) . Posted by:
e_bartsch
Randy:
Turns out I'm still stumped, so sent along a test workbook to this email address:
smf_addin-owner@yahoogroups.com
Thanks for taking a look.
Eric Bartsch
Turns out I'm still stumped, so sent along a test workbook to this email address:
smf_addin-owner@yahoogroups.com
Thanks for taking a look.
Eric Bartsch
Mon Dec 18, 2017 7:31 pm (PST) . Posted by:
kitiany
Randy, All,
I used to use RCHGetYahooQuotes quite a bit for PE, short interest, Market Cap, Dividend yield, etc.
Yahoo shut that down. Any suggestion for functions that would give this info.
I once used RCHGetYahooHistory on a weekly basis but have learned to use smfGetYahooHistory as its replacement.
Randy,
Thanks for creating and supporting this group for all of these years. I have had lots of fun.
Happy holidays to you and everyone.
Best regards,
Kit
I used to use RCHGetYahooQuotes quite a bit for PE, short interest, Market Cap, Dividend yield, etc.
Yahoo shut that down. Any suggestion for functions that would give this info.
I once used RCHGetYahooHistory on a weekly basis but have learned to use smfGetYahooHistory as its replacement.
Randy,
Thanks for creating and supporting this group for all of these years. I have had lots of fun.
Happy holidays to you and everyone.
Best regards,
Kit
Mon Dec 18, 2017 10:55 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Take a look at the documentation and template for the new
smfGetYahooPortfolioView() function. It's replaced most of what
RCHGetYahooQuotes() was able to do.
On Mon, Dec 18, 2017 at 8:31 PM, Kitiany@
...
wrote:
> I used to use RCHGetYahooQuotes quite a bit for PE, short interest, Market
> Cap, Dividend yield, etc.
>
> Yahoo shut that down. Any suggestion for functions that would give this
> info.
>
> I once used RCHGetYahooHistory on a weekly basis but have learned to use smfGetYahooHistory
> as its replacement.
>
>
>
smfGetYahooPortfoli
RCHGetYahooQuotes(
On Mon, Dec 18, 2017 at 8:31 PM, Kitiany@
...
wrote:
> I used to use RCHGetYahooQuotes quite a bit for PE, short interest, Market
> Cap, Dividend yield, etc.
>
> Yahoo shut that down. Any suggestion for functions that would give this
> info.
>
> I once used RCHGetYahooHistory on a weekly basis but have learned to use smfGetYahooHistory
> as its replacement.
>
>
>
Mon Dec 18, 2017 11:37 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
The next release will have the ability to request specific option periods.
It will default to "A" (i.e. All), based on the approximate definitions I
gave before. Which won't always be correct. I'm trying to decide if there
is any easy way to handle holidays. I'm also not 100% sure of my
approximated date ranges for the days within a month. But I think they'll
be correct the vast majority of the time.
Example of the various periods being requested:
SPY SPY SPY SPY SPY SPY
A W M Q H V
2017-12-20 2017-12-22 2017-12-22 2017-12-29 2017-12-20 2017-12-20
2017-12-22 2017-12-29 2018-01-19 2018-03-29 2017-12-27 2018-01-17
2017-12-27 2018-01-05 2018-02-16 2018-06-29 2018-01-03
2017-12-29 2018-01-12 2018-03-16 2018-09-28 2018-01-10
2018-01-03 2018-01-19 2018-04-20 2018-01-17
2018-01-05 2018-01-26 2018-06-15
2018-01-10 2018-07-20
2018-01-12 2018-09-21
2018-01-17 2018-12-21
2018-01-19 2019-01-18
2018-01-26 2019-03-15
2018-02-16 2019-06-21
2018-03-16 2019-12-20
2018-03-29 2020-01-17
2018-04-20 2020-07-17
2018-06-15
2018-06-29
2018-07-20
2018-09-21
2018-09-28
2018-12-21
2019-01-18
2019-03-15
2019-06-21
2019-12-20
2020-01-17
2020-07-17
On Mon, Dec 18, 2017 at 3:11 PM, bobobfd@
...
wrote:
>
> Couple of things re smfGetOptionExpirations :
>
> 2. Is it possible to filter the returned option expirations by type -
> weekly, monthly, all?? Trying to get a list of only monthly expirations by
> formula is cumbersome at best. (No knowledge of VBA.)
>
>
It will default to "A" (i.e. All), based on the approximate definitions I
gave before. Which won't always be correct. I'm trying to decide if there
is any easy way to handle holidays. I'm also not 100% sure of my
approximated date ranges for the days within a month. But I think they'll
be correct the vast majority of the time.
Example of the various periods being requested:
SPY SPY SPY SPY SPY SPY
A W M Q H V
2017-12-20 2017-12-22 2017-12-22 2017-12-29 2017-12-20 2017-12-20
2017-12-22 2017-12-29 2018-01-19 2018-03-29 2017-12-27 2018-01-17
2017-12-27 2018-01-05 2018-02-16 2018-06-29 2018-01-03
2017-12-29 2018-01-12 2018-03-16 2018-09-28 2018-01-10
2018-01-03 2018-01-19 2018-04-20 2018-01-17
2018-01-05 2018-01-26 2018-06-15
2018-01-10 2018-07-20
2018-01-12 2018-09-21
2018-01-17 2018-12-21
2018-01-19 2019-01-18
2018-01-26 2019-03-15
2018-02-16 2019-06-21
2018-03-16 2019-12-20
2018-03-29 2020-01-17
2018-04-20 2020-07-17
2018-06-15
2018-06-29
2018-07-20
2018-09-21
2018-09-28
2018-12-21
2019-01-18
2019-03-15
2019-06-21
2019-12-20
2020-01-17
2020-07-17
On Mon, Dec 18, 2017 at 3:11 PM, bobobfd@
...
wrote:
>
> Couple of things re smfGetOptionExpirat
>
> 2. Is it possible to filter the returned option expirations by type -
> weekly, monthly, all?? Trying to get a list of only monthly expirations by
> formula is cumbersome at best. (No knowledge of VBA.)
>
>
Tue Dec 19, 2017 9:56 am (PST) . Posted by:
"Jose Jacob" pepecan47
I am trying to use:use
=RCHGetHTMLTable("http://performance.morningstar.com/Performance/stock/dividend-history.action?y=50&t=XOM","Record Date",-1,"",1)
to get the dividend history. But the way it;s formatted in the table, I can not use it to compute dividend growth, dividend increases, etc.
Is there a way to get rid of the rows that have only the year?
Regards, Jose L. Jacob
=RCHGetHTMLTable("http://performance.morningstar.com/Performance/stock/dividend-history.action?y=50&t=XOM","
to get the dividend history. But the way it;s formatted in the table, I can not use it to compute dividend growth, dividend increases, etc.
Is there a way to get rid of the rows that have only the year?
Regards, Jose L. Jacob
Tue Dec 19, 2017 10:42 am (PST) . Posted by:
"Randy Harmelink" rharmelink
I think you'd have to make a range derived from it, extracting just the
lines without those years.
Can you use GuruFocus, or is this data only available to subscribers?
=RCHGetHTMLTable("https://www.gurufocus.com/dividend/MMM",">Ex-Date")
On Tue, Dec 19, 2017 at 10:55 AM, Jose Jacob pepecan47@
...
wrote:
>
> I am trying to use:use
>
> =RCHGetHTMLTable("http://performance.morningstar.com/
> Performance/stock/dividend-history.action?y=50&t=XOM","Record
> Date",-1,"",1)
>
> to get the dividend history. But the way it;s formatted in the table, I
> can not use it to compute dividend growth, dividend increases, etc.
>
> Is there a way to get rid of the rows that have only the year?
>
>
lines without those years.
Can you use GuruFocus, or is this data only available to subscribers?
=RCHGetHTMLTable("https://www.gurufocus.com/dividend/MMM",">Ex-Date")
On Tue, Dec 19, 2017 at 10:55 AM, Jose Jacob pepecan47@
...
wrote:
>
> I am trying to use:use
>
> =RCHGetHTMLTable("http://performance.morningstar.com/
> Performance/
> Date",-
>
> to get the dividend history. But the way it;s formatted in the table, I
> can not use it to compute dividend growth, dividend increases, etc.
>
> Is there a way to get rid of the rows that have only the year?
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar