10 Messages
Digest #4031
3a
Re: Simplest function to return last dividend/share & pay date for E by "Praedial Serf" akhiqg4v4nvkwldqgxmyxmejakyrix2iboxnk7fq
3b
Re: Simplest function to return last dividend/share & pay date for E by "Randy Harmelink" rharmelink
Messages
Wed May 24, 2017 11:40 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Yup. When EXCEL starts up, the add-in is supposed to add an entry to the
context menu (i.e. right mouse click). For me, it's the last item on the
list.
On Wed, May 24, 2017 at 11:21 AM, cschwartz@
...wrote:
>
> I don't see an option for SMF menu. Right click the cell in excel??
>
>
context menu (i.e. right mouse click). For me, it's the last item on the
list.
On Wed, May 24, 2017 at 11:21 AM, cschwartz@
...wrote:
>
> I don't see an option for SMF menu. Right click the cell in excel??
>
>
Wed May 24, 2017 11:47 am (PDT) . Posted by:
stumpy_chris
Thanks. But my last item is for a Hyperlink.
Wed May 24, 2017 4:02 pm (PDT) . Posted by:
stumpy_chris
I may have found the issue. For some reason the https was http (which you suggested).
When I changed this, the numbers showed up and the blanks disappeared.
Thanks for your help.
When I changed this, the numbers showed up and the blanks disappeared.
Thanks for your help.
Wed May 24, 2017 12:11 pm (PDT) . Posted by:
roesterling
=RCHGetYahooHistory(+$C3,2017,5,12,2017,5,12,,"C",0) shows a blank cell value.
Windows 7
Beta Release of RCH_Stock_Market...xla (2017-05-21)
Thank you for your assistance and your time.
rogeroesterling@gmail.com
Windows 7
Beta Release of RCH_Stock_Market...xla (2017-05-21)
Thank you for your assistance and your time.
rogeroesterling@gmail.com
Wed May 24, 2017 12:24 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
RCHGetYahooHistory() no longer retrieves Yahoo data, as the Yahoo CSV file
is no longer accessible to the add-in.
The 5017.05.21 version is so the new smfGetYahooHistory() function can be
tried out.
On Wed, May 24, 2017 at 12:11 PM, roesterling@ wrote:
>
> =RCHGetYahooHistory(+$C3,2017,5,12,2017,5,12,,"C",0) shows a blank cell
> value.
> Windows 7
> Beta Release of RCH_Stock_Market...xla (2017-05-21)
>
>
>
>
is no longer accessible to the add-in.
The 5017.05.21 version is so the new smfGetYahooHistory(
tried out.
On Wed, May 24, 2017 at 12:11 PM, roesterling@ wrote:
>
> =RCHGetYahooHistory
> value.
> Windows 7
> Beta Release of RCH_Stock_Market.
>
>
>
>
Wed May 24, 2017 1:13 pm (PDT) . Posted by:
sonofhercules
Randy -
Is this truly the end of the line for RCHGetYahooHistory(), then? I have greatly appreciated being able to use this functionality over the last few years; thank you for this great tool!
Regards,
Alex.
Is this truly the end of the line for RCHGetYahooHistory(
Regards,
Alex.
Wed May 24, 2017 3:40 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
End of the function, maybe, but not the data. Not yet, anyway. With the
management changeover at Yahoo, anything is possible.
I might try to feed smfGetYahooHistory() data into RCHGetYahooHistory(),
but it's too early to say. But some of the parameters might no longer be
valid. Moving targets...
I remember when MSN used to have a lot of nice features. Their StockScouter
ratings and screener were both sources of a lot of good data.
On Wed, May 24, 2017 at 1:13 PM, sonofhercules@
...wrote:
>
> Is this truly the end of the line for RCHGetYahooHistory(), then? I have
> greatly appreciated being able to use this functionality over the last few
> years; thank you for this great tool!
>
management changeover at Yahoo, anything is possible.
I might try to feed smfGetYahooHistory(
but it's too early to say. But some of the parameters might no longer be
valid. Moving targets...
I remember when MSN used to have a lot of nice features. Their StockScouter
ratings and screener were both sources of a lot of good data.
On Wed, May 24, 2017 at 1:13 PM, sonofhercules@
...wrote:
>
> Is this truly the end of the line for RCHGetYahooHistory(
> greatly appreciated being able to use this functionality over the last few
> years; thank you for this great tool!
>
Wed May 24, 2017 5:59 pm (PDT) . Posted by:
bizmark_ee
That would be cool to somehow make RCHGetYahooHistory() work again with the same parameters.
Wed May 24, 2017 6:38 pm (PDT) . Posted by:
"Praedial Serf" akhiqg4v4nvkwldqgxmyxmejakyrix2iboxnk7fq
Randy,
Thanks very much! The formulas you supplied worked for all of the ETFs I
tried. It also worked for some mutual funds, but not others. I was
surprised that, even within a particular fund family, it worked for some
funds, but not others.
Next I tried the example historic-quote formula from the FAQ 0.1b (and
RCHGetYahooHistory-Function.html):
*=RCHGetYahooHistory("IBM",2007,1,3,2007,1,3,,"A",0)*
The cell remained blank. Excel recognizes the function, but does not allow
it to be stepped through. Then I tried the FAQ array:
=RCHGetYahooHistory("IBM")
This returned 'Error'.
I then followed the instructions for setting the 'Access Data Sources
Across Domains' option in IE.
I was able to successfully use the RCHGetYahooQuotes function, but can't
figure out how to move forward with the RCHGetYahooHistory function.
On Tue, May 23, 2017 at 7:40 PM, Randy Harmelink rharmelink@gmail.com
[smf_addin] <smf_addin@yahoogroups.com> wrote:
>
>
> That was tough, because the pay date on ETFs is a difficult one to find.
> Try:
>
> =smfGetTagContent("http://performance.morningstar.com/
> Performance/stock/dividend-history.action?y=1&t=SPY", "td",1,"Cash
> Dividend",,,,1)
>
> =smfGetTagContent("http://performance.morningstar.com/
> Performance/stock/dividend-history.action?y=1&t=SPY", "td",-2,"Cash
> Dividend")
>
> On Tue, May 23, 2017 at 2:48 PM, Praedial Serf praedial.serf@
> ...wrote:
>
>> I just joined. I am confused by the many options. My goal is simple: one
>> Excel cell to return the last dividend per share figure for a specific ETF
>> and another to return the pay date for that dividend. I would appreciate
>> some guidance on the simplest formula/source to return this information.
>> Thanks!
>>
>>
>
>
Thanks very much! The formulas you supplied worked for all of the ETFs I
tried. It also worked for some mutual funds, but not others. I was
surprised that, even within a particular fund family, it worked for some
funds, but not others.
Next I tried the example historic-quote formula from the FAQ 0.1b (and
RCHGetYahooHistory-Function.html):
*=RCHGetYahooHistory("IBM",2007,1,3,2007,1,3,,"A",0)*
The cell remained blank. Excel recognizes the function, but does not allow
it to be stepped through. Then I tried the FAQ array:
=RCHGetYahooHistory("IBM")
This returned 'Error'.
I then followed the instructions for setting the 'Access Data Sources
Across Domains' option in IE.
I was able to successfully use the RCHGetYahooQuotes function, but can't
figure out how to move forward with the RCHGetYahooHistory function.
On Tue, May 23, 2017 at 7:40 PM, Randy Harmelink rharmelink@gmail.com
[smf_addin] <smf_addin@yahoogroups.com> wrote:
>
>
> That was tough, because the pay date on ETFs is a difficult one to find.
> Try:
>
> =smfGetTagContent("http://performance.morningstar.com/
> Performance/stock/dividend-history.action?y=1&t=SPY", "td",1,"Cash
> Dividend",,,,1)
>
> =smfGetTagContent("http://performance.morningstar.com/
> Performance/
> Dividend"
>
> On Tue, May 23, 2017 at 2:48 PM, Praedial Serf praedial.serf@
> ...wrote:
>
>> I just joined. I am confused by the many options. My goal is simple: one
>> Excel cell to return the last dividend per share figure for a specific ETF
>> and another to return the pay date for that dividend. I would appreciate
>> some guidance on the simplest formula/source to return this information.
>> Thanks!
>>
>>
>
>
Wed May 24, 2017 7:17 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Yahoo just changed things on their web site so RCHGetYahooHistory() can no
longer be used -- they have changed things so that the add-in can no longer
grab the CSV file. You may note a large number of conversations on the
Yahoo group concerning the issue.
However, I have create an experimental beta version of a function,
smfGetYahooHistory() that extracts it from JSON data. See:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/32112
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/32114
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/32237
Yahoo has been changing things left and right for the last month or two.
And with their recent acquisition, I fear further changes may be coming.
On Wed, May 24, 2017 at 6:15 PM, Praedial Serf praedial.serf@
...wrote:
>
> Thanks very much! The formulas you supplied worked for all of the ETFs I
> tried. It also worked for some mutual funds, but not others. I was
> surprised that, even within a particular fund family, it worked for some
> funds, but not others.
>
> Next I tried the example historic-quote formula from the FAQ 0.1b (and
> RCHGetYahooHistory-Function.html):
>
> *=RCHGetYahooHistory("IBM";,2007,1,3,2007,1,3,,"A",0)*
>
> The cell remained blank. Excel recognizes the function, but does not allow
> it to be stepped through. Then I tried the FAQ array:
>
> =RCHGetYahooHistory("IBM")
>
> This returned 'Error'.
>
> I then followed the instructions for setting the 'Access Data Sources
> Across Domains' option in IE.
>
> I was able to successfully use the RCHGetYahooQuotes function, but can't
> figure out how to move forward with the RCHGetYahooHistory function.
>
>
>
>
longer be used -- they have changed things so that the add-in can no longer
grab the CSV file. You may note a large number of conversations on the
Yahoo group concerning the issue.
However, I have create an experimental beta version of a function,
smfGetYahooHistory() that extracts it from JSON data. See:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/32112
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/32114
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/32237
Yahoo has been changing things left and right for the last month or two.
And with their recent acquisition, I fear further changes may be coming.
On Wed, May 24, 2017 at 6:15 PM, Praedial Serf praedial.serf@
...wrote:
>
> Thanks very much! The formulas you supplied worked for all of the ETFs I
> tried. It also worked for some mutual funds, but not others. I was
> surprised that, even within a particular fund family, it worked for some
> funds, but not others.
>
> Next I tried the example historic-quote formula from the FAQ 0.1b (and
> RCHGetYahooHistory-
>
> *=RCHGetYahooHistor
>
> The cell remained blank. Excel recognizes the function, but does not allow
> it to be stepped through. Then I tried the FAQ array:
>
> =RCHGetYahooHistory
>
> This returned 'Error&#
>
> I then followed the instructions for setting the 'Access Data Sources
> Across Domains' option in IE.
>
> I was able to successfully use the RCHGetYahooQuotes function, but can't
> figure out how to move forward with the RCHGetYahooHistory function.
>
>
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar