9 Messages
Digest #4049
Messages
Sun Jun 4, 2017 4:35 am (PDT) . Posted by:
stevet99uk
Help needed. Used to save my spreadsheet and it held with it the SMF_addin with all the data. Now I have done something that stops this xla being saved with my spreadsheet - so all the downloaded data is lost and has to be reinstated from the web. Over the years my spreadsheet has grown so a full refresh of the data takes a long time.
The xla is available in C:\SMF add-in, which I have designated as a trusted location. also I have put a copy in the Microsoft Addin folder in case that helped - it didn't. The addin is registed when I open the file as an add-in and ticked, but is not loaded until I browse or run a macro to load it.
Any suggestions as to what I am doing wrong?
using excel 2013 running Windows 10 with the latest Creators update.
I've run out of thoughts of what I can try
Many thanks
The xla is available in C:\SMF add-in, which I have designated as a trusted location. also I have put a copy in the Microsoft Addin folder in case that helped - it didn't. The addin is registed when I open the file as an add-in and ticked, but is not loaded until I browse or run a macro to load it.
Any suggestions as to what I am doing wrong?
using excel 2013 running Windows 10 with the latest Creators update.
I've run out of thoughts of what I can try
Many thanks
Sun Jun 4, 2017 11:16 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
I'm not comprehending what you're describing. The add-in is not "held with"
or "saved with" a spreadsheet. EXCEL just saves hard-coded links to its
location with each add-in function. It SHOULD be "reinstating" and doing a
"full refresh" of the downloaded data when you open the file, as the
formulas need to recalculate.
Multiple copies of the add-in won't help anything. EXCEL will just try to
use the one that the workbook was. If it's not in that location, EXCEL will
mark it as an "unresolved link" and warn you about them. The smfFixLinks
macro in the add-in can fix those. The only location EXCEL itself worries
about is the one in the add-in manager. Everything else is just a link to
another workbook.
The add-in should be loaded when you open EXCEL, unless you have the
Microsoft security update that screwed that up, but the trusted location is
supposed to fix that. Unless you need to unblock the XLA file.
On Sun, Jun 4, 2017 at 4:35 AM, stevethompson486@
...
wrote:
> Help needed. Used to save my spreadsheet and it held with it the SMF_addin
> with all the data. Now I have done something that stops this xla being
> saved with my spreadsheet - so all the downloaded data is lost and has to
> be reinstated from the web. Over the years my spreadsheet has grown so a
> full refresh of the data takes a long time.
> The xla is available in C:\SMF add-in, which I have designated as a
> trusted location. also I have put a copy in the Microsoft Addin folder in
> case that helped - it didn't. The addin is registed when I open the file as
> an add-in and ticked, but is not loaded until I browse or run a macro to
> load it.
>
> Any suggestions as to what I am doing wrong?
>
> using excel 2013 running Windows 10 with the latest Creators update.
>
> I've run out of thoughts of what I can try
>
>
> Many thanks
>
>
>
>
or "saved with" a spreadsheet. EXCEL just saves hard-coded links to its
location with each add-in function. It SHOULD be "reinstating&q
"full refresh" of the downloaded data when you open the file, as the
formulas need to recalculate.
Multiple copies of the add-in won't help anything. EXCEL will just try to
use the one that the workbook was. If it's not in that location, EXCEL will
mark it as an "unresolved link" and warn you about them. The smfFixLinks
macro in the add-in can fix those. The only location EXCEL itself worries
about is the one in the add-in manager. Everything else is just a link to
another workbook.
The add-in should be loaded when you open EXCEL, unless you have the
Microsoft security update that screwed that up, but the trusted location is
supposed to fix that. Unless you need to unblock the XLA file.
On Sun, Jun 4, 2017 at 4:35 AM, stevethompson486@
...
wrote:
> Help needed. Used to save my spreadsheet and it held with it the SMF_addin
> with all the data. Now I have done something that stops this xla being
> saved with my spreadsheet - so all the downloaded data is lost and has to
> be reinstated from the web. Over the years my spreadsheet has grown so a
> full refresh of the data takes a long time.
> The xla is available in C:\SMF add-in, which I have designated as a
> trusted location. also I have put a copy in the Microsoft Addin folder in
> case that helped - it didn't. The addin is registed when I open the file as
> an add-in and ticked, but is not loaded until I browse or run a macro to
> load it.
>
> Any suggestions as to what I am doing wrong?
>
> using excel 2013 running Windows 10 with the latest Creators update.
>
> I've run out of thoughts of what I can try
>
>
> Many thanks
>
>
>
>
Sun Jun 4, 2017 9:12 am (PDT) . Posted by:
sjagers
Randy,
If you're interested, and/or if anyone else has the same problem with Windows Vista, IE9, and zacks.com, I found a temporary workaround.
I think zacks.com recently updated their webpage security protocol to TLS 1.2. Windows Vista and Firefox support TLS 1.2, but Windows Vista and Internet Explorer 9 do not. As a result, I could not access zacks website with IE9, nor could I access their website with Excel's web query or use the zacks elements numbers.
I fiddled with the the security settings in IE9: Tools > Internet Options > Advanced > Security Settings and unchecked "Use SSL 3.0". Apparently, that did the trick. I can now access their website and those getelement numbers work, at least for now.
FYI.
If you're interested, and/or if anyone else has the same problem with Windows Vista, IE9, and zacks.com, I found a temporary workaround.
I think zacks.com recently updated their webpage security protocol to TLS 1.2. Windows Vista and Firefox support TLS 1.2, but Windows Vista and Internet Explorer 9 do not. As a result, I could not access zacks website with IE9, nor could I access their website with Excel's web query or use the zacks elements numbers.
I fiddled with the the security settings in IE9: Tools > Internet Options > Advanced > Security Settings and unchecked "Use SSL 3.0". Apparently, that did the trick. I can now access their website and those getelement numbers work, at least for now.
FYI.
Sun Jun 4, 2017 12:11 pm (PDT) . Posted by:
msimmsx
re: "Yahoo data for funds as some things are just too hard to pull from MS. "
Its nearly impossible to get attribute data from MS as they're using a technique which is not conducive to screen scraping. This is by design....as they want you to buy their data products....which are very expensive....upwards of $10,000 per month !!
Its nearly impossible to get attribute data from MS as they're using a technique which is not conducive to screen scraping. This is by design....as they want you to buy their data products....
Sun Jun 4, 2017 2:14 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
It's not so hard to scrape data from the Morningstar "feeder" pages, such
as:
http://quotes.morningstar.com/fundq/c-header?t=VFINX
Now, Yahoo has gone to "feeder" JSON files.
But both are building the displayed web pages dynamically, so there's
nothing to scrape from the source code of the web page.
On Sun, Jun 4, 2017 at 12:11 PM, marksimms@
...
wrote:
> re: "Yahoo data for funds as some things are just too hard to pull from
> MS. "
>
> Its nearly impossible to get attribute data from MS as they're using a
> technique which is not conducive to screen scraping. This is by
> design....as they want you to buy their data products....which are very
> expensive....upwards of $10,000 per month !!
>
>
>
as:
http://quotes.morningstar.com/fundq/c-header?t=VFINX
Now, Yahoo has gone to "feeder" JSON files.
But both are building the displayed web pages dynamically, so there's
nothing to scrape from the source code of the web page.
On Sun, Jun 4, 2017 at 12:11 PM, marksimms@
...
wrote:
> re: "Yahoo data for funds as some things are just too hard to pull from
> MS. "
>
> Its nearly impossible to get attribute data from MS as they're using a
> technique which is not conducive to screen scraping. This is by
> design....as they want you to buy their data products....
> expensive...
>
>
>
Sun Jun 4, 2017 1:14 pm (PDT) . Posted by:
msimmsx
When I download and install the latest release from http://ogres-crypt.com/SMF/ http://ogres-crypt.com/SMF/ , I don't "see" the latest smfGetYahooHistory function.
Where is the release that has the ability to read the JSON format ?
Here is the latest log entry in RCHGetYahooHistory:
' 2017.04.17 -- Change protocol from "http://" to "https://"
here is the log entries from the download site:
Latest official relase of the add-in.
2017-04-17: Fix for Yahoo Historical data
2017-04-26: More Yahoo changes
2017-05-01: More Yahoo changes
2017-05-03: smfGetGuruFocusItem() changes
Where is the release that has the ability to read the JSON format ?
Here is the latest log entry in RCHGetYahooHistory:
' 2017.04.17 -- Change protocol from "http:/
here is the log entries from the download site:
Latest official relase of the add-in.
2017-04-17: Fix for Yahoo Historical data
2017-04-26: More Yahoo changes
2017-05-01: More Yahoo changes
2017-05-03: smfGetGuruFocusItem
Sun Jun 4, 2017 1:59 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Unfortunately, Yahoo is a nightmare of changes right now. :(
The changes for Yahoo historical quotes is currently in *beta* release,
because things could change before the official release. 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
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/32343
On Sun, Jun 4, 2017 at 1:14 PM, marksimms@verizon.net [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> When I download and install the latest release from
> http://ogres-crypt.com/SMF/ , I don't "see" the latest smfGetYahooHistory
> function.
> Where is the release that has the ability to read the JSON format ?
> Here is the latest log entry in RCHGetYahooHistory:
> ' 2017.04.17 -- Change protocol from "http://" to "https://"
>
> here is the log entries from the download site:
> Latest official relase of the add-in.
> 2017-04-17: Fix for Yahoo Historical data
> 2017-04-26: More Yahoo changes
> 2017-05-01: More Yahoo changes
> 2017-05-03: smfGetGuruFocusItem() changes
>
The changes for Yahoo historical quotes is currently in *beta* release,
because things could change before the official release. 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
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/32343
On Sun, Jun 4, 2017 at 1:14 PM, marksimms@verizon.net [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> When I download and install the latest release from
> http://ogres-crypt.com/SMF/ , I don't "see" the latest smfGetYahooHistory
> function.
> Where is the release that has the ability to read the JSON format ?
> Here is the latest log entry in RCHGetYahooHistory:
> ' 2017.04.17 -- Change protocol from "http:/
>
> here is the log entries from the download site:
> Latest official relase of the add-in.
> 2017-04-17: Fix for Yahoo Historical data
> 2017-04-26: More Yahoo changes
> 2017-05-01: More Yahoo changes
> 2017-05-03: smfGetGuruFocusItem
>
Sun Jun 4, 2017 1:44 pm (PDT) . Posted by:
cb4gusto22
Hello All,
Just looking for confirmation on whether this function is still working after all the Yahoo changes? I used to use it as an array-entered formula but it stopped working a few weeks back.
I have upgraded to the latest version (2.1.2017.05.03), but it still doesn't work. The following example returns "Error": RCHGetYahooHistory("SPY")
However, a simple example with RCHGetYahooQuotes("SPY", "o") does work.
Thanks for any help or updates!
Tony
Just looking for confirmation on whether this function is still working after all the Yahoo changes? I used to use it as an array-entered formula but it stopped working a few weeks back.
I have upgraded to the latest version (2.1.2017.05.
However, a simple example with RCHGetYahooQuotes(
Thanks for any help or updates!
Tony
Sun Jun 4, 2017 2:02 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Unfortunately, Yahoo is a nightmare of changes right now. :(
The changes for Yahoo historical quotes is currently in *beta* release,
because things could change before the official release. 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
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/32343
On Sun, Jun 4, 2017 at 1:10 PM, cb4gusto22@
...
wrote:
>
> Just looking for confirmation on whether this function is still working
> after all the Yahoo changes? I used to use it as an array-entered formula
> but it stopped working a few weeks back.
>
> I have upgraded to the latest version (2.1.2017.05.03), but it still
> doesn't work. The following example returns "Error":
> RCHGetYahooHistory("SPY")
>
> However, a simple example with RCHGetYahooQuotes("SPY", "o") does work.
>
>
The changes for Yahoo historical quotes is currently in *beta* release,
because things could change before the official release. 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
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/32343
On Sun, Jun 4, 2017 at 1:10 PM, cb4gusto22@
...
wrote:
>
> Just looking for confirmation on whether this function is still working
> after all the Yahoo changes? I used to use it as an array-entered formula
> but it stopped working a few weeks back.
>
> I have upgraded to the latest version (2.1.2017.05.
> doesn't work. The following example returns "Error"
> RCHGetYahooHistory(
>
> However, a simple example with RCHGetYahooQuotes(
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar