Kamis, 30 April 2015

[smf_addin] Digest Number 3394

6 Messages

Digest #3394

Messages

Wed Apr 29, 2015 5:38 pm (PDT) . Posted by:

jimmymc00

I was admiring the RCHGetYahooQuotes-Template at http://ogres-crypt.com/SMF
and was able to create a similar template within my Excel Stock Portfolio file. It works great, and cut the processing time by 80%. Fantastic!

Can the RCHGetElementNumber be set up this way and reduce the time it takes for processing? By the way, where is this formula drawing its data from? Thanks. Jim

-----Original Message-----
From: Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com>
To: smf_addin <smf_addin@yahoogroups.com>
Sent: Tue, Apr 28, 2015 8:07 pm
Subject: Re: [smf_addin] Latest version of smf is 2014?

The 2014 version was the last official release. There's a beta release on the "Works in Progress" web page, from March of this year.


However, the most likely cause of #NAME? errors is either you don't have the add-in installed, or the worksheet you're opening had the add-in located in a different location than you do. Try running the smfFixLinks macro to fix any unresolved links due to location errors.



On Tue, Apr 28, 2015 at 4:29 PM, freefaller6@yahoo.com [smf_addin] <smf_addin@yahoogroups.com> wrote:



Anyone know why on , http://ogres-crypt.com/SMF/, is says the latest version of the addin is for 2014? My spreadsheet isn't working - used it last month with no problem. Now ever cells says #NAME? Confused and in for a long night it seems.

Wed Apr 29, 2015 6:13 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

RCHGetYahooQuotes() grabs a CSV file from Yahoo based on all the parameters
sent. That's what makes it so fast -- all of the data can be retrieved with
one Internet access. The number of Internet accesses is the data retrieval
bottleneck.

However, since RCHGetElementNumber(), as well as most other add-in
functions, get their data by pulling it out of the source code of
individual web pages, the bottleneck can't be reduced. Five different
ticker symbols typically means at least five different web page retrievals.
More, depending on how the various data items are arranged on web pages.

So there would be no advantage even if you could array-enter the
RCHGetElementNumber() function.

The source of data for RCHGetElementNumber() data varies. That function is
basically just pulling up saved definitions that use other add-in
functions. The definitions of the elements can be retrieved easily. For
example:

=smfGetAParms(942)
=RCHGetElementNumber("Source", 942)
=RCHGetElementNumber("P-URL", 942)

The "sources" are also documented in the XLS document distributed in the
ZIP archive. I try to give each web page its own "Source" value. All of the
data items from a web page can be retrieved by a single Internet access,
because the add-in saves a copy of the web page before actually extracting
data from it. So if another data item comes from that web page, the add-in
goes to the saved copy of the web page instead of going back to the
Internet.

On Wed, Apr 29, 2015 at 5:38 PM, jmcatee133@aol.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> I was admiring the RCHGetYahooQuotes-Template at
> http://ogres-crypt.com/SMF
> and was able to create a similar template within my Excel Stock Portfolio
> file. It works great, and cut the processing time by 80%. Fantastic!
>
> Can the RCHGetElementNumber be set up this way and reduce the time it
> takes for processing? By the way, where is this formula drawing its data
> from? Thanks. Jim
>

Wed Apr 29, 2015 7:38 pm (PDT) . Posted by:

jimmymc00

Thanks Randy. Your detailed explanation accelerated my learning curve quite a bit. I found the XLS document with the sources and codes a bit earlier. What are the "Usage" codes in column C?

I also started playing with the Morning Star Stock - Template. Pretty neat! I'm still a little weak on evaluating stocks and this looks like it should help me. The values in the Current Evaluation section at the bottom of the template are coming back as Undefined (element nos. 14472 - 14492). I see that they are coming from MorningStarCV2 source. Does that suggest a problem with the source? More likely, I'm not set up right.

Thanks again. I hope you don't mind these newbie questions. Jim

-----Original Message-----
From: Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com>
To: smf_addin <smf_addin@yahoogroups.com>
Sent: Wed, Apr 29, 2015 9:13 pm
Subject: Re: [smf_addin] Latest version of smf is 2014?

RCHGetYahooQuotes() grabs a CSV file from Yahoo based on all the parameters sent. That's what makes it so fast -- all of the data can be retrieved with one Internet access. The number of Internet accesses is the data retrieval bottleneck.


However, since RCHGetElementNumber(), as well as most other add-in functions, get their data by pulling it out of the source code of individual web pages, the bottleneck can't be reduced. Five different ticker symbols typically means at least five different web page retrievals. More, depending on how the various data items are arranged on web pages.


So there would be no advantage even if you could array-enter the RCHGetElementNumber() function.


The source of data for RCHGetElementNumber() data varies. That function is basically just pulling up saved definitions that use other add-in functions. The definitions of the elements can be retrieved easily. For example:


=smfGetAParms(942)

=RCHGetElementNumber("Source", 942)
=RCHGetElementNumber("P-URL", 942)


The "sources" are also documented in the XLS document distributed in the ZIP archive. I try to give each web page its own "Source" value. All of the data items from a web page can be retrieved by a single Internet access, because the add-in saves a copy of the web page before actually extracting data from it. So if another data item comes from that web page, the add-in goes to the saved copy of the web page instead of going back to the Internet.











On Wed, Apr 29, 2015 at 5:38 PM, jmcatee133@aol.com [smf_addin] <smf_addin@yahoogroups.com> wrote:



I was admiring the RCHGetYahooQuotes-Template at http://ogres-crypt.com/SMF
and was able to create a similar template within my Excel Stock Portfolio file. It works great, and cut the processing time by 80%. Fantastic!

Can the RCHGetElementNumber be set up this way and reduce the time it takes for processing? By the way, where is this formula drawing its data from? Thanks. Jim





















Wed Apr 29, 2015 8:39 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Usage codes -- S=Stock, E=ETF, F=Mutual Fund. Elements don't apply to all
types of equities.

The MorningStar Current Valuation elements were some of the last ones I
added, so you would need the latest version of the smf-elements-4.txt
<http://ogres-crypt.com/SMF/Works-In-Progress/smf-elements-4.txt> file from
the "Works in Progress" web page on the web site. After replacing the file
in the add-in's folder on your machine, you'll either need to restart EXCEL
or run the smfForceRecalculation macro for the add-in to reload the element
definitions from those external files.

On Wed, Apr 29, 2015 at 7:38 PM, jmcatee133@aol.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> Thanks Randy. Your detailed explanation accelerated my learning curve
> quite a bit. I found the XLS document with the sources and codes a bit
> earlier. What are the "Usage" codes in column C?
>
> I also started playing with the Morning Star Stock - Template. Pretty
> neat! I'm still a little weak on evaluating stocks and this looks like it
> should help me. The values in the Current Evaluation section at the bottom
> of the template are coming back as Undefined (element nos. 14472 - 14492).
> I see that they are coming from MorningStarCV2 source. Does that suggest a
> problem with the source? More likely, I'm not set up right.
>

Wed Apr 29, 2015 8:21 pm (PDT) . Posted by:

mgbuck55

Hi Randy,
Today, out of the blue, I was unable to gather intra-day prices from Yahoo Finance. No problem downloading end of day prices. Wondering if the problem is at my end, or if Yahoo is having trouble. When I enter the base URL for intra-day price downloads - "download.finance.yahoo.com" in a browser I get a page not found error from Yahoo. My fear is Yahoo has changed something at their end that has broken the download code. I would certainly appreciate any thoughts or feedback you might offer.


Thanks,
Mike


Wed Apr 29, 2015 8:48 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

The "Download Data (Delayed)" from stock web pages still use that domain,
and still work. For example:

http://download.finance.yahoo.com/d/quotes.csv?s=MMM&f=sl1d1t1c1ohgv&e=.csv

I just tried a quick RCHGetYahooQuotes() function and was able to get the
latest closing price of a stock.

But, yes, the web address you cite below will give a "Page not Found"
error, because it doesn't exist. It's just the start of a downloading web
address.

Make sure your Internet Options are set to always get a fresh copy of a web
page. You may have something cached within the "Temporary Internet Files"
that was causing problems during the day?

On Wed, Apr 29, 2015 at 8:21 PM, mgbuck@comcast.net [smf_addin] <
smf_addin@yahoogroups.com> wrote:

> Today, out of the blue, I was unable to gather intra-day prices from
> Yahoo Finance. No problem downloading end of day prices. Wondering if the
> problem is at my end, or if Yahoo is having trouble. When I enter the base
> URL for intra-day price downloads - "download.finance.yahoo.com" in a
> browser I get a page not found error from Yahoo. My fear is Yahoo has
> changed something at their end that has broken the download code. I would
> certainly appreciate any thoughts or feedback you might offer.
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar