4 Messages
Digest #4419
Messages
Sat Nov 10, 2018 7:02 am (PST) . Posted by:
"Steve Low" gordian
This problem continued on Thursday and Friday. Prior to the market's open, only 9 quotes in the array are retrieved. After the market opens, no problem.
It's now Saturday morning, and the entire array works properly.
I'm certain that this must a Yahoo issue, but I'm also mystified that others in this group haven't encountered it.
It will be interesting to see if the problem self-corrected or whether it recurs on Monday morning (or during the balance of the weekend)
It's now Saturday morning, and the entire array works properly.
I'm certain that this must a Yahoo issue, but I'm also mystified that others in this group haven't encountered it.
It will be interesting to see if the problem self-corrected or whether it recurs on Monday morning (or during the balance of the weekend)
Sat Nov 10, 2018 7:47 am (PST) . Posted by:
"Rhonda Federman" rhonda.federman@gmail.com
I had that problem too for the last few days. About 1/3 of my list
populated and the rest were dashes. I've cleared cache, rebooted. The
entire array fills in. Not sure if it was anything I did or if it just
fixed itself.
Rhonda Federman
(973) 992-2522
(201) 341-9123
rhonda.federman@gmail.com
populated and the rest were dashes. I've cleared cache, rebooted. The
entire array fills in. Not sure if it was anything I did or if it just
fixed itself.
Rhonda Federman
(973) 992-2522
(201) 341-9123
rhonda.federman@gmail.com
Sat Nov 10, 2018 3:05 pm (PST) . Posted by:
"Steve Low" gordian
I'm waiting til Monday to see if the problem solves. There is absolutely nothing on my end that changes between the problem appearing and then disappearing after the market opens.
On Saturday, November 10, 2018, 10:49:44 AM EST, Rhonda Federman rhonda..federman@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
I had that problem too for the last few days. About 1/3 of my list populated and the rest were dashes. I've cleared cache, rebooted. The entire array fills in. Not sure if it was anything I did or if it just fixed itself.
Rhonda Federman
(973) 992-2522
(201) 341-9123
rhonda.federman@gmail.com
On Saturday, November 10, 2018, 10:49:44 AM EST, Rhonda Federman rhonda..federman@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
I had that problem too for the last few days. About 1/3 of my list populated and the rest were dashes. I've cleared cache, rebooted. The entire array fills in. Not sure if it was anything I did or if it just fixed itself.
Rhonda Federman
(973) 992-2522
(201) 341-9123
rhonda.federman@gmail.com
Sun Nov 11, 2018 5:24 am (PST) . Posted by:
"Darryl Bonfessuto"
Randy,
Is the add-in compatibles in excel 2019?
Darryl
From: smf_addin@yahoogroups.com <smf_addin@yahoogroups.com>
Sent: Friday, November 09, 2018 2:23 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Can't make SMF work for me any more
If the "Version" function is working properly, it sound like the add-in installed OK.
However, the message you're getting sounds like a workbook is being opened from when you had the add-in in a different location. When a workbook is saved, EXCEL saves a hard-coded link to the location of the add-in. When the workbook is opened, if EXCEL doesn't find the add-in in that saved location for a formula, it tags that formula as having an unresolved link. That formula won't work until the unresolved link is fixed.
In most cases, running the smfFixLinks macro from the add-in will fix such unresolved links. Then, when saved, it will save the new location as the hard-coded location of the add-in, so you shouldn't have the problem the next time that workbook is opened.
As far as getting current prices, try the smfGetYahooPortfolioView() template. However, if you have the add-in in a non-standard location, it will have similar unresolved links, as that template has a hard-code location of the add-in based on where I have it located. But, again, it should be easily fixed with the smfFixLinks macro.
On Fri, Nov 9, 2018 at 11:53 AM 'The Kuffels' kuffel@... wrote:
Sorry I can't solve this on my own.. Asked before but still can't get current price.
Situation:
Used SMF for many years with no problem.
With the 2018.01.24 version I'm lost.
Have scrubbed C:\SMF Add-In several times and reloaded 2018.01.24.zip and installed onto Excel. On a new spreadsheet the "Version" test works but two problems remain. On entering Excel immediately get the message box: C:\SMF Add-In\RCH_Stock_Market_Functions-2.1.2017.11.08\RCH._Stock_Market_Functions.xla could not be found. This of course is the prior link but the Edit - Links points to the new one.
The other problem is I can no longer find a way to get the current price.
Guess I need an answer in words of one syllable.
Is the add-in compatibles in excel 2019?
Darryl
From: smf_addin@yahoogroups.com <smf_addin@yahoogroups.com>
Sent: Friday, November 09, 2018 2:23 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Can't make SMF work for me any more
If the "Version" function is working properly, it sound like the add-in installed OK.
However, the message you're getting sounds like a workbook is being opened from when you had the add-in in a different location. When a workbook is saved, EXCEL saves a hard-coded link to the location of the add-in. When the workbook is opened, if EXCEL doesn't find the add-in in that saved location for a formula, it tags that formula as having an unresolved link. That formula won't work until the unresolved link is fixed.
In most cases, running the smfFixLinks macro from the add-in will fix such unresolved links. Then, when saved, it will save the new location as the hard-coded location of the add-in, so you shouldn'
As far as getting current prices, try the smfGetYahooPortfoli
On Fri, Nov 9, 2018 at 11:53 AM 'The Kuffels' kuffel@... wrote:
Sorry I can't solve this on my own.. Asked before but still can't get current price.
Situation:
Used SMF for many years with no problem.
With the 2018.01.24 version I'm lost.
Have scrubbed C:\SMF Add-In several times and reloaded 2018.01.24.zip and installed onto Excel. On a new spreadsheet the "Version" test works but two problems remain. On entering Excel immediately get the message box: C:\SMF Add-In\RCH_
The other problem is I can no longer find a way to get the current price.
Guess I need an answer in words of one syllable.
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar