Kamis, 01 September 2016

[smf_addin] Digest Number 3787

2 Messages

Digest #3787
1b
Re: smfUpdateDownloadTable Issues by "Randy Harmelink" rharmelink

Messages

Wed Aug 31, 2016 12:44 pm (PDT) . Posted by:

norton1717

I have built a spreadsheet for downloading a manageable number of funds I follow (less than 50) using smfUpdateDownloadTable as the calculation overhead for using individual formulas was cumbersome. It was working well but I am now having random errors show up when I use the following formulas. All the element numbers seem to be working seamlessly.


RCHGetYahooQuotes("~~~~~","n")



RCHGetYahooQuotes("~~~~~","l1")



I tried using the 4811 code for the Fund Name but they all show up with Fund: at the beginning, for example


Fund: American Funds American Balanced F2



Also is there an element number for Closing Price? I searched the spreadsheet to no avail.


Thanks, as always for all the great work.


Wed Aug 31, 2016 3:40 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

In general, I would say never use RCHGetYahooQuotes() with
smfUpdateDownloadTable. It's just a waste of time. Your two columns to get
name and last closing price for 50 funds would take 100 Internet accesses.
You could get all 100 items with a single array-entered formula. Much
faster. That may also be why you get random errors -- you're doing 100
accesses to their database instead of one. That interface was a bit spotty
towards the end of last year. Maybe it still has the potential for issues
-- it may depend on which servers are used to fill the request.

There is no element number for closing price, because it can already be
gotten from RCHGetYahooQuotes(). If there was an element, that would be how
it would be defined anyway. But, again, the strength of RCHGetYahooQuotes()
is that you can get a number of data items on up to 200 stocks, all in one
Internet access. So relegating it to an element number would be very
inefficient.

All of the MorningStar mutual fund element need to be redefined. They are
currently using an old print page that will probably be obsoleted sooner or
later. I'm hesitant to do the remapping because it means accessing several
web pages per fund instead of one -- the print report was nice, because it
had everything in one spot.

On Wed, Aug 31, 2016 at 12:44 PM, rnorton@me.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

> I have built a spreadsheet for downloading a manageable number of funds I
> follow (less than 50) using smfUpdateDownloadTable as the calculation
> overhead for using individual formulas was cumbersome. It was working well
> but I am now having random errors show up when I use the following
> formulas. All the element numbers seem to be working seamlessly.
>
> RCHGetYahooQuotes("~~~~~","n")
>
> RCHGetYahooQuotes("~~~~~","l1")
>
> I tried using the 4811 code for the Fund Name but they all show up with
> Fund: at the beginning, for example
>
> Fund: American Funds American Balanced F2
>
> Also is there an element number for Closing Price? I searched the
> spreadsheet to no avail.
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar