4 Messages
Digest #4074
Messages
Wed Jun 28, 2017 9:24 pm (PDT) . Posted by:
for30sqn
I'm having trouble with the Yahoo History function still. My smf version number is 2.1.2017.05.03 which I think is current. I have a stock ticker at Cell A2 and coding ( =smfGetYahooHistory(A2,,,,,,,,"DHLC") ) array entered to Cells E3:H24 I am getting #VALUE! returned for each cell in the array. How do I correct the code to be array entered ? Your help appreciated. AJS
Wed Jun 28, 2017 10:03 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
You have your "DHLC" parameter in the wrong place. It should be:
=smfGetYahooHistory(A2,,,,"DHLC")
However, smfGetYahooHistory() is only in the beta versions of the add-in,
not 2017.05.03.
On Wed, Jun 28, 2017 at 9:24 PM, for30sqn@
...
wrote:
>
> I'm having trouble with the Yahoo History function still. My smf version
> number is 2.1.2017.05.03 which I think is current. I have a stock ticker
> at Cell A2 and coding ( =smfGetYahooHistory(A2,,,,,,,,"DHLC") ) array
> entered to Cells E3:H24 I am getting #VALUE! returned for each cell in the
> array. How do I correct the code to be array entered ? Your help
> appreciated. AJS
>
=smfGetYahooHistory
However, smfGetYahooHistory(
not 2017.05.03.
On Wed, Jun 28, 2017 at 9:24 PM, for30sqn@
...
wrote:
>
> I'm having trouble with the Yahoo History function still. My smf version
> number is 2.1.2017.05.
> at Cell A2 and coding ( =smfGetYahooHistory
> entered to Cells E3:H24 I am getting #VALUE! returned for each cell in the
> array. How do I correct the code to be array entered ? Your help
> appreciated. AJS
>
Thu Jun 29, 2017 12:37 pm (PDT) . Posted by:
for30sqn
Thanks Randy for your lightning quick reply last night. When I changed the code as you suggested, I started to get some positive results. This morning revealed continuing challenges.
When I open the file, the computer hangs up for close to 2 minutes and then the array displays what seems to be correct data. During this delay, Excel shows that it is "not responding".
This is the code for the array when the file is loaded
='C:\Users\Allen\Downloads\RCH_Stock_Market_Functions (1).xla'!smfGetYahooHistory(A2,,,,"DHLC")
I've checked to ensure the SMF Add-in files are correctly placed in the C:\SMF Add-in directory and when I clean up the code to show =smfGetYahooHistory(A2,,,,"DHLC") as you suggest - the array shows #NAME? in all cells. I appreciate all your help. AJS
---In smf_addin@yahoogroups.com, <rharmelink@...> wrote :
You have your "DHLC" parameter in the wrong place. It should be:
=smfGetYahooHistory(A2,,,,"DHLC")
However, smfGetYahooHistory() is only in the beta versions of the add-in, not 2017.05.03.
On Wed, Jun 28, 2017 at 9:24 PM, for30sqn@ ...
wrote:
I'm having trouble with the Yahoo History function still. My smf version number is 2.1.2017.05.03 which I think is current. I have a stock ticker at Cell A2 and coding ( =smfGetYahooHistory(A2,,,,,,,, "DHLC") ) array entered to Cells E3:H24 I am getting #VALUE! returned for each cell in the array. How do I correct the code to be array entered ? Your help appreciated. AJS
When I open the file, the computer hangs up for close to 2 minutes and then the array displays what seems to be correct data. During this delay, Excel shows that it is "not responding".
This is the code for the array when the file is loaded
='C:\Users\Allen\Downloads\RCH_Stock_Market_Functions (1).xla'!smfGetYahooHistory(A2,,,,"DHLC")
I've checked to ensure the SMF Add-in files are correctly placed in the C:\SMF Add-in directory and when I clean up the code to show =smfGetYahooHistory(A2,,,,"DHLC") as you suggest - the array shows #NAME? in all cells. I appreciate all your help. AJS
---In smf_addin@yahoogroups.com, <rharmelink@
You have your "DHLC" parameter in the wrong place. It should be:
=smfGetYahooHistory
However, smfGetYahooHistory(
On Wed, Jun 28, 2017 at 9:24 PM, for30sqn@ ...
wrote:
I'm having trouble with the Yahoo History function still. My smf version number is 2.1.2017.05.
Thu Jun 29, 2017 1:18 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
On Thu, Jun 29, 2017 at 12:37 PM, for30sqn@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
> Thanks Randy for your lightning quick reply last night. When I changed
> the code as you suggested, I started to get some positive results. This
> morning revealed continuing challenges.
>
> When I open the file, the computer hangs up for close to 2 minutes and
> then the array displays what seems to be correct data. During this
> delay, Excel shows that it is "not responding".
>
It's "not responding" because it is recalculating. I'm surprised it takes
that long if you just have the one formula.
This is the code for the array when the file is loaded
>
> =
>
> '
>
> C:\Users\Allen\Downloads\RCH_Stock_Market_Functions
> (1).xla'!smfGetYahooHistory(A2,,,,"DHLC";)
>
>
That means your add-in was located in that location of the add-in
(i.e."C:\Users\Allen\Downloads\RCH_Stock_Market_Functions (1).xla") when
you created and saved the workbook. EXCEL saves a hard-coded location to
the add-in when it saves the workbook. When it opens the workbook, it tags
the function invocation as an "unresolved link" and leaves the path in the
formula if it can't resolve the location.
You should be able to run the smfFixLinks macro. It removes all of those
unresolved links, leaving EXCEL to use the function from the current
location of the add-in specified within the add-in manager.
Then, when you save the workbook, it should save it with a hard-coded link
to THAT location, and you shouldn't get an unresolved link when you reopen
the workbook. Unless you move the add-in.
> I've checked to ensure the SMF Add-in files are correctly placed in the
> C:\SMF Add-in directory and when I clean up the code to show
> =smfGetYahooHistory(A2,,,,"DHLC") as you suggest - the array shows
> #NAME? in all cells. I appreciate all your help. AJS
>
#NAME? generally means the add-in is not active. Check the add-in manager
and make sure it is there and checked.
smf_addin@yahoogroups.com> wrote:
> Thanks Randy for your lightning quick reply last night. When I changed
> the code as you suggested, I started to get some positive results. This
> morning revealed continuing challenges.
>
> When I open the file, the computer hangs up for close to 2 minutes and
> then the array displays what seems to be correct data. During this
> delay, Excel shows that it is "not responding".
>
It's "not responding" because it is recalculating. I'm surprised it takes
that long if you just have the one formula.
This is the code for the array when the file is loaded
>
> =
>
> '
>
> C:\Users&#
> (1).xla'
>
>
That means your add-in was located in that location of the add-in
(i.e."C:\Users&#
you created and saved the workbook. EXCEL saves a hard-coded location to
the add-in when it saves the workbook. When it opens the workbook, it tags
the function invocation as an "unresolved link" and leaves the path in the
formula if it can't resolve the location.
You should be able to run the smfFixLinks macro. It removes all of those
unresolved links, leaving EXCEL to use the function from the current
location of the add-in specified within the add-in manager.
Then, when you save the workbook, it should save it with a hard-coded link
to THAT location, and you shouldn'
the workbook. Unless you move the add-in.
> I've checked to ensure the SMF Add-in files are correctly placed in the
> C:\SMF Add-in directory and when I clean up the code to show
> =smfGetYahooHistory
> #NAME? in all cells. I appreciate all your help. AJS
>
#NAME? generally means the add-in is not active. Check the add-in manager
and make sure it is there and checked.
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar