7 Messages
Digest #3945
Messages
Sun Mar 19, 2017 7:14 pm (PDT) . Posted by:
nelsonmuntz1000
Hi Randy, hope you are well.
Redux Zacks ETF Rank:
Last formula provided worked for some time while Zacks rank went premium.
=smfConvertData(smfGetTagContent("https://www.zacks.com/funds/etf/SPY/profile https://www.zacks.com/funds/etf/SPY/profile","span",1,">Zacks Premium",">Zacks Premium",">Zacks ETF Rank"))
I tried modifying formula to accommodate changes, can't seem to get it to work. Help please?
Link: https://www.zacks.com/funds/etf/SPY/profile?q=spy https://www.zacks.com/funds/etf/SPY/profile?q=spy
Thanks in advance.
Redux Zacks ETF Rank:
Last formula provided worked for some time while Zacks rank went premium.
=smfConvertData(smfGetTagContent("https://www.zacks.com/funds/etf/SPY/profile https://www.zacks.com/funds/etf/SPY/profile","span",1,">Zacks Premium",">Zacks Premium",">Zacks ETF Rank"))
I tried modifying formula to accommodate changes, can't seem to get it to work. Help please?
Link: https://www.zacks.com/funds/etf/SPY/profile?q=spy https://www.zacks.com/funds/etf/SPY/profile?q=spy
Thanks in advance.
Sun Mar 19, 2017 7:47 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
The top listing really isn't within a <scan> tag. The second one looks
easier to pick up:
=smfConvertData(smfGetTagContent("
https://www.zacks.com/funds/etf/SPY/profile","span",2,">Zacks ETF
Rank",">Zacks ETF Rank"))
What I looked at:
1. First checked that the URL wasn't redirecting to another URL
2. Used the "By Cascading Value" worksheet of the
SMF-Quick-Webpage-Examination.xls workbook, filling in the URL and using
">Zacks ETF Rank" as my cascading value, so I could look at what shows up.
On Sun, Mar 19, 2017 at 7:05 PM, ccoupe300@
...wrote:
>
> Redux Zacks ETF Rank:
>
> Last formula provided worked for some time while Zacks rank went premium.
>
> =smfConvertData(smfGetTagContent("https://www.zacks.com/funds/etf/SPY/
> profile","span",1,">Zacks Premium",">Zacks Premium",">Zacks ETF Rank"))
>
> I tried modifying formula to accommodate changes, can't seem to get it to
> work. Help please?
>
> Link: https://www.zacks.com/funds/etf/SPY/profile?q=spy
>
>
easier to pick up:
=smfConvertData(smfGetTagContent("
https://www.zacks.com/funds/etf/SPY/profile","span",2,">Zacks ETF
Rank",">Zacks ETF Rank"))
What I looked at:
1. First checked that the URL wasn't redirecting to another URL
2. Used the "By Cascading Value" worksheet of the
SMF-Quick-Webpage-Examination.xls workbook, filling in the URL and using
">Zacks ETF Rank" as my cascading value, so I could look at what shows up.
On Sun, Mar 19, 2017 at 7:05 PM, ccoupe300@
...wrote:
>
> Redux Zacks ETF Rank:
>
> Last formula provided worked for some time while Zacks rank went premium.
>
> =smfConvertData(smfGetTagContent("https://www.zacks.com/funds/etf/SPY/
> profile","span",1,">Zacks Premium",">Zacks Premium",">Zacks ETF Rank"))
>
> I tried modifying formula to accommodate changes, can't seem to get it to
> work. Help please?
>
> Link: https://www.zacks.com/funds/etf/SPY/profile?q=spy
>
>
Sun Mar 19, 2017 8:10 pm (PDT) . Posted by:
nelsonmuntz1000
Thanks Randy. I will check out your Examination Spreadsheet. You are awesome!
Mon Mar 20, 2017 6:09 pm (PDT) . Posted by:
johnross999
When trying to use the smfGetOptionExpirations() function using Yahoo as parameter none of the expirations are displayed.
When using OX it is working fine although it retrieves one wrong expiry from Jul 4,2017.
When using with Google only 4 monthly expirations are available. (no weeklies).
I tried with few different stocks (AAPL, MMM, AA and others) - same result.
I also upgraded to the latest version of the add-on - still same problem.
It was working properly for few years and stops from March, 11.
Any ideas why? Tx
When using OX it is working fine although it retrieves one wrong expiry from Jul 4,2017.
When using with Google only 4 monthly expirations are available. (no weeklies).
I tried with few different stocks (AAPL, MMM, AA and others) - same result.
I also upgraded to the latest version of the add-on - still same problem.
It was working properly for few years and stops from March, 11.
Any ideas why? Tx
Mon Mar 20, 2017 6:47 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Yeah. They changed it again. It now has to be retrieved from their JSON
feed instead of from the options web page.
I have the code updated, but haven't gotten around to releasing it. Sorry.
Things are going a bit slower these days.
On Mon, Mar 20, 2017 at 6:09 PM, johnrr9@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> When trying to use the smfGetOptionExpirations() function using Yahoo as
> parameter none of the expirations are displayed.
> When using OX it is working fine although it retrieves one wrong expiry
> from Jul 4,2017.
> When using with Google only 4 monthly expirations are available. (no
> weeklies).
>
> I tried with few different stocks (AAPL, MMM, AA and others) - same result.
> I also upgraded to the latest version of the add-on - still same problem.
>
> It was working properly for few years and stops from March, 11.
>
> Any ideas why? Tx
>
feed instead of from the options web page.
I have the code updated, but haven't gotten around to releasing it. Sorry.
Things are going a bit slower these days.
On Mon, Mar 20, 2017 at 6:09 PM, johnrr9@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> When trying to use the smfGetOptionExpirat
> parameter none of the expirations are displayed.
> When using OX it is working fine although it retrieves one wrong expiry
> from Jul 4,2017.
> When using with Google only 4 monthly expirations are available. (no
> weeklies).
>
> I tried with few different stocks (AAPL, MMM, AA and others) - same result.
> I also upgraded to the latest version of the add-on - still same problem.
>
> It was working properly for few years and stops from March, 11.
>
> Any ideas why? Tx
>
Mon Mar 20, 2017 6:13 pm (PDT) . Posted by:
greg_in_marin
Howdy. I belong to a windows update mailing list for Systems Administrators folks, and there is a confirmed issue with Windows Update KB3178690 which is causing Excel to crash upon recalculation.
Please see this article for more: https://www.askwoody.com/2017/excel-security-patch-ms17-014-for-excel-2010-kb-3178690-triggering-crashes/ https://www.askwoody.com/2017/excel-security-patch-ms17-014-for-excel-2010-kb-3178690-triggering-crashes/
excerpt:
On the TechNet Excel forum poster Steve Stretch says:
Since the update 2 days ago (KB3178690). The following section of code now freezes Excel. I guess the application may be churning over and over… This code has worked for 10 years without a hitch, now all 25 clients still running Excel 2010 have reported this freeze error.
Microsoft acknowledges the problem, both in the KB article, and on the Office support forum.
Known issues in this security update
After you install this security update, Excel 2010 may crash or hang (stop responding or freeze) when calculations are performed in a workbook. The calculations may be triggered either by code or by user interaction.
Microsoft is researching this problem and will post more information in this article when the information becomes available.
At this point, the only known solution is to uninstall the security patch.
Please see this article for more: https://www.askwoody.com/2017/excel-security-patch-ms17-014-for-excel-2010-kb-3178690-triggering-crashes/ https://www.askwoody.com/2017/excel-security-patch-ms17-014-for-excel-2010-kb-3178690-triggering-crashes/
excerpt:
On the TechNet Excel forum poster Steve Stretch says:
Since the update 2 days ago (KB3178690). The following section of code now freezes Excel. I guess the application may be churning over and over… This code has worked for 10 years without a hitch, now all 25 clients still running Excel 2010 have reported this freeze error.
Microsoft acknowledges the problem, both in the KB article, and on the Office support forum.
Known issues in this security update
After you install this security update, Excel 2010 may crash or hang (stop responding or freeze) when calculations are performed in a workbook. The calculations may be triggered either by code or by user interaction.
Microsoft is researching this problem and will post more information in this article when the information becomes available.
At this point, the only known solution is to uninstall the security patch.
Mon Mar 20, 2017 6:32 pm (PDT) . Posted by:
gaeisen
Thanks for confirming this. I figured this out yesterday the hard way. My long spreadsheet with lots of SMF links kept crashing, and I tried all sorts of other angles until the light went off in my head and I thought to check for updates. Sure enough, last Thursday MSFT pushed out an update and so I deleted it (after exhausting a bunch of other options) and sure enough it worked.
Greg.
----- Original Message -----
From: "gregfarber@gmail.com [smf_addin]" <smf_addin@yahoogroups.com>
To: "smf addin" <smf_addin@yahoogroups.com>
Sent: Monday, March 20, 2017 4:23:56 PM
Subject: [smf_addin] March 2017 Excel 2010 security patch causes crashes
Howdy. I belong to a windows update mailing list for Systems Administrators folks, and there is a confirmed issue with Windows Update KB3178690 which is causing Excel to crash upon recalculation.
Please see this article for more: https://www.askwoody.com/2017/excel-security-patch-ms17-014-for-excel-2010-kb-3178690-triggering-crashes/
excerpt:
On the TechNet Excel forum poster Steve Stretch says:
Since the update 2 days ago (KB3178690). The following section of code now freezes Excel. I guess the application may be churning over and over… This code has worked for 10 years without a hitch, now all 25 clients still running Excel 2010 have reported this freeze error.
Microsoft acknowledges the problem, both in the KB article, and on the Office support forum.
Known issues in this security update
After you install this security update, Excel 2010 may crash or hang (stop responding or freeze) when calculations are performed in a workbook. The calculations may be triggered either by code or by user interaction.
Microsoft is researching this problem and will post more information in this article when the information becomes available.
At this point, the only known solution is to uninstall the security patch.
Greg.
----- Original Message -----
From: "gregfarber@gmail.com [smf_addin]" <smf_addin@yahoogroups.com>
To: "smf addin" <smf_addin@yahoogroups.com>
Sent: Monday, March 20, 2017 4:23:56 PM
Subject: [smf_addin] March 2017 Excel 2010 security patch causes crashes
Howdy. I belong to a windows update mailing list for Systems Administrators folks, and there is a confirmed issue with Windows Update KB3178690 which is causing Excel to crash upon recalculation.
Please see this article for more: https://www.askwoody.com/2017/excel-security-patch-ms17-014-for-excel-2010-kb-3178690-triggering-crashes/
excerpt:
On the TechNet Excel forum poster Steve Stretch says:
Since the update 2 days ago (KB3178690). The following section of code now freezes Excel. I guess the application may be churning over and over… This code has worked for 10 years without a hitch, now all 25 clients still running Excel 2010 have reported this freeze error.
Microsoft acknowledges the problem, both in the KB article, and on the Office support forum.
Known issues in this security update
After you install this security update, Excel 2010 may crash or hang (stop responding or freeze) when calculations are performed in a workbook. The calculations may be triggered either by code or by user interaction.
Microsoft is researching this problem and will post more information in this article when the information becomes available.
At this point, the only known solution is to uninstall the security patch.
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar