15 New Messages
Digest #2872
Messages
Sun Nov 24, 2013 4:25 am (PST) . Posted by:
jegorah
Hello,
Using the RCHGetElementNumber function, I can no longer retrieve any data from ADFN-A sources. They all just show 'Error' in the cells. Is there something I need to do to get this to work?
Much thanks,
Brian
Using the RCHGetElementNumber function, I can no longer retrieve any data from ADFN-A sources. They all just show 'Error&#
Much thanks,
Brian
Sun Nov 24, 2013 5:03 am (PST) . Posted by:
"Randy Harmelink" rharmelink
It's only been a topic of conversation for months (and will probably be
again in the near future)...
See:
http://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/24009
On Sun, Nov 24, 2013 at 5:25 AM, <jegorah@yahoo.com> wrote:
> Using the RCHGetElementNumber function, I can no longer retrieve any
> data from ADFN-A sources. They all just show 'Error' in the cells. Is
> there something I need to do to get this to work?
>
again in the near future)...
See:
http://groups.
On Sun, Nov 24, 2013 at 5:25 AM, <jegorah@yahoo.
> Using the RCHGetElementNumber function, I can no longer retrieve any
> data from ADFN-A sources. They all just show 'Error&#
> there something I need to do to get this to work?
>
Sun Nov 24, 2013 8:11 am (PST) . Posted by:
john.kalkanis
Hi Randy. I have been using the smf add-in successfully for several months. Today I installed the beta version 2.1.2013.10.17 from the work-in-progress file (copied all files in the SMF Add-In folder, replacing the old ones). After doing that the program stopped responding (did not retrieve any data). So I copied the old version back in the SMF Add-in folder (replacing the new ones).
However, even after doing that, the program is very unstable. Sometimes it retrieves data. Than, all of a sudden, after maybe changing the symbol for which I need data, it stops retrieving any data. Clicking on the smfForceRecalculation macro does nothing to help. Restarting excel nothing.
what can I do?
However, even after doing that, the program is very unstable. Sometimes it retrieves data. Than, all of a sudden, after maybe changing the symbol for which I need data, it stops retrieving any data. Clicking on the smfForceRecalculati
what can I do?
Sun Nov 24, 2013 9:02 am (PST) . Posted by:
subldo2003
I've experienced the same issue. all my spreadsheets come back with errors.
---In smf_addin@yahoogroups.com, <john.kalkanis@...> wrote:
Hi Randy. I have been using the smf add-in successfully for several months. Today I installed the beta version 2.1.2013.10.17 from the work-in-progress file (copied all files in the SMF Add-In folder, replacing the old ones). After doing that the program stopped responding (did not retrieve any data). So I copied the old version back in the SMF Add-in folder (replacing the new ones).
However, even after doing that, the program is very unstable. Sometimes it retrieves data. Than, all of a sudden, after maybe changing the symbol for which I need data, it stops retrieving any data. Clicking on the smfForceRecalculation macro does nothing to help. Restarting excel nothing.
what can I do?
---In smf_addin@yahoogrou
Hi Randy. I have been using the smf add-in successfully for several months. Today I installed the beta version 2.1.2013.10.
However, even after doing that, the program is very unstable. Sometimes it retrieves data. Than, all of a sudden, after maybe changing the symbol for which I need data, it stops retrieving any data. Clicking on the smfForceRecalculati
what can I do?
Sun Nov 24, 2013 9:15 am (PST) . Posted by:
"Randy Harmelink" rharmelink
When you replaced the files, had you exited EXCEL first?
For diagnostic purposes, try this:
1. Exit EXCEL
2. Restart EXCEL
3. In a new workbook, if these work, what do you get back?
=RCHGetElementNumber("MMM";,975)
=RCHGetElementNumber("Version")
=RCHGetTableCell("http://finance.yahoo.com/q/ks?s=MMM",1,">52-WEEK HIGH")
What version of EXCEL do you have?
When you open up an existing workbook, do the formulas look OK, or do they
have a computer path in front of the function?
Keep in mind that the issue *could* just be an unresponsive website. For
example, I've had workbooks just sit there when I was trying to get the
Zacks Rank, because their website was down. That means that EACH formula I
had getting a new web page from Zacks needed to "time out" before the
add-in could go on to the next function.
On Sun, Nov 24, 2013 at 9:11 AM, <john.kalkanis@yahoo.com> wrote:
> Hi Randy. I have been using the smf add-in successfully for several
> months. Today I installed the beta version 2.1.2013.10.17 from the
> work-in-progress file (copied all files in the SMF Add-In folder, replacing
> the old ones). After doing that the program stopped responding (did not
> retrieve any data). So I copied the old version back in the SMF Add-in
> folder (replacing the new ones).
>
> However, even after doing that, the program is very unstable. Sometimes it
> retrieves data. Than, all of a sudden, after maybe changing the symbol for
> which I need data, it stops retrieving any data. Clicking on the
> smfForceRecalculation macro does nothing to help. Restarting excel nothing.
>
> what can I do?
>
For diagnostic purposes, try this:
1. Exit EXCEL
2. Restart EXCEL
3. In a new workbook, if these work, what do you get back?
=RCHGetElementNumbe
=RCHGetElementNumbe
=RCHGetTableCell(
What version of EXCEL do you have?
When you open up an existing workbook, do the formulas look OK, or do they
have a computer path in front of the function?
Keep in mind that the issue *could* just be an unresponsive website. For
example, I've had workbooks just sit there when I was trying to get the
Zacks Rank, because their website was down. That means that EACH formula I
had getting a new web page from Zacks needed to "time out" before the
add-in could go on to the next function.
On Sun, Nov 24, 2013 at 9:11 AM, <john.kalkanis@
> Hi Randy. I have been using the smf add-in successfully for several
> months. Today I installed the beta version 2.1.2013.10.
> work-in-progress file (copied all files in the SMF Add-In folder, replacing
> the old ones). After doing that the program stopped responding (did not
> retrieve any data). So I copied the old version back in the SMF Add-in
> folder (replacing the new ones).
>
> However, even after doing that, the program is very unstable. Sometimes it
> retrieves data. Than, all of a sudden, after maybe changing the symbol for
> which I need data, it stops retrieving any data. Clicking on the
> smfForceRecalculati
>
> what can I do?
>
Sun Nov 24, 2013 9:45 am (PST) . Posted by:
john.kalkanis
My answers:
- I exited excel before installing the new add-in, as it did not allow me to copy the new files in the SMF Add-in directory
- These are the results of the 3 formula in a new workbook:
132.55
Stock Market Functions add-in, Version 2.1.2012.12.29 (C:\Programmi\SMF Add-In; 1)
132.55
- I have excel 2010 /windows xp
---In smf_addin@yahoogroups.com, <rharmelink@...> wrote:
When you replaced the files, had you exited EXCEL first?
For diagnostic purposes, try this:
Exit EXCEL
Restart EXCEL
In a new workbook, if these work, what do you get back?
=RCHGetElementNumber("MMM";,975)
=RCHGetElementNumber("Version")
=RCHGetTableCell("http://finance.yahoo.com/q/ks?s=MMM http://finance.yahoo.com/q/ks?s=MMM",1,">52-WEEK HIGH") What version of EXCEL do you have?
When you open up an existing workbook, do the formulas look OK, or do they have a computer path in front of the function?
Keep in mind that the issue *could* just be an unresponsive website. For example, I've had workbooks just sit there when I was trying to get the Zacks Rank, because their website was down. That means that EACH formula I had getting a new web page from Zacks needed to "time out" before the add-in could go on to the next function.
On Sun, Nov 24, 2013 at 9:11 AM, <john.kalkanis@... mailto:john.kalkanis@...> wrote:
Hi Randy. I have been using the smf add-in successfully for several months. Today I installed the beta version 2.1.2013.10.17 from the work-in-progress file (copied all files in the SMF Add-In folder, replacing the old ones). After doing that the program stopped responding (did not retrieve any data). So I copied the old version back in the SMF Add-in folder (replacing the new ones).
However, even after doing that, the program is very unstable. Sometimes it retrieves data. Than, all of a sudden, after maybe changing the symbol for which I need data, it stops retrieving any data. Clicking on the smfForceRecalculation macro does nothing to help. Restarting excel nothing.
what can I do?
- when I open an older workbook, it goes very slowly by eventually it seems to work. but if I copy part of it to a new workbook it doesn't work
- sometimes a new workbook would start working. but if I close it a re-open it it does not. very erratic.
- I exited excel before installing the new add-in, as it did not allow me to copy the new files in the SMF Add-in directory
- These are the results of the 3 formula in a new workbook:
132.55
Stock Market Functions add-in, Version 2.1.2012.12.
132.55
- I have excel 2010 /windows xp
---In smf_addin@yahoogrou
When you replaced the files, had you exited EXCEL first?
For diagnostic purposes, try this:
Exit EXCEL
Restart EXCEL
In a new workbook, if these work, what do you get back?
=RCHGetElementNumbe
=RCHGetElementNumbe
=RCHGetTableCell(
When you open up an existing workbook, do the formulas look OK, or do they have a computer path in front of the function?
Keep in mind that the issue *could* just be an unresponsive website. For example, I've had workbooks just sit there when I was trying to get the Zacks Rank, because their website was down. That means that EACH formula I had getting a new web page from Zacks needed to "time out" before the add-in could go on to the next function.
On Sun, Nov 24, 2013 at 9:11 AM, <john.kalkanis@
Hi Randy. I have been using the smf add-in successfully for several months. Today I installed the beta version 2.1.2013.10.
However, even after doing that, the program is very unstable. Sometimes it retrieves data. Than, all of a sudden, after maybe changing the symbol for which I need data, it stops retrieving any data. Clicking on the smfForceRecalculati
what can I do?
- when I open an older workbook, it goes very slowly by eventually it seems to work. but if I copy part of it to a new workbook it doesn't work
- sometimes a new workbook would start working. but if I close it a re-open it it does not. very erratic.
Sun Nov 24, 2013 9:59 am (PST) . Posted by:
"Randy Harmelink" rharmelink
According to those results, you're still running the old version of the
add-in...
The "erratic" behavior would be consistent with a web site being down.
EXCEL may not consistently be recalculating cells in the same order. So it
could run for a while, then hit the down web site, and then continue after
sitting for a while, and repeat.
What web sites are you retrieving data from?
For example, I just visited Zacks and got a "splash" notice about GMail.
I'm not sure how the add-in would handle that redirection for the "splash"
notice, and the only way to clear it is to visit the website with IE or the
EXCEL Web Query dialog, so the site's cookie can be updated with the fact
you've seen the notice.
On Sun, Nov 24, 2013 at 10:45 AM, <john.kalkanis@yahoo.com> wrote:
> My answers:
>
> - I exited excel before installing the new add-in, as it did not allow me
> to copy the new files in the SMF Add-in directory
>
> - These are the results of the 3 formula in a new workbook:
>
> 132.55
>
> Stock Market Functions add-in, Version 2.1.2012.12.29 (C:\Programmi\SMF
> Add-In; 1)
>
> 132.55
> - I have excel 2010 /windows xp
>
>
> ---In smf_addin@yahoogroups.com, <rharmelink@...> wrote:
>
> When you replaced the files, had you exited EXCEL first?
>
> For diagnostic purposes, try this:
>
> 1. Exit EXCEL
>
> 2. Restart EXCEL
>
> 3. In a new workbook, if these work, what do you get back?
>
> =RCHGetElementNumber("MMM";,975)
>
> =RCHGetElementNumber("Version")
>
> =RCHGetTableCell("http://finance.yahoo.com/q/ks?s=MMM",1,">52-WEEK
> HIGH")
>
> What version of EXCEL do you have?
>
> When you open up an existing workbook, do the formulas look OK, or do they
> have a computer path in front of the function?
>
> Keep in mind that the issue *could* just be an unresponsive website. For
> example, I've had workbooks just sit there when I was trying to get the
> Zacks Rank, because their website was down. That means that EACH formula I
> had getting a new web page from Zacks needed to "time out" before the
> add-in could go on to the next function.
>
> On Sun, Nov 24, 2013 at 9:11 AM, <john.kalkanis@...> wrote:
>
> Hi Randy. I have been using the smf add-in successfully for several
> months. Today I installed the beta version 2.1.2013.10.17 from the
> work-in-progress file (copied all files in the SMF Add-In folder, replacing
> the old ones). After doing that the program stopped responding (did not
> retrieve any data). So I copied the old version back in the SMF Add-in
> folder (replacing the new ones).
>
> However, even after doing that, the program is very unstable. Sometimes it
> retrieves data. Than, all of a sudden, after maybe changing the symbol for
> which I need data, it stops retrieving any data. Clicking on the
> smfForceRecalculation macro does nothing to help. Restarting excel nothing.
>
> what can I do?
>
>
> - when I open an older workbook, it goes very slowly by eventually it
> seems to work. but if I copy part of it to a new workbook it doesn't work
> - sometimes a new workbook would start working. but if I close it a
> re-open it it does not. very erratic.
>
add-in...
The "erratic" behavior would be consistent with a web site being down.
EXCEL may not consistently be recalculating cells in the same order. So it
could run for a while, then hit the down web site, and then continue after
sitting for a while, and repeat.
What web sites are you retrieving data from?
For example, I just visited Zacks and got a "splash" notice about GMail.
I'm not sure how the add-in would handle that redirection for the "splash"
notice, and the only way to clear it is to visit the website with IE or the
EXCEL Web Query dialog, so the site's cookie can be updated with the fact
you've seen the notice.
On Sun, Nov 24, 2013 at 10:45 AM, <john.kalkanis@
> My answers:
>
> - I exited excel before installing the new add-in, as it did not allow me
> to copy the new files in the SMF Add-in directory
>
> - These are the results of the 3 formula in a new workbook:
>
> 132.55
>
> Stock Market Functions add-in, Version 2.1.2012.12.
> Add-In; 1)
>
> 132.55
> - I have excel 2010 /windows xp
>
>
> ---In smf_addin@yahoogrou
>
> When you replaced the files, had you exited EXCEL first?
>
> For diagnostic purposes, try this:
>
> 1. Exit EXCEL
>
> 2. Restart EXCEL
>
> 3. In a new workbook, if these work, what do you get back?
>
> =RCHGetElementNumbe
>
> =RCHGetElementNumbe
>
> =RCHGetTableCell(
> HIGH")
>
> What version of EXCEL do you have?
>
> When you open up an existing workbook, do the formulas look OK, or do they
> have a computer path in front of the function?
>
> Keep in mind that the issue *could* just be an unresponsive website. For
> example, I've had workbooks just sit there when I was trying to get the
> Zacks Rank, because their website was down. That means that EACH formula I
> had getting a new web page from Zacks needed to "time out" before the
> add-in could go on to the next function.
>
> On Sun, Nov 24, 2013 at 9:11 AM, <john.kalkanis@
>
> Hi Randy. I have been using the smf add-in successfully for several
> months. Today I installed the beta version 2.1.2013.10.
> work-in-progress file (copied all files in the SMF Add-In folder, replacing
> the old ones). After doing that the program stopped responding (did not
> retrieve any data). So I copied the old version back in the SMF Add-in
> folder (replacing the new ones).
>
> However, even after doing that, the program is very unstable. Sometimes it
> retrieves data. Than, all of a sudden, after maybe changing the symbol for
> which I need data, it stops retrieving any data. Clicking on the
> smfForceRecalculati
>
> what can I do?
>
>
> - when I open an older workbook, it goes very slowly by eventually it
> seems to work. but if I copy part of it to a new workbook it doesn't work
> - sometimes a new workbook would start working. but if I close it a
> re-open it it does not. very erratic.
>
Sun Nov 24, 2013 10:03 am (PST) . Posted by:
"Randy Harmelink" rharmelink
You could try this process:
1. Go to add-in manager and uncheck the add-in
2. Exit EXCEL
3. Update the add-in files to the beta version
4. Restart EXCEL
5. Go to add-in manager and re-add the add-in
6. Exit EXCEL
7. Restart EXCEL
(6) and (7) are usually unnecessary, but I prefer to have it save the
correct settings before I start doing other things. (1) and (2) undo the
add-in and remove any pointers that might exist -- some, in the past, seem
to have had registry entries for it, and this appears to remove them.
1. Go to add-in manager and uncheck the add-in
2. Exit EXCEL
3. Update the add-in files to the beta version
4. Restart EXCEL
5. Go to add-in manager and re-add the add-in
6. Exit EXCEL
7. Restart EXCEL
(6) and (7) are usually unnecessary, but I prefer to have it save the
correct settings before I start doing other things. (1) and (2) undo the
add-in and remove any pointers that might exist -- some, in the past, seem
to have had registry entries for it, and this appears to remove them.
Sun Nov 24, 2013 10:23 am (PST) . Posted by:
john.kalkanis
for example right now I am having problems with these functions:
smfGetOptionStrikes
=RCHGetElementNumber($B11,4924)
RCHGetElementNumber($B11,992)
---In smf_addin@yahoogroups.com, <rharmelink@...> wrote:
According to those results, you're still running the old version of the add-in...
The "erratic" behavior would be consistent with a web site being down. EXCEL may not consistently be recalculating cells in the same order. So it could run for a while, then hit the down web site, and then continue after sitting for a while, and repeat.
What web sites are you retrieving data from?
For example, I just visited Zacks and got a "splash" notice about GMail. I'm not sure how the add-in would handle that redirection for the "splash" notice, and the only way to clear it is to visit the website with IE or the EXCEL Web Query dialog, so the site's cookie can be updated with the fact you've seen the notice.
On Sun, Nov 24, 2013 at 10:45 AM, <john.kalkanis@... mailto:john.kalkanis@...> wrote:
My answers:
- I exited excel before installing the new add-in, as it did not allow me to copy the new files in the SMF Add-in directory
- These are the results of the 3 formula in a new workbook:
132.55
Stock Market Functions add-in, Version 2.1.2012.12.29 (C:\Programmi\SMF Add-In; 1)
132.55
- I have excel 2010 /windows xp
---In smf_addin@yahoogroups.com mailto:smf_addin@yahoogroups.com, <rharmelink@...> wrote:
When you replaced the files, had you exited EXCEL first?
For diagnostic purposes, try this:
Exit EXCEL
Restart EXCEL
In a new workbook, if these work, what do you get back?
=RCHGetElementNumber("MMM";,975)
=RCHGetElementNumber("Version")
=RCHGetTableCell("http://finance.yahoo.com/q/ks?s=MMM http://finance.yahoo.com/q/ks?s=MMM",1,">52-WEEK HIGH") What version of EXCEL do you have?
When you open up an existing workbook, do the formulas look OK, or do they have a computer path in front of the function?
Keep in mind that the issue *could* just be an unresponsive website. For example, I've had workbooks just sit there when I was trying to get the Zacks Rank, because their website was down. That means that EACH formula I had getting a new web page from Zacks needed to "time out" before the add-in could go on to the next function.
On Sun, Nov 24, 2013 at 9:11 AM, <john.kalkanis@... mailto:john.kalkanis@...> wrote:
Hi Randy. I have been using the smf add-in successfully for several months. Today I installed the beta version 2.1.2013.10.17 from the work-in-progress file (copied all files in the SMF Add-In folder, replacing the old ones). After doing that the program stopped responding (did not retrieve any data). So I copied the old version back in the SMF Add-in folder (replacing the new ones).
However, even after doing that, the program is very unstable. Sometimes it retrieves data. Than, all of a sudden, after maybe changing the symbol for which I need data, it stops retrieving any data. Clicking on the smfForceRecalculation macro does nothing to help. Restarting excel nothing.
what can I do?
- when I open an older workbook, it goes very slowly by eventually it seems to work. but if I copy part of it to a new workbook it doesn't work
- sometimes a new workbook would start working. but if I close it a re-open it it does not. very erratic.
smfGetOptionStrikes
=RCHGetElementNumbe
RCHGetElementNumber
---In smf_addin@yahoogrou
According to those results, you're still running the old version of the add-in...
The "erratic" behavior would be consistent with a web site being down. EXCEL may not consistently be recalculating cells in the same order. So it could run for a while, then hit the down web site, and then continue after sitting for a while, and repeat.
What web sites are you retrieving data from?
For example, I just visited Zacks and got a "splash" notice about GMail. I'm not sure how the add-in would handle that redirection for the "splash" notice, and the only way to clear it is to visit the website with IE or the EXCEL Web Query dialog, so the site's cookie can be updated with the fact you've seen the notice.
On Sun, Nov 24, 2013 at 10:45 AM, <john.kalkanis@
My answers:
- I exited excel before installing the new add-in, as it did not allow me to copy the new files in the SMF Add-in directory
- These are the results of the 3 formula in a new workbook:
132.55
Stock Market Functions add-in, Version 2.1.2012.12.
132.55
- I have excel 2010 /windows xp
---In smf_addin@yahoogrou
When you replaced the files, had you exited EXCEL first?
For diagnostic purposes, try this:
Exit EXCEL
Restart EXCEL
In a new workbook, if these work, what do you get back?
=RCHGetElementNumbe
=RCHGetElementNumbe
=RCHGetTableCell(
When you open up an existing workbook, do the formulas look OK, or do they have a computer path in front of the function?
Keep in mind that the issue *could* just be an unresponsive website. For example, I've had workbooks just sit there when I was trying to get the Zacks Rank, because their website was down. That means that EACH formula I had getting a new web page from Zacks needed to "time out" before the add-in could go on to the next function.
On Sun, Nov 24, 2013 at 9:11 AM, <john.kalkanis@
Hi Randy. I have been using the smf add-in successfully for several months. Today I installed the beta version 2.1.2013.10.
However, even after doing that, the program is very unstable. Sometimes it retrieves data. Than, all of a sudden, after maybe changing the symbol for which I need data, it stops retrieving any data. Clicking on the smfForceRecalculati
what can I do?
- when I open an older workbook, it goes very slowly by eventually it seems to work. but if I copy part of it to a new workbook it doesn't work
- sometimes a new workbook would start working. but if I close it a re-open it it does not. very erratic.
Sun Nov 24, 2013 10:47 am (PST) . Posted by:
john.kalkanis
I tried but it did not help
---In smf_addin@yahoogroups.com, <rharmelink@...> wrote:
You could try this process:
Go to add-in manager and uncheck the add-in Exit EXCEL Update the add-in files to the beta version Restart EXCEL Go to add-in manager and re-add the add-in Exit EXCEL Restart EXCEL(6) and (7) are usually unnecessary, but I prefer to have it save the correct settings before I start doing other things. (1) and (2) undo the add-in and remove any pointers that might exist -- some, in the past, seem to have had registry entries for it, and this appears to remove them.
---In smf_addin@yahoogrou
You could try this process:
Go to add-in manager and uncheck the add-in Exit EXCEL Update the add-in files to the beta version Restart EXCEL Go to add-in manager and re-add the add-in Exit EXCEL Restart EXCEL(6) and (7) are usually unnecessary, but I prefer to have it save the correct settings before I start doing other things. (1) and (2) undo the add-in and remove any pointers that might exist -- some, in the past, seem to have had registry entries for it, and this appears to remove them.
Sun Nov 24, 2013 10:54 am (PST) . Posted by:
"Randy Harmelink" rharmelink
More details please. All three of those are working fine here, as:
=RCHGetElementNumber("MMM";,4924)
=RCHGetElementNumber("MMM";,992)
=smfGetOptionStrikes("MMM";,"12/21/2013")
On Sun, Nov 24, 2013 at 11:23 AM, <john.kalkanis@yahoo.com> wrote:
> for example right now I am having problems with these functions:
>
> smfGetOptionStrikes
>
> =RCHGetElementNumber($B11,4924)
>
> RCHGetElementNumber($B11,992)
>
=RCHGetElementNumbe
=RCHGetElementNumbe
=smfGetOptionStrike
On Sun, Nov 24, 2013 at 11:23 AM, <john.kalkanis@
> for example right now I am having problems with these functions:
>
> smfGetOptionStrikes
>
> =RCHGetElementNumbe
>
> RCHGetElementNumber
>
Sun Nov 24, 2013 9:25 am (PST) . Posted by:
drahmir
Randy,
I'm looking at a monthly moving average for each stock, as well as the recent high in the last x-months. Is there a better way to efficiently pull the data for each of these stocks with your add-in?
---In smf_addin@yahoogroups.com, <rharmelink@...> wrote:
Sound to me like you're using the wrong tool.
What are you doing with the data?
On Sat, Nov 23, 2013 at 10:05 PM, <missouri24@... mailto:missouri24@...> wrote:
I'm using RCHGetYahooHistory on a large number of tickers to retrieve a few months of data. Each of these retrievals individually takes about 5 seconds for me, so retrieving around 1,000 tickers takes over an hour. Currently I populate one ticker at a time with the RCHGetYahooHistory request. I was wondering if anyone had discovered a way with the add-in to have simultaneous Yahoo history requests running concurrently so that a person can pull, say, 10 or more histories at once rather than just 1 at a time?
I'm looking at a monthly moving average for each stock, as well as the recent high in the last x-months. Is there a better way to efficiently pull the data for each of these stocks with your add-in?
---In smf_addin@yahoogrou
Sound to me like you're using the wrong tool.
What are you doing with the data?
On Sat, Nov 23, 2013 at 10:05 PM, <missouri24@
I'm using RCHGetYahooHistory on a large number of tickers to retrieve a few months of data. Each of these retrievals individually takes about 5 seconds for me, so retrieving around 1,000 tickers takes over an hour. Currently I populate one ticker at a time with the RCHGetYahooHistory request. I was wondering if anyone had discovered a way with the add-in to have simultaneous Yahoo history requests running concurrently so that a person can pull, say, 10 or more histories at once rather than just 1 at a time?
Sun Nov 24, 2013 9:52 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Sounds like you should be using a screening tool. How about StockFetcher
or Portfolio123?
Do any of the FinViz fields (or screener) help? Check the LINKS area of the
group to see how you can retrieve a number of fields for a number of stocks
(or all stocks) with a single Internet access.
On Sun, Nov 24, 2013 at 10:25 AM, <missouri24@mail.com> wrote:
> I'm looking at a monthly moving average for each stock, as well as the
> recent high in the last x-months. Is there a better way to efficiently
> pull the data for each of these stocks with your add-in?
>
or Portfolio123?
Do any of the FinViz fields (or screener) help? Check the LINKS area of the
group to see how you can retrieve a number of fields for a number of stocks
(or all stocks) with a single Internet access.
On Sun, Nov 24, 2013 at 10:25 AM, <missouri24@mail.
> I'm looking at a monthly moving average for each stock, as well as the
> recent high in the last x-months. Is there a better way to efficiently
> pull the data for each of these stocks with your add-in?
>
Sun Nov 24, 2013 9:32 pm (PST) . Posted by:
"Ali Imran Naqvi" dillli_ka_baadshah
Hi Randy,
I am trying to extract the open high and low from the following link:
https://www.google.com/finance?q=500312
Can u please help?
--
Ali Imran Naqvi
9327016964
"Smooth sea never makes a skillful mariner"
I am trying to extract the open high and low from the following link:
https://www.
Can u please help?
--
Ali Imran Naqvi
9327016964
"Smooth sea never makes a skillful mariner"
Sun Nov 24, 2013 9:52 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Simplest form of RCHGetTableCell():
=RCHGetTableCell("https://www.google.com/finance?q=500312",1,">Open")
=RCHGetTableCell("https://www.google.com/finance?q=500312",1,">Range")
On Sun, Nov 24, 2013 at 10:21 PM, Ali Imran Naqvi <naqviimran@gmail.com>wrote:
>
> I am trying to extract the open high and low from the following link:
>
> https://www.google.com/finance?q=500312
>
> Can u please help?
>
>
=RCHGetTableCell(
=RCHGetTableCell(
On Sun, Nov 24, 2013 at 10:21 PM, Ali Imran Naqvi <naqviimran@gmail.
>
> I am trying to extract the open high and low from the following link:
>
> https://www.
>
> Can u please help?
>
>
Tidak ada komentar:
Posting Komentar