8 Messages
Digest #4256
1b
Re: Add button for recalc and some intermittant issues with smfGetYa by "Randy Harmelink" rharmelink
1d
Re: Add button for recalc and some intermittant issues with smfGetYa by "Randy Harmelink" rharmelink
Messages
Tue Dec 5, 2017 5:28 am (PST) . Posted by:
eclipsme
Since switching to "smfGetYahooPortfolioView"; and updating to current version the button that I had put on the ribbon bar to recalculate worksheet stopped working - I had installed to a different folder than before. I deleted the button and am trying to add a new one. Also, some strange and intermittent issues have started recently.
1. When I go into Options, Customize Ribbon and change Popular Commands to Macros, none come up. However, if I right-click the spreadsheet, I do get the SMF menu item and the Recalculate Worksheet appears there, so the macro does seem to be loaded???
2. well, sort of. I am also intermittently .losing the SMF menu item from the context menu. Closing and opening will often, but not always bring it back.
3. I am capturing data for 50 stocks. Sometimes, the array will only grab about 45 of these stocks, leaving dashes in place of data. Closing and reloading will usually, but not always bring this data back. Doing a recalc will often loose the data again, though. I think the only way to get it back is to close, without saving, and open it again.
Version 2.1.2017.11.30 C:|SMF
Thank you!
1. When I go into Options, Customize Ribbon and change Popular Commands to Macros, none come up. However, if I right-click the spreadsheet, I do get the SMF menu item and the Recalculate Worksheet appears there, so the macro does seem to be loaded???
2. well, sort of. I am also intermittently .losing the SMF menu item from the context menu. Closing and opening will often, but not always bring it back.
3. I am capturing data for 50 stocks. Sometimes, the array will only grab about 45 of these stocks, leaving dashes in place of data. Closing and reloading will usually, but not always bring this data back. Doing a recalc will often loose the data again, though. I think the only way to get it back is to close, without saving, and open it again.
Version 2.1.2017.11.
Thank you!
Tue Dec 5, 2017 12:20 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Do you have other add-ins installed? Something may be interfering with the
Auto_Open and Auto_Close routines in the add-in. Or, do you do things in
VBA? I've found if I have to reset the VBA environment to recover from an
errors, it sometimes interferes with the add-in's VBA project as well.
But something unusual is certainly going on?
On Tue, Dec 5, 2017 at 6:28 AM, harvey@
...
wrote:
>
> Since switching to "smfGetYahooPortfolioView"; and updating to current
> version the button that I had put on the ribbon bar to recalculate
> worksheet stopped working - I had installed to a different folder than
> before. I deleted the button and am trying to add a new one. Also, some
> strange and intermittent issues have started recently.
>
> 1. When I go into Options, Customize Ribbon and change Popular Commands to
> Macros, none come up. However, if I right-click the spreadsheet, I do get
> the SMF menu item and the Recalculate Worksheet appears there, so the macro
> does seem to be loaded???
>
> 2. well, sort of. I am also intermittently .losing the SMF menu item from
> the context menu. Closing and opening will often, but not always bring it
> back.
>
> 3. I am capturing data for 50 stocks. Sometimes, the array will only grab
> about 45 of these stocks, leaving dashes in place of data. Closing and
> reloading will usually, but not always bring this data back. Doing a recalc
> will often loose the data again, though. I think the only way to get it
> back is to close, without saving, and open it again.
>
> Version 2.1.2017.11.30 C:|SMF
>
>
Auto_Open and Auto_Close routines in the add-in. Or, do you do things in
VBA? I've found if I have to reset the VBA environment to recover from an
errors, it sometimes interferes with the add-in's VBA project as well.
But something unusual is certainly going on?
On Tue, Dec 5, 2017 at 6:28 AM, harvey@
...
wrote:
>
> Since switching to "smfGetYahooPo
> version the button that I had put on the ribbon bar to recalculate
> worksheet stopped working - I had installed to a different folder than
> before. I deleted the button and am trying to add a new one. Also, some
> strange and intermittent issues have started recently.
>
> 1. When I go into Options, Customize Ribbon and change Popular Commands to
> Macros, none come up. However, if I right-click the spreadsheet, I do get
> the SMF menu item and the Recalculate Worksheet appears there, so the macro
> does seem to be loaded???
>
> 2. well, sort of. I am also intermittently .losing the SMF menu item from
> the context menu. Closing and opening will often, but not always bring it
> back.
>
> 3. I am capturing data for 50 stocks. Sometimes, the array will only grab
> about 45 of these stocks, leaving dashes in place of data. Closing and
> reloading will usually, but not always bring this data back. Doing a recalc
> will often loose the data again, though. I think the only way to get it
> back is to close, without saving, and open it again.
>
> Version 2.1.2017.11.
>
>
Tue Dec 5, 2017 3:30 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
On Tue, Dec 5, 2017 at 6:28 AM, harvey@eclipsme.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> Since switching to "smfGetYahooPortfolioView" and updating to current
> version the button that I had put on the ribbon bar to recalculate
> worksheet stopped working - I had installed to a different folder than
> before. I deleted the button and am trying to add a new one.
>
Normal so far. If you moved the add-in, you'd have to change the button
(or add a new one) to point to the macro in the new add-in location.
> Also, some strange and intermittent issues have started recently.
>
> 1. When I go into Options, Customize Ribbon and change Popular Commands to
> Macros, none come up. However, if I right-click the spreadsheet, I do get
> the SMF menu item and the Recalculate Worksheet appears there, so the macro
> does seem to be loaded???
>
If no macros are listed, I would assume the add-in is no longer loaded.
The SMF menu items might still exist because the menu wasn't removed when
the add-in was unloaded. Easy to test -- are the SMF menu items functional?
But I have no clue what might be unloading the add-in, given you have no
other add-ins running and don't do VBA development?
------------------------------
2. well, sort of. I am also intermittently .losing the SMF menu item from
> the context menu. Closing and opening will often, but not always bring it
> back.
>
Sounds like something is interfering with EXCEL loading the add-in. Which
version of EXCEL?
Did you have the Microsoft security issue that required the add-in's XLA
file to be unblocked? See:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/30568
------------------------------
3. I am capturing data for 50 stocks. Sometimes, the array will only grab
> about 45 of these stocks, leaving dashes in place of data. Closing and
> reloading will usually, but not always bring this data back. Doing a recalc
> will often loose the data again, though. I think the only way to get it
> back is to close, without saving, and open it again.
>
What does your array-entered formula look like? What parameters does it use?
How are you doing a recalc?
smf_addin@yahoogroups.com> wrote:
>
> Since switching to "smfGetYahooPortfolioView" and updating to current
> version the button that I had put on the ribbon bar to recalculate
> worksheet stopped working - I had installed to a different folder than
> before. I deleted the button and am trying to add a new one.
>
Normal so far. If you moved the add-in, you'd have to change the button
(or add a new one) to point to the macro in the new add-in location.
> Also, some strange and intermittent issues have started recently.
>
> 1. When I go into Options, Customize Ribbon and change Popular Commands to
> Macros, none come up. However, if I right-click the spreadsheet, I do get
> the SMF menu item and the Recalculate Worksheet appears there, so the macro
> does seem to be loaded???
>
If no macros are listed, I would assume the add-in is no longer loaded.
The SMF menu items might still exist because the menu wasn't removed when
the add-in was unloaded. Easy to test -- are the SMF menu items functional?
But I have no clue what might be unloading the add-in, given you have no
other add-ins running and don't do VBA development?
------------------------------
2. well, sort of. I am also intermittently .losing the SMF menu item from
> the context menu. Closing and opening will often, but not always bring it
> back.
>
Sounds like something is interfering with EXCEL loading the add-in. Which
version of EXCEL?
Did you have the Microsoft security issue that required the add-in's XLA
file to be unblocked? See:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/30568
------------
3. I am capturing data for 50 stocks. Sometimes, the array will only grab
> about 45 of these stocks, leaving dashes in place of data. Closing and
> reloading will usually, but not always bring this data back. Doing a recalc
> will often loose the data again, though. I think the only way to get it
> back is to close, without saving, and open it again.
>
What does your array-entered formula look like? What parameters does it use?
How are you doing a recalc?
Tue Dec 5, 2017 12:00 pm (PST) . Posted by:
lexstar
Does smfGetYahooHistory() or smfPricesBetween() work anymore?
All I get with smfGetYahooHistory() is "error" and smfPricesBetween() is 0
They seem to be working til end of last month.
All I get with smfGetYahooHistory(
They seem to be working til end of last month.
Tue Dec 5, 2017 12:15 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Both of those functions are working here.
Which version of the add-in are you using?
=RCHGetElementNumber("Version")
I don't see any changes to those routines since July, so not sure why they
would have stop working in the last week.
For smfGetYahooHistory(), "Error" would usually mean a communications
problem.
On Tue, Dec 5, 2017 at 1:00 PM, lexstar@
...
wrote:
> Does smfGetYahooHistory() or smfPricesBetween() work anymore?
>
> All I get with smfGetYahooHistory() is "error" and smfPricesBetween() is 0
>
> They seem to be working til end of last month.
>
Which version of the add-in are you using?
=RCHGetElementNumbe
I don't see any changes to those routines since July, so not sure why they
would have stop working in the last week.
For smfGetYahooHistory(
problem.
On Tue, Dec 5, 2017 at 1:00 PM, lexstar@
...
wrote:
> Does smfGetYahooHistory(
>
> All I get with smfGetYahooHistory(
>
> They seem to be working til end of last month.
>
Tue Dec 5, 2017 1:27 pm (PST) . Posted by:
lexstar
Stock Market Functions add-in, Version 2.1.2017.11.11 (C:\Program Files\SMF Add-In; Windows (64-bit) NT 10.00; 16.0; ; ; 1)
Tue Dec 5, 2017 3:16 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
What do you get with:
=RCHGetWebData("https://finance.yahoo.com/quote/MMM/
history?period1=0&period2=1512518400&interval=1d&filter=history&frequency=1d
","HistoricalPriceStore",200)
Does that URL work for you in the EXCEL IE object (keyboard shortcut
alt+d+d+w)?
On Tue, Dec 5, 2017 at 2:27 PM, lexstar@
...
wrote:
>
> Stock Market Functions add-in, Version 2.1.2017.11.11 (C:\Program
> Files\SMF Add-In; Windows (64-bit) NT 10.00; 16.0; ; ; 1)
>
>
>
=RCHGetWebData("https://finance.yahoo.com/quote/MMM/
history?period1=
","
Does that URL work for you in the EXCEL IE object (keyboard shortcut
alt+d+d+w)?
On Tue, Dec 5, 2017 at 2:27 PM, lexstar@
...
wrote:
>
> Stock Market Functions add-in, Version 2.1.2017.11.
> Files\SMF Add-In; Windows (64-bit) NT 10.00; 16.0; ; ; 1)
>
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar