10 Messages
Digest #4257
1a
Re: Add button for recalc and some intermittant issues with smfGetYa by "Harvey Wasserman" eclipsme
1c
Re: Add button for recalc and some intermittant issues with smfGetYa by "Randy Harmelink" rharmelink
Messages
Wed Dec 6, 2017 2:10 am (PST) . Posted by:
"Harvey Wasserman" eclipsme
I have answered your individual questions in-line below.
I agree that this is all very perplexing and given nobody else is
complaining about this, I must assume it is something on my machine.
You say, "The SMF menu items might still exist because the menu wasn't
removed when the add-in was unloaded." Perhaps I have not completely
uninstalled?
I have just uninstalled - removed the check mark from the list, close
excel, start excel. I believe this is the correct way to uninstall, yes?
I then opened my worksheet and it updated!
=RCHGetElementNumber("Version") returns the correct version number.
I have verified that the addin is not selected. In fact, there are 2
entries - Rch_Stock_Market_Functions (I think an earlier version) and
Stock Market Functions Add-in, the current version. Both add-ins, and in
fact no add-ins, are selected, and yet the add-in is still functioning,
at least with the faults I have described.
Furthermore, with no add-ins selected and opening a new spreadsheet, the
SMF menu is still there and when I select Recalculate Worksheet, I can
tell from the Status bar that activity is taking place. However,
=RCHGetElementNumber("Version") returns a #NAME? error. So the menu item
is active in some way but the add-in is not loaded.
If the add-in is not loaded for a new sheet, why (How) is it loaded for
my existing sheet? Is it saved someplace within the sheet itself???
Is there a way to perform a 'complete' uninstall that removes all traces
from Excel? From there I could try a clean install again.
Any other ideas?
Thanks for taking the time!
>> 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.
Yes, I expected this. The problem is now I can not recreate the button,
as no macros are displayed to choose.
>> 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?
Yes, but intermittently.
>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?
Correct, no other add-ins and not using 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?
2016
>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
No. I have been using your addin for more than a year now. However,
looking at Trusted Locations, I just added the folder where the addin is
located, but nothing seems to have changed.
------------------------------
>>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?
=smfGetYahooPortfolioView($B$4:$B$411,$C$2:$AJ$2,,1)
$B$4:$B$411 = stock symbols
>How are you doing a recalc?
Right click, point to SMF and choose either Recalculate Selection or
Recalculate Worksheet (the items I wish to put on the Ribbon).
I agree that this is all very perplexing and given nobody else is
complaining about this, I must assume it is something on my machine.
You say, "The SMF menu items might still exist because the menu wasn't
removed when the add-in was unloaded." Perhaps I have not completely
uninstalled?
I have just uninstalled - removed the check mark from the list, close
excel, start excel. I believe this is the correct way to uninstall, yes?
I then opened my worksheet and it updated!
=RCHGetElementNumber("Version") returns the correct version number.
I have verified that the addin is not selected. In fact, there are 2
entries - Rch_Stock_Market_Functions (I think an earlier version) and
Stock Market Functions Add-in, the current version. Both add-ins, and in
fact no add-ins, are selected, and yet the add-in is still functioning,
at least with the faults I have described.
Furthermore, with no add-ins selected and opening a new spreadsheet, the
SMF menu is still there and when I select Recalculate Worksheet, I can
tell from the Status bar that activity is taking place. However,
=RCHGetElementNumber("Version") returns a #NAME? error. So the menu item
is active in some way but the add-in is not loaded.
If the add-in is not loaded for a new sheet, why (How) is it loaded for
my existing sheet? Is it saved someplace within the sheet itself???
Is there a way to perform a 'complete' uninstall that removes all traces
from Excel? From there I could try a clean install again.
Any other ideas?
Thanks for taking the time!
>> 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.
Yes, I expected this. The problem is now I can not recreate the button,
as no macros are displayed to choose.
>> 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?
Yes, but intermittently.
>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?
Correct, no other add-ins and not using 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?
2016
>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
No. I have been using your addin for more than a year now. However,
looking at Trusted Locations, I just added the folder where the addin is
located, but nothing seems to have changed.
------------
>>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?
=smfGetYahooPortfol
$B$4:$B$411 = stock symbols
>How are you doing a recalc?
Right click, point to SMF and choose either Recalculate Selection or
Recalculate Worksheet (the items I wish to put on the Ribbon).
Wed Dec 6, 2017 7:15 am (PST) . Posted by:
eclipsme
UPDATE:
Returning to this after 4 hours, I reload the worksheet and there is no longer an SMF menu item.
Also, the version command yields the NAME error.
Both as it should be.
I install the addin and restart Excel.
All is working as it should. I have even been able to add the recalc button to the Ribbon.
Perhaps there is a delay in Excel before it unloads the add-in??? Whatever! At least it is working for now.
QUESTION:
When viewing the macros available to add the the ribbon or the toolbar, what are the differences between the following? I want to be able to update the stock quotes and other info on demand from a button. I am using ForceRecalculation. Is the best one for my needs?
ForceRecalculation
UpdateDownloadTable
UpdateStockDatabase
Thanks again!
Returning to this after 4 hours, I reload the worksheet and there is no longer an SMF menu item.
Also, the version command yields the NAME error.
Both as it should be.
I install the addin and restart Excel.
All is working as it should. I have even been able to add the recalc button to the Ribbon.
Perhaps there is a delay in Excel before it unloads the add-in??? Whatever! At least it is working for now.
QUESTION:
When viewing the macros available to add the the ribbon or the toolbar, what are the differences between the following? I want to be able to update the stock quotes and other info on demand from a button. I am using ForceRecalculation. Is the best one for my needs?
ForceRecalculation
UpdateDownloadTable
UpdateStockDatabase
Thanks again!
Wed Dec 6, 2017 10:37 am (PST) . Posted by:
"Randy Harmelink" rharmelink
I'm glad things are working now, as I had little advice to offer.
The UpdateStockDatabase is an old concept no longer in place. But both
smfForceRecalculation and smfUpdateDownloadTable are active. Check out the
"FAQs" page on the web site for various write-ups on them. I have plans to
add documentation for them, but currently there are just placeholders for
such documentation on the website. The documentation will probably consist
primarily of the write-ups on the FAQs page, with more detail.
For smfGetYahooPortfolioView(), only smfForceRecalculation is relevant.
On Wed, Dec 6, 2017 at 8:15 AM, harvey@
...
wrote:
>
> UPDATE:
> Returning to this after 4 hours, I reload the worksheet and there is no
> longer an SMF menu item.
> Also, the version command yields the NAME error.
> Both as it should be.
>
> I install the addin and restart Excel.
>
> All is working as it should. I have even been able to add the recalc
> button to the Ribbon.
>
> Perhaps there is a delay in Excel before it unloads the add-in???
> Whatever! At least it is working for now.
>
> QUESTION:
> When viewing the macros available to add the the ribbon or the toolbar,
> what are the differences between the following? I want to be able to update
> the stock quotes and other info on demand from a button. I am using
> ForceRecalculation. Is the best one for my needs?
>
> ForceRecalculation
> UpdateDownloadTable
> UpdateStockDatabase
>
>
The UpdateStockDatabase is an old concept no longer in place. But both
smfForceRecalculati
"FAQs" page on the web site for various write-ups on them. I have plans to
add documentation for them, but currently there are just placeholders for
such documentation on the website. The documentation will probably consist
primarily of the write-ups on the FAQs page, with more detail.
For smfGetYahooPortfoli
On Wed, Dec 6, 2017 at 8:15 AM, harvey@
...
wrote:
>
> UPDATE:
> Returning to this after 4 hours, I reload the worksheet and there is no
> longer an SMF menu item.
> Also, the version command yields the NAME error.
> Both as it should be.
>
> I install the addin and restart Excel.
>
> All is working as it should. I have even been able to add the recalc
> button to the Ribbon.
>
> Perhaps there is a delay in Excel before it unloads the add-in???
> Whatever! At least it is working for now.
>
> QUESTION:
> When viewing the macros available to add the the ribbon or the toolbar,
> what are the differences between the following? I want to be able to update
> the stock quotes and other info on demand from a button. I am using
> ForceRecalculation. Is the best one for my needs?
>
> ForceRecalculation
> UpdateDownloadTable
> UpdateStockDatabase
>
>
Wed Dec 6, 2017 10:40 am (PST) . Posted by:
"Randy Harmelink" rharmelink
That means you cannot access the source code of the URL. Most probably
cause is an old version of IE (or EXCEL)?
What happened when you tried the URL in the IE object within EXCEL?
On Wed, Dec 6, 2017 at 8:35 AM, lexstar@
...
wrote:
>
> I get an "ERROR" msg only.
>
cause is an old version of IE (or EXCEL)?
What happened when you tried the URL in the IE object within EXCEL?
On Wed, Dec 6, 2017 at 8:35 AM, lexstar@
...
wrote:
>
> I get an "ERROR" msg only.
>
Wed Dec 6, 2017 11:28 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Error on scripting is OK. Did any web page display after dismissing any
script errors?
On Wed, Dec 6, 2017 at 12:25 PM, lexstar@
...
wrote:
>
> I get an error script
>
>
>
script errors?
On Wed, Dec 6, 2017 at 12:25 PM, lexstar@
...
wrote:
>
> I get an error script
>
>
>
Wed Dec 6, 2017 12:18 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
I'm not sure there is much I'll be able to do. If the add-in can't access
the source code from that page, it's not going to be able to extract data
from it.
Did you see reasonable historical quotes on the web page in EXCEL's IE
object?
https://finance.yahoo.com/quote/MMM/history?period1=0&period2=1512518400&interval=1d&filter=history&frequency=1d
What version of IE do you have? What do you get with this in EXCEL's IE
object:
http://www.pinlady.net/PluginDetect/IE/
On Wed, Dec 6, 2017 at 12:41 PM, lexstar@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> Yes
>
the source code from that page, it's not going to be able to extract data
from it.
Did you see reasonable historical quotes on the web page in EXCEL's IE
object?
https://finance.yahoo.com/quote/MMM/history?period1=0&period2=1512518400&interval=1d&filter=history&frequency=1d
What version of IE do you have? What do you get with this in EXCEL's IE
object:
http://www.pinlady.net/PluginDetect/IE/
On Wed, Dec 6, 2017 at 12:41 PM, lexstar@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> Yes
>
Wed Dec 6, 2017 8:29 am (PST) . Posted by:
richmond0039
Randy, sorry for the delay in replying. I could not access my Yahoo groups for several days. I think I may have found the issue. On both PCs there is an add-in called Analysis ToolPak, but on the PC where the SMF context menu does not appear, there is also an add-in called Analysis TookPak - VBA. When I disabled this add-in, closed Excel and restarted it, the SMF context menu appeared. I'll see if it keeps working correctly and let you know. Thanks very much for working me through this issue.
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar