6 Messages
Digest #4099
Messages
Sun Jul 23, 2017 8:38 pm (PDT) . Posted by:
for30sqn
I downloaded the beta file for yahoo history and verified it is installed properly showing the new version.
I'm using Windows 10 with Excel 2007 which worked fine to early May. Now when I attempt to array enter a formula, Excel locks up and I have to use the task manager to close the application. I'm trying to array enter Yahoo history for hi, low & close prices. The old formula used to do a stellar job
=RCHGetYahooHistory(A2,,,,,,,,"DHLC") What should the entry be now using the new beta file.
Your help much appreciated.
Allen
I'm using Windows 10 with Excel 2007 which worked fine to early May. Now when I attempt to array enter a formula, Excel locks up and I have to use the task manager to close the application. I'm trying to array enter Yahoo history for hi, low & close prices. The old formula used to do a stellar job
=RCHGetYahooHistory
Your help much appreciated.
Allen
Sun Jul 23, 2017 11:20 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
I just tried:
=RCHGetYahooHistory("MMM",,,,,,,,"DHLC")
...and got:
Date High Low Close
2017-07-21 $211.84 $209.48 $211.16
2017-07-20 $213.41 $212.06 $212.45
2017-07-19 $212.11 $211.17 $212.10
2017-07-18 $211.52 $210.30 $211.31
2017-07-17 $212.20 $210.59 $211.68
It takes longer than before the Yahoo changes, a second or two when it used
to take half a second.
Without being able to repeat the problem here so I can diagnose it, I'm not
sure what I can do to help?
If you restart EXCEL, what do you get in a new workbook with:
=RCHGetElementNumber("Version")
...and then try the above formula to see if you get anything with a freshly
opened EXCEL?
How much RAM do you have? Does the task manager indicate any activity when
EXCEL is locked up?
On Sun, Jul 23, 2017 at 8:38 PM, for30sqn@
...
wrote:
> I downloaded the beta file for yahoo history and verified it is installed
> properly showing the new version.
>
> I'm using Windows 10 with Excel 2007 which worked fine to early May. Now
> when I attempt to array enter a formula, Excel locks up and I have to use
> the task manager to close the application. I'm trying to array enter Yahoo
> history for hi, low & close prices. The old formula used to do a stellar
> job
>
> =
> RCHGetYahooHistory(A2,,,,,,,,"DHLC";) What should the entry be now using
> the new beta file.
>
> Your help much appreciated.
>
>
>
=RCHGetYahooHistory
...and got:
Date High Low Close
2017-07-21 $211.84 $209.48 $211.16
2017-07-20 $213.41 $212.06 $212.45
2017-07-19 $212.11 $211.17 $212.10
2017-07-18 $211.52 $210.30 $211.31
2017-07-17 $212.20 $210.59 $211.68
It takes longer than before the Yahoo changes, a second or two when it used
to take half a second.
Without being able to repeat the problem here so I can diagnose it, I'm not
sure what I can do to help?
If you restart EXCEL, what do you get in a new workbook with:
=RCHGetElementNumbe
...and then try the above formula to see if you get anything with a freshly
opened EXCEL?
How much RAM do you have? Does the task manager indicate any activity when
EXCEL is locked up?
On Sun, Jul 23, 2017 at 8:38 PM, for30sqn@
...
wrote:
> I downloaded the beta file for yahoo history and verified it is installed
> properly showing the new version.
>
> I'm using Windows 10 with Excel 2007 which worked fine to early May. Now
> when I attempt to array enter a formula, Excel locks up and I have to use
> the task manager to close the application. I'm trying to array enter Yahoo
> history for hi, low & close prices. The old formula used to do a stellar
> job
>
> =
> RCHGetYahooHistory(
> the new beta file.
>
> Your help much appreciated.
>
>
>
Mon Jul 24, 2017 1:26 am (PDT) . Posted by:
for30sqn
Thanks for your quick response Randy. First to answer your questions -
A new workbook opens and shows Stock Market Functions add-in, Version 2.1.2017.07.12 (C:\SMF Add-in; Windows (32-bit) NT 6.02; 12.0; ; ; 1) as the version installed.
I get rapid results with the formula you provided in the new workbook.
I have 6 MB RAM.
When Excel is locked up, the Task Manager shows that Microsoft Office Excel (32 bit) "Not Responding"
Most interesting is that when I use a workbook on file and change the formula, Excel hangs up for one minute and 25 seconds and then clears showing good data. If I save that file and reopen it, I loads and finally displays correct data after one minute 25 seconds.
Thanks to you I have enough info now to troubleshoot what the heck is going on. As a last resort, I may have to start from scratch to create a new master workbook for my chandelier stop calculations. But you have provided me great info for which I am most grateful. Thanks again. Allen
---In smf_addin@yahoogroups.com, <rharmelink@...> wrote :
I just tried:
=RCHGetYahooHistory("MMM",,,,,,,,"DHLC")
...and got:
Date High Low Close 2017-07-21 $211.84 $209.48 $211.16 2017-07-20 $213.41 $212.06 $212.45 2017-07-19 $212.11 $211.17 $212.10 2017-07-18 $211.52 $210.30 $211.31 2017-07-17 $212.20 $210.59 $211.68
It takes longer than before the Yahoo changes, a second or two when it used to take half a second.
Without being able to repeat the problem here so I can diagnose it, I'm not sure what I can do to help?
If you restart EXCEL, what do you get in a new workbook with:
=RCHGetElementNumber("Version")
...and then try the above formula to see if you get anything with a freshly opened EXCEL?
How much RAM do you have? Does the task manager indicate any activity when EXCEL is locked up?
On Sun, Jul 23, 2017 at 8:38 PM, for30sqn@ ...
wrote:
I downloaded the beta file for yahoo history and verified it is installed properly showing the new version.
I'm using Windows 10 with Excel 2007 which worked fine to early May. Now when I attempt to array enter a formula, Excel locks up and I have to use the task manager to close the application. I'm trying to array enter Yahoo history for hi, low & close prices. The old formula used to do a stellar job
=
RCHGetYahooHistory(A2,,,,,,,, "DHLC") What should the entry be now using the new beta file.
Your help much appreciated.
A new workbook opens and shows Stock Market Functions add-in, Version 2.1.2017.07.12 (C:\SMF Add-in; Windows (32-bit) NT 6.02; 12.0; ; ; 1) as the version installed.
I get rapid results with the formula you provided in the new workbook.
I have 6 MB RAM.
When Excel is locked up, the Task Manager shows that Microsoft Office Excel (32 bit) "Not Responding"
Most interesting is that when I use a workbook on file and change the formula, Excel hangs up for one minute and 25 seconds and then clears showing good data. If I save that file and reopen it, I loads and finally displays correct data after one minute 25 seconds.
Thanks to you I have enough info now to troubleshoot what the heck is going on. As a last resort, I may have to start from scratch to create a new master workbook for my chandelier stop calculations. But you have provided me great info for which I am most grateful. Thanks again. Allen
---In smf_addin@yahoogroups.com, <rharmelink@
I just tried:
=RCHGetYahooHistory
...and got:
Date High Low Close 2017-07-21 $211.84 $209.48 $211.16 2017-07-20 $213.41 $212.06 $212.45 2017-07-19 $212.11 $211.17 $212.10 2017-07-18 $211.52 $210.30 $211.31 2017-07-17 $212.20 $210.59 $211.68
It takes longer than before the Yahoo changes, a second or two when it used to take half a second.
Without being able to repeat the problem here so I can diagnose it, I'm not sure what I can do to help?
If you restart EXCEL, what do you get in a new workbook with:
=RCHGetElementNumbe
...and then try the above formula to see if you get anything with a freshly opened EXCEL?
How much RAM do you have? Does the task manager indicate any activity when EXCEL is locked up?
On Sun, Jul 23, 2017 at 8:38 PM, for30sqn@ ...
wrote:
I downloaded the beta file for yahoo history and verified it is installed properly showing the new version.
I'm using Windows 10 with Excel 2007 which worked fine to early May. Now when I attempt to array enter a formula, Excel locks up and I have to use the task manager to close the application. I'm trying to array enter Yahoo history for hi, low & close prices. The old formula used to do a stellar job
=
RCHGetYahooHistory(
Your help much appreciated.
Mon Jul 24, 2017 1:49 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
You can turn on logging, and then view the log (both available from the
context menu). That might give you some clues as to which web page
retrievals are taking so long.
I always have Asynchronous processing enabled (again, from context menu).
It may not necessarily speed up anything, but it does get rid of the "not
responding" message and may give you more of a clue as to what is going on.
85 seconds isn't out of line if you are doing a few dozen historical quote
requests?
I sometimes use the log to figure out how many web pages are being
retrieved and then try to reduce the number of retrievals.
On Mon, Jul 24, 2017 at 1:26 AM, for30sqn@
...
wrote:
> Thanks for your quick response Randy. First to answer your questions -
>
> A new workbook opens and shows Stock Market Functions add-in, Version
> 2.1.2017.07.12 (C:\SMF Add-in; Windows (32-bit) NT 6.02; 12.0; ; ; 1) as
> the version installed.
>
> I get rapid results with the formula you provided in the new workbook.
>
> I have 6 MB RAM.
>
> When Excel is locked up, the Task Manager shows that *Microsoft Office
> Excel (32 bit) "Not Responding"*
>
> Most interesting is that when I use a workbook on file and change the
> formula, Excel hangs up for one minute and 25 seconds and then clears
> showing good data. If I save that file and reopen it, I loads and
> finally displays correct data after one minute 25 seconds.
>
> Thanks to you I have enough info now to troubleshoot what the heck is
> going on. As a last resort, I may have to start from scratch to create a
> new master workbook for my chandelier stop calculations. But you have
> provided me great info for which I am most grateful. Thanks again. Allen
>
context menu). That might give you some clues as to which web page
retrievals are taking so long.
I always have Asynchronous processing enabled (again, from context menu).
It may not necessarily speed up anything, but it does get rid of the "not
responding" message and may give you more of a clue as to what is going on.
85 seconds isn't out of line if you are doing a few dozen historical quote
requests?
I sometimes use the log to figure out how many web pages are being
retrieved and then try to reduce the number of retrievals.
On Mon, Jul 24, 2017 at 1:26 AM, for30sqn@
...
wrote:
> Thanks for your quick response Randy. First to answer your questions -
>
> A new workbook opens and shows Stock Market Functions add-in, Version
> 2.1.2017.07.
> the version installed.
>
> I get rapid results with the formula you provided in the new workbook.
>
> I have 6 MB RAM.
>
> When Excel is locked up, the Task Manager shows that *Microsoft Office
> Excel (32 bit) "Not Responding"*
>
> Most interesting is that when I use a workbook on file and change the
> formula, Excel hangs up for one minute and 25 seconds and then clears
> showing good data. If I save that file and reopen it, I loads and
> finally displays correct data after one minute 25 seconds.
>
> Thanks to you I have enough info now to troubleshoot what the heck is
> going on. As a last resort, I may have to start from scratch to create a
> new master workbook for my chandelier stop calculations. But you have
> provided me great info for which I am most grateful. Thanks again. Allen
>
Mon Jul 24, 2017 1:37 pm (PDT) . Posted by:
for30sqn
Hi Randy,
Your suggestion to look at the log file reveals a Run-time error -
The smf version query on a new page shows the correct beta version.
The contents of the SMF Add-in directory shows
I'm unable to find, with a search, any file "smf-log.csv"
The Excel hang-up (unresponsive time) now is greater than 90 seconds for any input. The array I entered for Yahoo History was for a single stock, 4 columns for "DHLC" and 20 rows. I thought I was making progress, but there would seem to be something about my smf Add-in installation which is causing trouble. Any hints to solve the run-time error would be appreciated.
Allen
Your suggestion to look at the log file reveals a Run-time error -
The smf version query on a new page shows the correct beta version.
The contents of the SMF Add-in directory shows
I'm unable to find, with a search, any file "smf-log.
The Excel hang-up (unresponsive time) now is greater than 90 seconds for any input. The array I entered for Yahoo History was for a single stock, 4 columns for "DHLC" and 20 rows. I thought I was making progress, but there would seem to be something about my smf Add-in installation which is causing trouble. Any hints to solve the run-time error would be appreciated.
Allen
Mon Jul 24, 2017 3:12 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Did you enable logging first? It can only create/append to the log file if
you've enabled it. And it only appends new retrievals, so if you enter a
formula that uses an already accessed web page, it won't get logged.
I'd suggest restarting EXCEL and then enabling logging and asynchronous
processing (those are my defaults when EXCEL starts up). Then try a few
add-in functions and take a look at the log.
On Mon, Jul 24, 2017 at 1:37 PM, for30sqn@
...
wrote:
> Your suggestion to look at the log file reveals a Run-time error -
>
> The smf version query on a new page shows the correct beta version.
>
> The contents of the SMF Add-in directory shows
>
> I'm unable to find, with a search, any file "smf-log.csv"
>
> The Excel hang-up (unresponsive time) now is greater than 90 seconds for
> any input. The array I entered for Yahoo History was for a single stock, 4
> columns for "DHLC" and 20 rows. I thought I was making progress, but there
> would seem to be something about my smf Add-in installation which is
> causing trouble. Any hints to solve the run-time error would be
> appreciated.
>
>
>
you've enabled it. And it only appends new retrievals, so if you enter a
formula that uses an already accessed web page, it won't get logged.
I'd suggest restarting EXCEL and then enabling logging and asynchronous
processing (those are my defaults when EXCEL starts up). Then try a few
add-in functions and take a look at the log.
On Mon, Jul 24, 2017 at 1:37 PM, for30sqn@
...
wrote:
> Your suggestion to look at the log file reveals a Run-time error -
>
> The smf version query on a new page shows the correct beta version.
>
> The contents of the SMF Add-in directory shows
>
> I'm unable to find, with a search, any file "smf-log.
>
> The Excel hang-up (unresponsive time) now is greater than 90 seconds for
> any input. The array I entered for Yahoo History was for a single stock, 4
> columns for "DHLC" and 20 rows. I thought I was making progress, but there
> would seem to be something about my smf Add-in installation which is
> causing trouble. Any hints to solve the run-time error would be
> appreciated.
>
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar