Sabtu, 11 Oktober 2014

[smf_addin] Digest Number 3205[1 Attachment]

6 Messages

Digest #3205

Messages

Fri Oct 10, 2014 5:34 am (PDT) . Posted by:

bushpilote

Thanks for responding to my email digsupply.

Re-downloaded and ran all four of your spreadsheets with the following results:
1. Dividends and earnings still show the same problem. I'll follow your suggestion and let you know what happens.
2. Candelstick worked like a charm.
3. Real time google same problem. However, when I stop the macro from executing "ActiveSheet.Shapes.Range(Array("Chart 1", "Scroll Bar 1", "Scroll Bar 2")).Align msoAlignRights, msoFalse", everything appears to be working fine.
Saved the changes in the same workbook name, reopened it and tested it on different tickers and got no error message.

Sat Oct 11, 2014 12:25 am (PDT) . Posted by:

digsupply

ZIP FILES FOR DIVIDENDS AND EARNINGS

Sat Oct 11, 2014 12:25 am (PDT) . Posted by:

digsupply




---In smf_addin@yahoogroups.com, <bushpilote@...> wrote :

Thanks for responding to my email digsupply.

Re-downloaded and ran all four of your spreadsheets with the following results:
1. Dividends and earnings still show the same problem. I'll follow your suggestion and let you know what happens.
2. Candelstick worked like a charm.
3. Real time google same problem. However, when I stop the macro from executing "ActiveSheet.Shapes.Range(Array("Chart 1", "Scroll Bar 1", "Scroll Bar 2")).Align msoAlignRights, msoFalse", everything appears to be working fine.
Saved the changes in the same workbook name, reopened it and tested it on different tickers and got no error message.



Attachment(s) from
1 of 1 File(s)

Fri Oct 10, 2014 10:27 am (PDT) . Posted by:

boothman11

I have been using SMF Add-In for years to keep track of the stocks I have previously passed on. I have an array currently set up with the capacity for 999 stock ticker symbols. This has never been an issue until just now. I installed the latest SMF Add-In on my new computer and received a message saying "Sorry, the Yahoo Finance system limits quotes to 200 ticker symbols at a time, and your request included 999ticker symbols. Please adjust your request to include 200 or less."


When I go to delete 799 of the lines, I get the message that I cannot adjust the array.


I set all of this up years ago and really do not want to have to re-learn about arrays. Why is there a limit now where there wasn't one before and how do I get around this without adjusting the array?

Fri Oct 10, 2014 10:35 am (PDT) . Posted by:

digsupply

https://xa.yimg.com/df/smf_addin/1000+input+tickers+with+RCHGetYahooQuotes+function-2.xlsm?token=M0skqBtGjYbHquZ_jBG2DFGXPCSC7ridiVWKgXPigg_ht59YhVExJtBm2fCiAaf6VL5cVnMHdupmPUyZvMLRysh1EZH2sDoZ622axNxzdrNcSCYav_r3Qk9SukOgvQUh-vgeN5dLk148w8jqNvPvLPJOYr6cnu0j2hHcM9mx0oyaDPpuICUXKVsNgB_NkmFyYsooujSGEEeuGcWfzAIEiPSCEz2gRZ5tL80ktgDBM6vE8FEF8SuXei1M2ebc&type=download https://xa.yimg.com/df/smf_addin/1000+input+tickers+with+RCHGetYahooQuotes+function-2.xlsm?token=M0skqBtGjYbHquZ_jBG2DFGXPCSC7ridiVWKgXPigg_ht59YhVExJtBm2fCiAaf6VL5cVnMHdupmPUyZvMLRysh1EZH2sDoZ622axNxzdrNcSCYav_r3Qk9SukOgvQUh-vgeN5dLk148w8jqNvPvLPJOYr6cnu0j2hHcM9mx0oyaDPpuICUXKVsNgB_NkmFyYsooujSGEEeuGcWfzAIEiPSCEz2gRZ5tL80ktgDBM6vE8FEF8SuXei1M2ebc&type=download

Fri Oct 10, 2014 1:51 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

The 200 ticker symbol limit is one imposed by Yahoo. It's been in place as
long as I can remember -- well over a decade. The only solution is to
delete your larger array-entered range and then array-enter the formula for
200 ticker symbols at a time.

You said you set it up for a capacity of 999 ticker symbols. That would
work fine until you actually use 201 ticker symbols of that capacity...

On Fri, Oct 10, 2014 at 10:27 AM, jbooth11@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

> I have been using SMF Add-In for years to keep track of the stocks I
> have previously passed on. I have an array currently set up with the
> capacity for 999 stock ticker symbols. This has never been an issue until
> just now. I installed the latest SMF Add-In on my new computer and
> received a message saying "Sorry, the Yahoo Finance system limits quotes to
> 200 ticker symbols at a time, and your request included 999ticker symbols.
> Please adjust your request to include 200 or less."
>
> When I go to delete 799 of the lines, I get the message that I cannot
> adjust the array.
>
> I set all of this up years ago and really do not want to have to re-learn
> about arrays. Why is there a limit now where there wasn't one before and
> how do I get around this without adjusting the array?
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Posting Komentar