Rabu, 20 Desember 2017

[smf_addin] Digest Number 4270

9 Messages

Digest #4270
1d
Re: Website to extract dividend frequency by "Randy Harmelink" rharmelink
1e
Re: Website to extract dividend frequency by "Randy Harmelink" rharmelink
1g
Re: Website to extract dividend frequency by "Randy Harmelink" rharmelink
2a
ETF Screen Problem by g.simon@sbcglobal.net
2b
Re: ETF Screen Problem by "Randy Harmelink" rharmelink

Messages

Wed Dec 20, 2017 4:50 am (PST) . Posted by:

a.bereziuk

Randy, I tried your formula:

=COUNT(smfGetYahooHistory(C4,B4-365,+B4,"v",,0,,20,2))/2

with such input:
C4 - Ticker
B4 - today()

It did not work. Please advise what parameters mean because the documentation seems to be obsolete. Why "+B4"?

Wed Dec 20, 2017 5:38 am (PST) . Posted by:

a.bereziuk

If I enter:

=smfGetYahooHistory("MCD";"01.01.2017";"30.07.2017";"v";;0;;20;2)

I get this number: 42887
What is this?

Wed Dec 20, 2017 7:48 am (PST) . Posted by:

speedking1621ok

From my end, this looks like a date value. The value 42887 is Thursday, June 1, 2017.

Wed Dec 20, 2017 10:32 am (PST) . Posted by:

"Randy Harmelink" rharmelink

Not sure what to tell you -- it's working fine here:

2017-12-20 MMM 4

The "+" instead of B4 doesn't affect anything. You can take it off if you
like.

On Wed, Dec 20, 2017 at 5:46 AM, a.bereziuk@
​...
wrote:

>
> Randy, I tried your formula:
>
> =COUNT(smfGetYahooHistory(C4,B4-365,+B4,"v",,0,,20,2))/2
>
> with such input:
> C4 - Ticker
> B4 - today()
>
> It did not work. Please advise what parameters mean because the
> documentation seems to be obsolete. Why "+B4"?
>
>

Wed Dec 20, 2017 10:37 am (PST) . Posted by:

"Randy Harmelink" rharmelink

I don't understand why it would work at all. Those are invalid dates.

But, as speedking noted, it's a serial date value. If you only entered it
into a single cell, that's all you'd get. You're telling it to return a
20-row by 2-column array, so you should be array-entering it over that
range if you want such data. For:

=smfGetYahooHistory("MCD","01/01/2017","07/30/2017","v",,0,,20,2)

....I get:

2017-06-01 0.94
2017-02-27 0.94

On Wed, Dec 20, 2017 at 6:36 AM, a.bereziuk@
​...
wrote:

>
> If I enter:
>
> =smfGetYahooHistory("MCD";"01.01.2017";"30.07.2017";"v";;0;;20;2)
>
> I get this number: 42887
> What is this?
>

Wed Dec 20, 2017 3:09 pm (PST) . Posted by:

"Higrm" higrm

Hi Randy,This is very nice.  It's a great way to get the frequency of past dividends.  I subtracted 10 more days in your formula, B4-375, because if you are close to the current dividend date and it's varied a bit year to year, you may miss one, (GLDI for example only showed 11 dividends with B4-365 as the start date.)
Fantastic work!
Thanks Randy


On Wednesday, December 20, 2017, 8:06:01 PM GMT+1, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:

 

Not sure what to tell you -- it's working fine here:

| 2017-12-20 | MMM | 4 |

The "+" instead of B4 doesn't affect anything. You can take it off if you like.

On Wed, Dec 20, 2017 at 5:46 AM, a.bereziuk@​... wrote:

Randy, I tried your formula:

=COUNT(smfGetYahooHistory(C4, B4-365,+B4,"v",,0,,20,2))/2

with such input:
C4 - Ticker
B4 - today()

It did not work. Please advise what parameters mean because the documentation seems to be obsolete. Why "+B4"?

Wed Dec 20, 2017 3:57 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

Another option would be:

=4*CEILING(COUNT(smfGetYahooHistory(C4, B4-365,B4,"v",,0,,20,2))/2/4,1)

Hmmm. Currently, Yahoo is not return and dividends for GLDI.

On Wed, Dec 20, 2017 at 4:09 PM, Higrm higrm@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
>
> Hi Randy,
> This is very nice. It's a great way to get the frequency of past
> dividends. I subtracted 10 more days in your formula, B4-*375*, because
> if you are close to the current dividend date and it's varied a bit year to
> year, you may miss one, (GLDI for example only showed 11 dividends with
> B4-365 as the start date.)
>
> Fantastic work!
>
> Thanks Randy
>
>
> On Wednesday, December 20, 2017, 8:06:01 PM GMT+1, Randy Harmelink
> rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
>
>
>
>
> Not sure what to tell you -- it's working fine here:
>
> 2017-12-20 MMM 4
>
> The "+" instead of B4 doesn't affect anything. You can take it off if you
> like.
>
>
> On Wed, Dec 20, 2017 at 5:46 AM, a.bereziuk@
> ​...
> wrote:
>
>
> Randy, I tried your formula:
>
> =
> ​​
> COUNT(smfGetYahooHistory(C4, B4-365,+B4,"v",,0,,20,2))/2
>
> with such input:
> C4 - Ticker
> B4 - today()
>
> It did not work. Please advise what parameters mean because the
> documentation seems to be obsolete. Why "+B4"?
>
>
>

Wed Dec 20, 2017 3:51 pm (PST) . Posted by:

g.simon@sbcglobal.net



RCHGetElementNumber (1084 - 1090) from ETF Screener not working anymore. Get "error" as a value.


Don't think I ever needed to before, but did log into ETF Screener with no difference.



Using SMF Add-In version 2.1.2017.05.03 with Excel 2013 and Windows 7


Wed Dec 20, 2017 4:33 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

Thanks for the heads up. They changed their URL to the "https://" protocol.
See:

https://smf-add-in.blogspot.com/2017/12/alert-all-etfscreencom-element.html

On Wed, Dec 20, 2017 at 4:50 PM, g.simon@
​...
wrote:

> RCHGetElementNumber (1084 - 1090) from ETF Screener not working anymore.
> Get "error" as a value.
>
> Don't think I ever needed to before, but did log into ETF Screener with no
> difference.
>
> Using SMF Add-In version 2.1.2017.05.03 with Excel 2013 and Windows 7
>
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Diposting oleh EXCEL FEED LEARNING di 18.15

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)