13 Messages
Digest #3991
Messages
Mon May 1, 2017 1:19 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Hopefully, this update fixes things:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/31909
On Mon, May 1, 2017 at 7:50 AM, rr76012@
...wrote:
> Monday 5-1-2017
>
> Re: RchGetElementNumber 621 = Yahoo eps growth rate
> Is anyone else getting an error for rchgetelementnumber 621, Yahoo eps
> estimate growth rate?
>
>
>
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/31909
On Mon, May 1, 2017 at 7:50 AM, rr76012@
...wrote:
> Monday 5-1-2017
>
> Re: RchGetElementNumber 621 = Yahoo eps growth rate
> Is anyone else getting an error for rchgetelementnumber 621, Yahoo eps
> estimate growth rate?
>
>
>
Mon May 1, 2017 2:00 pm (PDT) . Posted by:
friedman_steve
So i was having the issue earlier today too. Got the newest xla file and working great now. & faster than it used to be. THANKS!
Mon May 1, 2017 2:58 pm (PDT) . Posted by:
"Barry Rosman" bnr0sman
Fixed the problem.
Thank you.
From: "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com>
To: smf_addin@yahoogroups.com
Sent: Monday, May 1, 2017 4:13 PM
Subject: Re: [smf_addin] SMF Options
#NAME? usually means the function can't be found. Are you sure the add-in is activated in the add-in manager?
On Mon, May 1, 2017 at 9:37 AM, Barry Rosman bnr0sman@...wrote:
The smfGetYahooOptionQuote has stopped working. It last worked on Friday.
=smfGetYahooOptionQuote(Y2, AB2,Z2,AA2,"l") it returns #NAME?
#yiv4811860574 #yiv4811860574 -- #yiv4811860574ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv4811860574 #yiv4811860574ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv4811860574 #yiv4811860574ygrp-mkp #yiv4811860574hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv4811860574 #yiv4811860574ygrp-mkp #yiv4811860574ads {margin-bottom:10px;}#yiv4811860574 #yiv4811860574ygrp-mkp .yiv4811860574ad {padding:0 0;}#yiv4811860574 #yiv4811860574ygrp-mkp .yiv4811860574ad p {margin:0;}#yiv4811860574 #yiv4811860574ygrp-mkp .yiv4811860574ad a {color:#0000ff;text-decoration:none;}#yiv4811860574 #yiv4811860574ygrp-sponsor #yiv4811860574ygrp-lc {font-family:Arial;}#yiv4811860574 #yiv4811860574ygrp-sponsor #yiv4811860574ygrp-lc #yiv4811860574hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv4811860574 #yiv4811860574ygrp-sponsor #yiv4811860574ygrp-lc .yiv4811860574ad {margin-bottom:10px;padding:0 0;}#yiv4811860574 #yiv4811860574actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv4811860574 #yiv4811860574activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv4811860574 #yiv4811860574activity span {font-weight:700;}#yiv4811860574 #yiv4811860574activity span:first-child {text-transform:uppercase;}#yiv4811860574 #yiv4811860574activity span a {color:#5085b6;text-decoration:none;}#yiv4811860574 #yiv4811860574activity span span {color:#ff7900;}#yiv4811860574 #yiv4811860574activity span .yiv4811860574underline {text-decoration:underline;}#yiv4811860574 .yiv4811860574attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv4811860574 .yiv4811860574attach div a {text-decoration:none;}#yiv4811860574 .yiv4811860574attach img {border:none;padding-right:5px;}#yiv4811860574 .yiv4811860574attach label {display:block;margin-bottom:5px;}#yiv4811860574 .yiv4811860574attach label a {text-decoration:none;}#yiv4811860574 blockquote {margin:0 0 0 4px;}#yiv4811860574 .yiv4811860574bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv4811860574 .yiv4811860574bold a {text-decoration:none;}#yiv4811860574 dd.yiv4811860574last p a {font-family:Verdana;font-weight:700;}#yiv4811860574 dd.yiv4811860574last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv4811860574 dd.yiv4811860574last p span.yiv4811860574yshortcuts {margin-right:0;}#yiv4811860574 div.yiv4811860574attach-table div div a {text-decoration:none;}#yiv4811860574 div.yiv4811860574attach-table {width:400px;}#yiv4811860574 div.yiv4811860574file-title a, #yiv4811860574 div.yiv4811860574file-title a:active, #yiv4811860574 div.yiv4811860574file-title a:hover, #yiv4811860574 div.yiv4811860574file-title a:visited {text-decoration:none;}#yiv4811860574 div.yiv4811860574photo-title a, #yiv4811860574 div.yiv4811860574photo-title a:active, #yiv4811860574 div.yiv4811860574photo-title a:hover, #yiv4811860574 div.yiv4811860574photo-title a:visited {text-decoration:none;}#yiv4811860574 div#yiv4811860574ygrp-mlmsg #yiv4811860574ygrp-msg p a span.yiv4811860574yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv4811860574 .yiv4811860574green {color:#628c2a;}#yiv4811860574 .yiv4811860574MsoNormal {margin:0 0 0 0;}#yiv4811860574 o {font-size:0;}#yiv4811860574 #yiv4811860574photos div {float:left;width:72px;}#yiv4811860574 #yiv4811860574photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv4811860574 #yiv4811860574photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv4811860574 #yiv4811860574reco-category {font-size:77%;}#yiv4811860574 #yiv4811860574reco-desc {font-size:77%;}#yiv4811860574 .yiv4811860574replbq {margin:4px;}#yiv4811860574 #yiv4811860574ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv4811860574 #yiv4811860574ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv4811860574 #yiv4811860574ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv4811860574 #yiv4811860574ygrp-mlmsg select, #yiv4811860574 input, #yiv4811860574 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv4811860574 #yiv4811860574ygrp-mlmsg pre, #yiv4811860574 code {font:115% monospace;}#yiv4811860574 #yiv4811860574ygrp-mlmsg * {line-height:1.22em;}#yiv4811860574 #yiv4811860574ygrp-mlmsg #yiv4811860574logo {padding-bottom:10px;}#yiv4811860574 #yiv4811860574ygrp-msg p a {font-family:Verdana;}#yiv4811860574 #yiv4811860574ygrp-msg p#yiv4811860574attach-count span {color:#1E66AE;font-weight:700;}#yiv4811860574 #yiv4811860574ygrp-reco #yiv4811860574reco-head {color:#ff7900;font-weight:700;}#yiv4811860574 #yiv4811860574ygrp-reco {margin-bottom:20px;padding:0px;}#yiv4811860574 #yiv4811860574ygrp-sponsor #yiv4811860574ov li a {font-size:130%;text-decoration:none;}#yiv4811860574 #yiv4811860574ygrp-sponsor #yiv4811860574ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv4811860574 #yiv4811860574ygrp-sponsor #yiv4811860574ov ul {margin:0;padding:0 0 0 8px;}#yiv4811860574 #yiv4811860574ygrp-text {font-family:Georgia;}#yiv4811860574 #yiv4811860574ygrp-text p {margin:0 0 1em 0;}#yiv4811860574 #yiv4811860574ygrp-text tt {font-size:120%;}#yiv4811860574 #yiv4811860574ygrp-vital ul li:last-child {border-right:none !important;}#yiv4811860574
Thank you.
From: "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com>
To: smf_addin@yahoogroups.com
Sent: Monday, May 1, 2017 4:13 PM
Subject: Re: [smf_addin] SMF Options
#NAME? usually means the function can't be found. Are you sure the add-in is activated in the add-in manager?
On Mon, May 1, 2017 at 9:37 AM, Barry Rosman bnr0sman@...wrote:
The smfGetYahooOptionQu
=smfGetYahooOptionQ
#yiv4811860574 #yiv4811860574 -- #yiv4811860574ygrp-
Mon May 1, 2017 3:02 pm (PDT) . Posted by:
hsadvisor1
Hi Randy,
When I downloaded the most recent version of the SMF add-in, I lost most if not all the Yahoo Mutual Fund RCHGHETNUMBER Functions. Among the most important functions for me are;
Fund Name
Fund Category
Fund Overall Morningstar Rating
Standard Deviation
Sharpe Ratio
Worst 1 Year
Best 1 Year
Fund Holdings Overall Composition -- Cash Fund Holdings -- Overall Composition -- Stocks Fund Holdings -- Overall Composition -- Bonds Fund Holdings -- Overall Composition -- Other
Fund Profile -- Fees -- Fund -- Annual Report Expense Ratio
Is there a fix coming to restore these functions, or have recent Yahoo url changes blocked access.
I did see some workarounds that you suggested for other members. Can much of the data I listed above be brought in with RCHGGetyahooquotes. If so, how. Is there a list key words of key words that work with RCHGGetyahooquotes?
Oddly, when I use my laptop excel version, which I did not update, I believe RCHGETNumber works. Should I just copy over the old files to my desktop?
Sorry to give such a long list of issues. Any help would be appreciated. Franl;y, I don't know how you keep up with all of this.
Best Regards,
Harry
When I downloaded the most recent version of the SMF add-in, I lost most if not all the Yahoo Mutual Fund RCHGHETNUMBER Functions. Among the most important functions for me are;
Fund Name
Fund Category
Fund Overall Morningstar Rating
Standard Deviation
Sharpe Ratio
Worst 1 Year
Best 1 Year
Fund Holdings Overall Composition -- Cash Fund Holdings -- Overall Composition -- Stocks Fund Holdings -- Overall Composition -- Bonds Fund Holdings -- Overall Composition -- Other
Fund Profile -- Fees -- Fund -- Annual Report Expense Ratio
Is there a fix coming to restore these functions, or have recent Yahoo url changes blocked access.
I did see some workarounds that you suggested for other members. Can much of the data I listed above be brought in with RCHGGetyahooquotes. If so, how. Is there a list key words of key words that work with RCHGGetyahooquotes?
Oddly, when I use my laptop excel version, which I did not update, I believe RCHGETNumber works. Should I just copy over the old files to my desktop?
Sorry to give such a long list of issues. Any help would be appreciated. Franl;y, I don't know how you keep up with all of this.
Best Regards,
Harry
Mon May 1, 2017 3:41 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
On Mon, May 1, 2017 at 3:02 PM, hsadvisor1@
...wrote:
> When I downloaded the most recent version of the SMF add-in, I lost most
> if not all the Yahoo Mutual Fund RCHGHETNUMBER Functions. Among the most
> important functions for me are;
>
The function calls actually broke last month, when Yahoo switched over to
dynamic builds of HTML tables using data retrieved via a JSON call.
Fund Name
>
> Fund Category
>
> Fund Overall Morningstar Rating
>
> Standard Deviation
>
> Sharpe Ratio
>
> Worst 1 Year
>
> Best 1 Year
> Fund Holdings Overall Composition -- Cash
> Fund Holdings -- Overall Composition -- Stocks
> Fund Holdings -- Overall Composition -- Bonds
>
> Fund Holdings -- Overall Composition -- Other
> Fund Profile -- Fees -- Fund -- Annual Report Expense Ratio
>
I've listed work-arounds for some in the group, but don't have time to do
every single one. I'd rather spend the time redefining the elements.
Right now, I've got a list of about 1200 JSON field names for mutual funds.
Is there a fix coming to restore these functions, or have recent Yahoo url
> changes blocked access.
>
I'm hoping to redefine the elements, but it will take time.
> I did see some workarounds that you suggested for other members. Can much
> of the data I listed above be brought in with RCHGGetyahooquotes. If so,
> how. Is there a list key words of key words that work with
> RCHGGetyahooquotes?
>
Of those you list, nName is about the only thing that can be retrieved
with RCHGetYahooQuotes(). The list of available items would be in
documentation of the function on the add-in website.
> Oddly, when I use my laptop excel version, which I did not update, I
> believe RCHGETNumber works. Should I just copy over the old files to my
> desktop?
>
It shouldn't work, as far as I know. Unless you're picking up cached
copies of old web pages.
Sorry to give such a long list of issues. Any help would be appreciated.
> Franl;y, I don't know how you keep up with all of this.
>
Yahoo has been a problem lately.
...wrote:
> When I downloaded the most recent version of the SMF add-in, I lost most
> if not all the Yahoo Mutual Fund RCHGHETNUMBER Functions. Among the most
> important functions for me are;
>
The function calls actually broke last month, when Yahoo switched over to
dynamic builds of HTML tables using data retrieved via a JSON call.
Fund Name
>
> Fund Category
>
> Fund Overall Morningstar Rating
>
> Standard Deviation
>
> Sharpe Ratio
>
> Worst 1 Year
>
> Best 1 Year
> Fund Holdings Overall Composition -- Cash
> Fund Holdings -- Overall Composition -- Stocks
> Fund Holdings -- Overall Composition -- Bonds
>
> Fund Holdings -- Overall Composition -- Other
> Fund Profile -- Fees -- Fund -- Annual Report Expense Ratio
>
I've listed work-arounds for some in the group, but don't have time to do
every single one. I'd rather spend the time redefining the elements.
Right now, I've got a list of about 1200 JSON field names for mutual funds.
Is there a fix coming to restore these functions, or have recent Yahoo url
> changes blocked access.
>
I'm hoping to redefine the elements, but it will take time.
> I did see some workarounds that you suggested for other members. Can much
> of the data I listed above be brought in with RCHGGetyahooquotes. If so,
> how. Is there a list key words of key words that work with
> RCHGGetyahooquotes?
>
Of those you list, nName is about the only thing that can be retrieved
with RCHGetYahooQuotes(
documentation of the function on the add-in website.
> Oddly, when I use my laptop excel version, which I did not update, I
> believe RCHGETNumber works. Should I just copy over the old files to my
> desktop?
>
It shouldn'
copies of old web pages.
Sorry to give such a long list of issues. Any help would be appreciated.
> Franl;y, I don't know how you keep up with all of this.
>
Yahoo has been a problem lately.
Mon May 1, 2017 4:36 pm (PDT) . Posted by:
daringler
Randy,
It appears this page was changed over the weekend. Using your updated tool, is there a way to get the entire table containing "Last Price" on this link?
https://finance.yahoo.com/quotes/%5EIXIC,%5EDJI,GM,IBM,HPQ,AAPL/view/view_0 https://finance.yahoo.com/quotes/%5EIXIC,%5EDJI,GM,IBM,HPQ,AAPL/view/view_0
Thanks for your untiring effort to create and maintain your Add-In.
Dennis
Mon May 1, 2017 5:32 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
There is no table delivered within the source code of the web page. It is
built dynamically using JSON data.
On Mon, May 1, 2017 at 4:36 PM, daringler@
...wrote:
> It appears this page was changed over the weekend. Using your updated
> tool, is there a way to get the entire table containing "Last Price" on
> this link?
>
> https://finance.yahoo.com/quotes/%5EIXIC,%5EDJI,GM,IBM,
> HPQ,AAPL/view/view_0
>
> Thanks for your untiring effort to create and maintain your Add-In.
>
>
built dynamically using JSON data.
On Mon, May 1, 2017 at 4:36 PM, daringler@
...wrote:
> It appears this page was changed over the weekend. Using your updated
> tool, is there a way to get the entire table containing "Last Price" on
> this link?
>
> https://finance.yahoo.com/quotes/%5EIXIC,%5EDJI,GM,IBM,
> HPQ,AAPL/view/
>
> Thanks for your untiring effort to create and maintain your Add-In.
>
>
Mon May 1, 2017 4:44 pm (PDT) . Posted by:
hsadvisor1
Sorry to be such a bother, but after re-downloading the latest add-in version, for some reason, I've lost my Morningstar mutual fund functions such as 4717 net stocks etc.
Obviously, I've fouled everything up, but I'm certain I've installed the add-in correctly.
Any suggestions or quick work arounds.
Harry
Mon May 1, 2017 5:37 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
More details please. I have no idea what "such as 4717 net stocks" means...
On Mon, May 1, 2017 at 4:44 PM, hsadvisor1@
...wrote:
> Sorry to be such a bother, but after re-downloading the latest add-in
> version, for some
> r
> eason, I've lost my Morningstar mutual fund functions such as 4717 net
> stocks etc.
>
> Obviously, I've fouled everything up, but I'm certain I've installed the
> add-in correctly.
>
> Any suggestions or quick work arounds.
>
>
On Mon, May 1, 2017 at 4:44 PM, hsadvisor1@
...wrote:
> Sorry to be such a bother, but after re-downloading the latest add-in
> version, for some
> r
> eason, I've lost my Morningstar mutual fund functions such as 4717 net
> stocks etc.
>
> Obviously, I've fouled everything up, but I'm certain I've installed the
> add-in correctly.
>
> Any suggestions or quick work arounds.
>
>
Mon May 1, 2017 5:11 pm (PDT) . Posted by:
gshell422
That worked. Thanks so much for all the work that you do. Changes at Yahoo must make your life a nightmare.
Mon May 1, 2017 5:48 pm (PDT) . Posted by:
yolande_tulasse
As usual... You're the man Randy! Working like a charm.
Mon May 1, 2017 7:29 pm (PDT) . Posted by:
tom835720
I've been using the SMF add-in for years. I only use it once or twice a week. I updated to the latest Excel 2013 version last week. SMF is no longer working. Have tried downloading new SMF files, etc., can't get it to work. A couple of times I've been able to get the
=RCHGetElementNumber("Version")
to display the correct version, but it mostly it just displays #NAME?
I don't know if this problem is the result of the Excel update, or the new SMF files, or something else. Anyone else having this issue?
Thanks,
T
=RCHGetElementNumbe
to display the correct version, but it mostly it just displays #NAME?
I don't know if this problem is the result of the Excel update, or the new SMF files, or something else. Anyone else having this issue?
Thanks,
T
Mon May 1, 2017 7:36 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Typically, #NAME? on an add-in function means the add-in is not active. The
first thing to do is check the add-in manager and see if it is checked
there.
There was a Microsoft security update in August that affected a lot of
people, as it prevented "downloaded" add-ins from loading at EXCEL
start-up. That cause people to have to re-active the add-in every time they
restarted EXCEL. Microsoft had a work-around for the issue:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/30568
On Mon, May 1, 2017 at 6:43 PM, tomoesterle@
...wrote:
> I've been using the SMF add-in for years. I only use it once or twice a
> week. I updated to the latest Excel 2013 version last week. SMF is no
> longer working. Have tried downloading new SMF files, etc., can't get it
> to work. A couple of times I've been able to get the
>
> *=RCHGetElementNumber("Version") *
>
> to display the correct version, but it mostly it just displays #NAME?
>
> I don't know if this problem is the result of the Excel update, or the new
> SMF files, or something else. Anyone else having this issue?
>
>
first thing to do is check the add-in manager and see if it is checked
there.
There was a Microsoft security update in August that affected a lot of
people, as it prevented "downloaded" add-ins from loading at EXCEL
start-up. That cause people to have to re-active the add-in every time they
restarted EXCEL. Microsoft had a work-around for the issue:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/30568
On Mon, May 1, 2017 at 6:43 PM, tomoesterle@
...wrote:
> I've been using the SMF add-in for years. I only use it once or twice a
> week. I updated to the latest Excel 2013 version last week. SMF is no
> longer working. Have tried downloading new SMF files, etc., can't get it
> to work. A couple of times I've been able to get the
>
> *=RCHGetElementNumb
>
> to display the correct version, but it mostly it just displays #NAME?
>
> I don't know if this problem is the result of the Excel update, or the new
> SMF files, or something else. Anyone else having this issue?
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar