[smf_addin] Digest Number 3962

EXCEL Stock Market Functions Add-in Group

7 Messages

Digest #3962

1a

Re: =RCHGetHTMLTable(CONCATENATE( "http://finance.yahoo.com/q/hp?s=^ by gwlunceford

2a

Re: Option Calls by bob_15861586

3

13867 YahooIN by nicetime231

4a

Re: Can you do smfforcerecalculate on selection? by herbshack13

4b

Re: Can you do smfforcerecalculate on selection? by "Randy Harmelink" rharmelink

4c

Re: Can you do smfforcerecalculate on selection? by herbshack13

5a

Re: GetTableCell Question by sdwcyberdude

Messages

1a

Re: =RCHGetHTMLTable(CONCATENATE( "http://finance.yahoo.com/q/hp?s=^

Tue Apr 11, 2017 7:32 pm (PDT) . Posted by:

gwlunceford

I am actually using a spreadsheet built by someone else. I have been using it with this formula for a few years. I will work on revamping the formula as you suggested. Thanks for your assistance.


Regards,
Gary

Reply to sender . Reply to group . Reply via Web Post . All Messages (3) . Top ^

2a

Re: Option Calls

Wed Apr 12, 2017 6:31 am (PDT) . Posted by:

bob_15861586

Randy,

I am now using smfGetBarChartOptionQuote to get my option quotes and it is working well. Thank you for all your help.


Bob

Reply to sender . Reply to group . Reply via Web Post . All Messages (3) . Top ^

3

13867 YahooIN

Wed Apr 12, 2017 7:55 am (PDT) . Posted by:

nicetime231

13867 YahooIN "Industry Name"
Is now producing an error message, I think all the 13864 thru 13868 are blown out.


There are alternatives:
850 - Zacks
877 - Morningstar
2153 - IBD

Reply to sender . Reply to group . Reply via Web Post . All Messages (1) . Top ^

4a

Re: Can you do smfforcerecalculate on selection?

Wed Apr 12, 2017 9:45 am (PDT) . Posted by:

herbshack13

So, I have a situation where I need to run about 30k rch queries and after about 500-1000, the cache(?) fills up and I get errors.

If I save values and restart EXCEL, I can continue.


Two questions:

1. Is there a way to increase the cache limit
2. Is there a way to clear cache without restarting the program?


Thanks!

Reply to sender . Reply to group . Reply via Web Post . All Messages (11) . Top ^

4b

Re: Can you do smfforcerecalculate on selection?

Wed Apr 12, 2017 10:12 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

That's not the type of thing the add-in was designed for. It's an unfair
use of free sites, and would be too easy for web sites to design their web
pages so the add-in couldn't get any data.

In any case, you'd be best off using something like the
smfUpdateDownloadTable macro. It allows piecemeal updates.

On Wed, Apr 12, 2017 at 9:45 AM, therber2@
​...wrote:

>
> So, I have a situation where I need to run about 30k rch queries and after
> about 500-1000, the cache(?) fills up and I get errors.
>
> If I save values and restart EXCEL, I can continue.
>
> Two questions:
>
> 1. Is there a way to increase the cache limit
> 2. Is there a way to clear cache without restarting the program?
>
>
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (11) . Top ^

4c

Re: Can you do smfforcerecalculate on selection?

Wed Apr 12, 2017 4:49 pm (PDT) . Posted by:

herbshack13

Nice.

Ty Randy

Reply to sender . Reply to group . Reply via Web Post . All Messages (11) . Top ^

5a

Re: GetTableCell Question

Wed Apr 12, 2017 10:11 am (PDT) . Posted by:

sdwcyberdude

Paul,

If you make progress on that, could you please post it; I would also like to capture asset allocation, as well as doing a weighted average fixed income rating calc from that table.
Scott

Reply to sender . Reply to group . Reply via Web Post . All Messages (15) . Top ^

For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Visit Your Group

• New Members 9

• Privacy • Unsubscribe • Terms of Use