15 Messages
Digest #4079
Messages
Mon Jul 3, 2017 12:25 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
What ticker symbol are you using?
Try exiting and restarting EXCEL and see if you still get blanks. Or try
running the smfForceRecalculation macro.
On Mon, Jul 3, 2017 at 12:15 PM, Leo Bueno Leo@
...
wrote:
>
> The good news: All the links now look good, i.e., the function bar shows,
> for example,
>
> =RCHGetYahooQuotes(A10,"n")
>
> for when I am trying to get the name of the ticker on cell A10 and
>
> =RCHGetYahooQuotes(A10,"l1")
>
> when I am trying to get the price.
>
> The bad news: the results are blank cells, nothing.
>
>
>
Try exiting and restarting EXCEL and see if you still get blanks. Or try
running the smfForceRecalculati
On Mon, Jul 3, 2017 at 12:15 PM, Leo Bueno Leo@
...
wrote:
>
> The good news: All the links now look good, i.e., the function bar shows,
> for example,
>
> =RCHGetYahooQuotes(
>
> for when I am trying to get the name of the ticker on cell A10 and
>
> =RCHGetYahooQuotes(
>
> when I am trying to get the price.
>
> The bad news: the results are blank cells, nothing.
>
>
>
Mon Jul 3, 2017 12:34 pm (PDT) . Posted by:
"Leo Bueno" leobueno
When I go into the Macro window, the macro does not show up; note gray "Run" button.
See picture, below.
[cid:image001.png@01D2F411.BF3AD150]
Actually, I can no longer see the smfFixLinks macro either.
[cid:image002.png@01D2F411.C8DF3B60]
=========
Leo Bueno
=========
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Monday, July 03, 2017 3:26 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] RE: Stock price data source other than Yahoo
What ticker symbol are you using?
Try exiting and restarting EXCEL and see if you still get blanks. Or try running the smfForceRecalculation macro.
On Mon, Jul 3, 2017 at 12:15 PM, Leo Bueno Leo@
...
wrote:
The good news: All the links now look good, i.e., the function bar shows, for example,
=RCHGetYahooQuotes(A10,"n")
for when I am trying to get the name of the ticker on cell A10 and
=RCHGetYahooQuotes(A10,"l1")
when I am trying to get the price.
The bad news: the results are blank cells, nothing.
See picture, below.
[cid:image001.png@01D2F411.BF3AD150]
Actually, I can no longer see the smfFixLinks macro either.
[cid:image002.png@01D2F411.C8DF3B60]
=========
Leo Bueno
=========
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Monday, July 03, 2017 3:26 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] RE: Stock price data source other than Yahoo
What ticker symbol are you using?
Try exiting and restarting EXCEL and see if you still get blanks. Or try running the smfForceRecalculati
On Mon, Jul 3, 2017 at 12:15 PM, Leo Bueno Leo@
...
wrote:
The good news: All the links now look good, i.e., the function bar shows, for example,
=RCHGetYahooQuotes(
for when I am trying to get the name of the ticker on cell A10 and
=RCHGetYahooQuotes(
when I am trying to get the price.
The bad news: the results are blank cells, nothing.
Mon Jul 3, 2017 12:36 pm (PDT) . Posted by:
"Leo Bueno" leobueno
Note the formula in B5, for example, looks correct, but still get #NAME?
[cid:image001.png@01D2F412.2368B8E0]
=========
Leo Bueno
=========
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Monday, July 03, 2017 3:26 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] RE: Stock price data source other than Yahoo
What ticker symbol are you using?
Try exiting and restarting EXCEL and see if you still get blanks. Or try running the smfForceRecalculati
On Mon, Jul 3, 2017 at 12:15 PM, Leo Bueno Leo@
...
wrote:
The good news: All the links now look good, i.e., the function bar shows, for example,
=RCHGetYahooQuotes(
for when I am trying to get the name of the ticker on cell A10 and
=RCHGetYahooQuotes(
when I am trying to get the price.
The bad news: the results are blank cells, nothing.
Mon Jul 3, 2017 1:03 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Based on the macros no longer existing and the #NAME? error, it sounds like
you no longer have the add-in installed and activated in EXCEL. Is the
add-in available and checked within the add-in manager?
Could you have the Microsoft security update issue, which prevents external
add-ins from being loaded at start-up? See:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/30568
I have two Windows 10 computers, and neither have ever had that issue. But
a number of people did when they first installed that security update last
year.
On Mon, Jul 3, 2017 at 12:36 PM, Leo Bueno Leo@
...
wrote:
>
>
> Note the formula in B5, for example, looks correct, but still get #NAME?
>
>
>
>
>
you no longer have the add-in installed and activated in EXCEL. Is the
add-in available and checked within the add-in manager?
Could you have the Microsoft security update issue, which prevents external
add-ins from being loaded at start-up? See:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/30568
I have two Windows 10 computers, and neither have ever had that issue. But
a number of people did when they first installed that security update last
year.
On Mon, Jul 3, 2017 at 12:36 PM, Leo Bueno Leo@
...
wrote:
>
>
> Note the formula in B5, for example, looks correct, but still get #NAME?
>
>
>
>
>
Mon Jul 3, 2017 1:51 pm (PDT) . Posted by:
"Leo Bueno" leobueno
Add in is installed. See
[cid:image002.png@01D2F41C.8D4A63D0]
=========
Leo Bueno
=========
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Monday, July 03, 2017 4:03 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] RE: Stock price data source other than Yahoo
Based on the macros no longer existing and the #NAME? error, it sounds like you no longer have the add-in installed and activated in EXCEL. Is the add-in available and checked within the add-in manager?
Could you have the Microsoft security update issue, which prevents external add-ins from being loaded at start-up? See:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/30568
I have two Windows 10 computers, and neither have ever had that issue. But a number of people did when they first installed that security update last year.
On Mon, Jul 3, 2017 at 12:36 PM, Leo Bueno Leo@
...
wrote:
Note the formula in B5, for example, looks correct, but still get #NAME?
[cid:image003.png@01D2F41C.8D4A63D0]
[cid:image002.png@01D2F41C.8D4A63D0]
=========
Leo Bueno
=========
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Monday, July 03, 2017 4:03 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] RE: Stock price data source other than Yahoo
Based on the macros no longer existing and the #NAME? error, it sounds like you no longer have the add-in installed and activated in EXCEL. Is the add-in available and checked within the add-in manager?
Could you have the Microsoft security update issue, which prevents external add-ins from being loaded at start-up? See:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/30568
I have two Windows 10 computers, and neither have ever had that issue. But a number of people did when they first installed that security update last year.
On Mon, Jul 3, 2017 at 12:36 PM, Leo Bueno Leo@
...
wrote:
Note the formula in B5, for example, looks correct, but still get #NAME?
[cid:image003.png@01D2F41C.8D4A63D0]
Mon Jul 3, 2017 2:39 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
What did the version check return?
What information does the green triangle on each cell give you?
On Mon, Jul 3, 2017 at 1:51 PM, Leo Bueno Leo@
...
wrote:
>
> Add in is installed. See
>
>
>
>
>
>
>
What information does the green triangle on each cell give you?
On Mon, Jul 3, 2017 at 1:51 PM, Leo Bueno Leo@
...
wrote:
>
> Add in is installed. See
>
>
>
>
>
>
>
Mon Jul 3, 2017 3:20 pm (PDT) . Posted by:
"Leo Bueno" leobueno
When I expand a green triangle and the exclamation mark in the diamond, I get:
Invalid name error
Help on this error
Show calculation steps . . .
Ignore Error
Edit formula bar
Error checking options . . .
The version check returns: #NAME? See below.
[cid:image003.png@01D2F426.F95DBBD0]
I checked to make sure the add in was installed; looks like it is.
[cid:image004.png@01D2F426.F95DBBD0]
=========
Leo Bueno
=========
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Monday, July 03, 2017 5:16 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] RE: Stock price data source other than Yahoo
What did the version check return?
What information does the green triangle on each cell give you?
On Mon, Jul 3, 2017 at 1:51 PM, Leo Bueno Leo@
...
wrote:
Add in is installed. See
[cid:image002.png@01D2F426.9B4D8890]
Invalid name error
Help on this error
Show calculation steps . . .
Ignore Error
Edit formula bar
Error checking options . . .
The version check returns: #NAME? See below.
[cid:image003.png@01D2F426.F95DBBD0]
I checked to make sure the add in was installed; looks like it is.
[cid:image004.png@01D2F426.F95DBBD0]
=========
Leo Bueno
=========
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Monday, July 03, 2017 5:16 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] RE: Stock price data source other than Yahoo
What did the version check return?
What information does the green triangle on each cell give you?
On Mon, Jul 3, 2017 at 1:51 PM, Leo Bueno Leo@
...
wrote:
Add in is installed. See
[cid:image002.png@01D2F426.9B4D8890]
Mon Jul 3, 2017 3:22 pm (PDT) . Posted by:
"Leo Bueno" leobueno
After expanding the green triangle and "editing in formula bar", I get:
[cid:image001.png@01D2F427.3FAD9C90]
=========
Leo Bueno
=========
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Monday, July 03, 2017 5:16 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] RE: Stock price data source other than Yahoo
What did the version check return?
What information does the green triangle on each cell give you?
On Mon, Jul 3, 2017 at 1:51 PM, Leo Bueno Leo@
...
wrote:
Add in is installed. See
[cid:image002.png@01D2F427.3FAD9C90]
[cid:image001.png@01D2F427.3FAD9C90]
=========
Leo Bueno
=========
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Monday, July 03, 2017 5:16 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] RE: Stock price data source other than Yahoo
What did the version check return?
What information does the green triangle on each cell give you?
On Mon, Jul 3, 2017 at 1:51 PM, Leo Bueno Leo@
...
wrote:
Add in is installed. See
[cid:image002.png@01D2F427.3FAD9C90]
Mon Jul 3, 2017 3:31 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
All of that indicates to me that add-in is not installed/activated, or at
least EXCEL is either not recognizing it or not loading it.
The only thing I can think to try is:
1. Go into the add-in manager and Uncheck the add-in.
2. Exit EXCEL
3. Restart EXCEL
4. Go into the add-in manager. The add-in should not be listed. Add the
add-in using the "Browse" button.
5. Exit EXCEL
6. Restart EXCEL.
7. Check the version again. Hopefully it will work now?
On Mon, Jul 3, 2017 at 3:05 PM, Leo Bueno Leo@
...
wrote:
>
> When I expand a green triangle and the exclamation mark in the diamond, I
> get:
>
>
>
> Invalid name error
>
> Help on this error
>
> Show calculation steps . . .
>
> Ignore Error
>
> Edit formula bar
>
> Error checking options . . .
>
>
>
> The version check returns: #NAME? See below.
>
>
>
>
>
>
>
> I checked to make sure the add in was installed; looks like it is.
>
>
>
least EXCEL is either not recognizing it or not loading it.
The only thing I can think to try is:
1. Go into the add-in manager and Uncheck the add-in.
2. Exit EXCEL
3. Restart EXCEL
4. Go into the add-in manager. The add-in should not be listed. Add the
add-in using the "Browse" button.
5. Exit EXCEL
6. Restart EXCEL.
7. Check the version again. Hopefully it will work now?
On Mon, Jul 3, 2017 at 3:05 PM, Leo Bueno Leo@
...
wrote:
>
> When I expand a green triangle and the exclamation mark in the diamond, I
> get:
>
>
>
> Invalid name error
>
> Help on this error
>
> Show calculation steps . . .
>
> Ignore Error
>
> Edit formula bar
>
> Error checking options . . .
>
>
>
> The version check returns: #NAME? See below.
>
>
>
>
>
>
>
> I checked to make sure the add in was installed; looks like it is.
>
>
>
Mon Jul 3, 2017 4:01 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
What did you do? Why are you getting results of the formula now? The green
triangle is gone now too.
Do you have recalculation set to manual?
On Mon, Jul 3, 2017 at 3:07 PM, Leo Bueno Leo@
...
wrote:
>
> After expanding the green triangle and "editing in formula bar", I get:
>
>
>
>
>
>
> *From:* smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
> *Sent:* Monday, July 03, 2017 5:16 PM
> *To:* smf_addin@yahoogroups.com
> *Subject:* Re: [smf_addin] RE: Stock price data source other than Yahoo
>
>
>
> What did the version check return?
>
>
>
> What information does the green triangle on each cell give you?
>
>
>
triangle is gone now too.
Do you have recalculation set to manual?
On Mon, Jul 3, 2017 at 3:07 PM, Leo Bueno Leo@
...
wrote:
>
> After expanding the green triangle and "editing in formula bar", I get:
>
>
>
>
>
>
> *From:* smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
> *Sent:* Monday, July 03, 2017 5:16 PM
> *To:* smf_addin@yahoogroups.com
> *Subject:* Re: [smf_addin] RE: Stock price data source other than Yahoo
>
>
>
> What did the version check return?
>
>
>
> What information does the green triangle on each cell give you?
>
>
>
Mon Jul 3, 2017 4:46 pm (PDT) . Posted by:
"Leo Bueno" leobueno
But when I tried it again, I got that name error and could not fix it by expanding the green triangle!
[cid:image001.png@01D2F427.ED1146C0]
=========
Leo Bueno
=========
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Monday, July 03, 2017 5:16 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] RE: Stock price data source other than Yahoo
What did the version check return?
What information does the green triangle on each cell give you?
On Mon, Jul 3, 2017 at 1:51 PM, Leo Bueno Leo@
...
wrote:
Add in is installed. See
[cid:image002.png@01D2F427.ED1146C0]
[cid:image001.png@01D2F427.ED1146C0]
=========
Leo Bueno
=========
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Monday, July 03, 2017 5:16 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] RE: Stock price data source other than Yahoo
What did the version check return?
What information does the green triangle on each cell give you?
On Mon, Jul 3, 2017 at 1:51 PM, Leo Bueno Leo@
...
wrote:
Add in is installed. See
[cid:image002.png@01D2F427.ED1146C0]
Mon Jul 3, 2017 6:43 pm (PDT) . Posted by:
"Leo Bueno" leobueno
1. Unchecked the add-in in the add-in menu.
2. Exited Excel.
3. Restart Excel.
4. Went back to add-in menu.
5. The add-in was still there, but unchecked.
6. Using the Browse tab, looked for the add-in in the SMF folder.
7. Added SMF after warning from Excel saying the file was already there.
8. Seems to be working now.
=========
Leo Bueno
=========
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Monday, July 03, 2017 6:32 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] RE: Stock price data source other than Yahoo
All of that indicates to me that add-in is not installed/activated, or at least EXCEL is either not recognizing it or not loading it.
The only thing I can think to try is:
1. Go into the add-in manager and Uncheck the add-in.
2. Exit EXCEL
3. Restart EXCEL
4. Go into the add-in manager. The add-in should not be listed. Add the add-in using the "Browse" button.
5. Exit EXCEL
6. Restart EXCEL.
7. Check the version again. Hopefully it will work now?
On Mon, Jul 3, 2017 at 3:05 PM, Leo Bueno Leo@
...
wrote:
When I expand a green triangle and the exclamation mark in the diamond, I get:
Invalid name error
Help on this error
Show calculation steps . . .
Ignore Error
Edit formula bar
Error checking options . . .
The version check returns: #NAME? See below.
[cid:image001.png@01D2F440.E1BAB680]
I checked to make sure the add in was installed; looks like it is.
2. Exited Excel.
3. Restart Excel.
4. Went back to add-in menu.
5. The add-in was still there, but unchecked.
6. Using the Browse tab, looked for the add-in in the SMF folder.
7. Added SMF after warning from Excel saying the file was already there.
8. Seems to be working now.
=========
Leo Bueno
=========
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Monday, July 03, 2017 6:32 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] RE: Stock price data source other than Yahoo
All of that indicates to me that add-in is not installed/activated, or at least EXCEL is either not recognizing it or not loading it.
The only thing I can think to try is:
1. Go into the add-in manager and Uncheck the add-in.
2. Exit EXCEL
3. Restart EXCEL
4. Go into the add-in manager. The add-in should not be listed. Add the add-in using the "Browse" button.
5. Exit EXCEL
6. Restart EXCEL.
7. Check the version again. Hopefully it will work now?
On Mon, Jul 3, 2017 at 3:05 PM, Leo Bueno Leo@
...
wrote:
When I expand a green triangle and the exclamation mark in the diamond, I get:
Invalid name error
Help on this error
Show calculation steps . . .
Ignore Error
Edit formula bar
Error checking options . . .
The version check returns: #NAME? See below.
[cid:image001.png@01D2F440.E1BAB680]
I checked to make sure the add in was installed; looks like it is.
Mon Jul 3, 2017 6:59 pm (PDT) . Posted by:
"Leo Bueno" leobueno
I made sure that all the links are now OK. Actually, changed them by hand.
For example, with ticker on A6:
=RCHGetYahooQuotes(A6,"n")
=RCHGetYahooQuotes(A6,"l1")
Problem: the cells now say #NAME?
=========
Leo Bueno
=========
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Monday, July 03, 2017 3:15 PM
To: smf_addin@yahoogroups.com
Subject: RE: [smf_addin] RE: Stock price data source other than Yahoo
The good news: All the links now look good, i.e., the function bar shows, for example,
=RCHGetYahooQuotes(A10,"n")
for when I am trying to get the name of the ticker on cell A10 and
=RCHGetYahooQuotes(A10,"l1")
when I am trying to get the price.
The bad news: the results are blank cells, nothing.
=========
Leo Bueno
=========
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Monday, July 03, 2017 2:57 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] RE: Stock price data source other than Yahoo
On Mon, Jul 3, 2017 at 11:15 AM, Leo Bueno Leo@
...
wrote:
How do I run the smfFixLinks macro?
Alt+F8 to bring up the macro dialog. Type in the name of the macro and then click on the "Run" button when it's available.
On Mon, Jul 3, 2017 at 11:22 AM, Leo Bueno Leo@
...
wrote:
When I go to File/Options/Quick Access Toolbar/ Macros I don't see any macros. Only a <Separator>.
That would seem to indicate you don't have the add-in installed and activated.
On Mon, Jul 3, 2017 at 11:28 AM, Leo Bueno Leo@
...
wrote:
I then went to File/Options/Trust Center/Trust Center Settings/ and clicked the radio button "Enable all macros . . .".
When I went back to File/Options/Quick Access Toolbar/ Macros, I stil did not see any macros.
Don't enable all macros. That can be dangerous.
On Mon, Jul 3, 2017 at 11:34 AM, Leo Bueno Leo@
...
wrote:
I ran the spreadsheet from another computer in the Windows home network (two PCs connected through a switch; files shared). Maybe that's what caused the insertion of the path.
I am currently using Excel 2010 and the latest version of the SMFAddIn.
Are you sure you installed and activated the add-in on both computers?
You can verify by checking the version:
=RCHGetElementNumber("Version")
For example, with ticker on A6:
=RCHGetYahooQuotes(A6,"n")
=RCHGetYahooQuotes(A6,"l1")
Problem: the cells now say #NAME?
=========
Leo Bueno
=========
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Monday, July 03, 2017 3:15 PM
To: smf_addin@yahoogroups.com
Subject: RE: [smf_addin] RE: Stock price data source other than Yahoo
The good news: All the links now look good, i.e., the function bar shows, for example,
=RCHGetYahooQuotes(A10,"n")
for when I am trying to get the name of the ticker on cell A10 and
=RCHGetYahooQuotes(A10,"l1")
when I am trying to get the price.
The bad news: the results are blank cells, nothing.
=========
Leo Bueno
=========
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Monday, July 03, 2017 2:57 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] RE: Stock price data source other than Yahoo
On Mon, Jul 3, 2017 at 11:15 AM, Leo Bueno Leo@
...
wrote:
How do I run the smfFixLinks macro?
Alt+F8 to bring up the macro dialog. Type in the name of the macro and then click on the "Run" button when it's available.
On Mon, Jul 3, 2017 at 11:22 AM, Leo Bueno Leo@
...
wrote:
When I go to File/Options/
That would seem to indicate you don't have the add-in installed and activated.
On Mon, Jul 3, 2017 at 11:28 AM, Leo Bueno Leo@
...
wrote:
I then went to File/Options/
When I went back to File/Options/
Don't enable all macros. That can be dangerous.
On Mon, Jul 3, 2017 at 11:34 AM, Leo Bueno Leo@
...
wrote:
I ran the spreadsheet from another computer in the Windows home network (two PCs connected through a switch; files shared). Maybe that's what caused the insertion of the path.
I am currently using Excel 2010 and the latest version of the SMFAddIn.
Are you sure you installed and activated the add-in on both computers?
You can verify by checking the version:
=RCHGetElementNumbe
Mon Jul 3, 2017 2:48 pm (PDT) . Posted by:
dfl10
A517 is stock symbol "MMC". I think you're right on their servers not keeping up. I'm issuing hundreds of Yahoo requests for multiple data items from multiple symbols. I'll try the array-entered formula.
Mon Jul 3, 2017 3:55 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
The array-entered formula should speed up (re)calculation significantly as
well, because the function only needs to go to the Internet once, for
hundreds of data items, rather than going to the Internet for each
individual data item.
Another thought -- the "Error" could be because those particular function
invocations are timing out.
Let me know how much your calculation time reduces. I'm curious.
On Mon, Jul 3, 2017 at 2:48 PM, dloewith@
...
wrote:
>
> A517 is stock symbol "MMC". I think you're right on their servers not
> keeping up. I'm issuing hundreds of Yahoo requests for multiple data items
> from multiple symbols. I'll try the array-entered formula.
>
well, because the function only needs to go to the Internet once, for
hundreds of data items, rather than going to the Internet for each
individual data item.
Another thought -- the "Error" could be because those particular function
invocations are timing out.
Let me know how much your calculation time reduces. I'm curious.
On Mon, Jul 3, 2017 at 2:48 PM, dloewith@
...
wrote:
>
> A517 is stock symbol "MMC"
> keeping up. I'm issuing hundreds of Yahoo requests for multiple data items
> from multiple symbols. I'll try the array-entered formula.
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar