Senin, 29 September 2014

[smf_addin] Digest Number 3193

9 Messages

Digest #3193
1a
Re: Adj Close by rjemery7
1b
Re: Adj Close by "Randy Harmelink" rharmelink
1c
Re: Adj Close by rjemery7
1d
Re: Adj Close by "Randy Harmelink" rharmelink
2b
Re: Latest Release and Documentation by "Randy Harmelink" rharmelink
2d
Re: Latest Release and Documentation by "Randy Harmelink" rharmelink
2e

Messages

Sun Sep 28, 2014 4:50 am (PDT) . Posted by:

rjemery7

Are there times of the night or weekends when data retrieval doesn't work?

On this early Sunday morning, I am using:

=RCHGetYahooHistory(A1,YEAR(A3),MONTH(A3),DAY(A3),YEAR(A3),MONTH(A3),DAY(A3),"d","OHLCVA",0)

which works when A1 is "IBM" but yields nothing when A1 is "^SP400".

FWIW, the function is retrieving a single day's data for the date stored in A3.

Sun Sep 28, 2014 8:07 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

SP400 is not a valid ticker symbol on Yahoo.

On Sun, Sep 28, 2014 at 4:50 AM, rjemery@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> Are there times of the night or weekends when data retrieval doesn't work?
>
> On this early Sunday morning, I am using:
>
>
> =RCHGetYahooHistory(A1,YEAR(A3),MONTH(A3),DAY(A3),YEAR(A3),MONTH(A3),DAY(A3),"d","OHLCVA&quot;,0)
>
> which works when A1 is "IBM" but yields nothing when A1 is "^SP400".
>
> FWIW, the function is retrieving a single day's data for the date stored
> in A3.
>

Sun Sep 28, 2014 11:13 am (PDT) . Posted by:

rjemery7

You misread me message. The symbol is ^SP400, it is quite valid, and no data is delivered.

Sun Sep 28, 2014 12:24 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Oops, sorry. Unfortunately, Yahoo carries no historical quotes on ^SP400:

http://finance.yahoo.com/q/hp?s=^SP400+Historical+Prices

On Sun, Sep 28, 2014 at 11:13 AM, rjemery@... wrote:

>
> You misread me message. The symbol is ^SP400, it is quite valid, and no
> data is delivered.
>

Sun Sep 28, 2014 5:25 am (PDT) . Posted by:

rjemery7

1) How can I verify that the version of the SMF add-in presently installed to my Excel 2007 package is the latest and greatest?

2) For documentation, rather than create PDFs for each function off the web, is there a single PDF file I could download that would include all the functions? If so, where and how do I access it?


Sun Sep 28, 2014 8:09 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

To find out which version you're using:

=RCHGetElementNumber("Version")

I don't have any PDF files of function documentation. They are in HTML
format. And I only have them function by function.

On Sun, Sep 28, 2014 at 5:25 AM, rjemery@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> 1) How can I verify that the version of the SMF add-in presently installed
> to my Excel 2007 package is the latest and greatest?
>
> 2) For documentation, rather than create PDFs for each function off the
> web, is there a single PDF file I could download that would include all the
> functions? If so, where and how do I access it?
>

Sun Sep 28, 2014 11:15 am (PDT) . Posted by:

rjemery7

=RCHGetElementNumber("Version&quot;)

And what should the resulting string state if one has the latest version?

Sun Sep 28, 2014 12:27 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

The last official release was 2.1.2014.01.30 and the last beta release was
2.1.2014.05.25.

On Sun, Sep 28, 2014 at 11:15 AM, rjemery@... wrote:

>
> =RCHGetElementNumber("Version&quot;)
>
> And what should the resulting string state if one has the latest version?
>

Sun Sep 28, 2014 1:52 pm (PDT) . Posted by:

"Craig Passow" passow

You could look up the most recent official release with a formula like this:

=RCHGetTableCell( "http://ogres-crypt.com/SMF/",1, "File
Name",,,,1,"</table",,,)

Add that (and the call below that reports the version you have) to
spreadsheets that use SMF Add-in code so you'll know when an update is
available. You could also write a formula that parses the release string
out of the result and compares it to the value reported by the call
below to produce a Boolean answer. The result could be used in a
conditional formatting formula to make it obvious when you need to
download an update (turn the top two rows of your spreadsheet red for
example).

On 9/28/2014 2:27 PM, Randy Harmelink rharmelink@gmail.com [smf_addin]
wrote:
> The last official release was 2.1.2014.01.30 and the last beta release
> was 2.1.2014.05.25.
>
> On Sun, Sep 28, 2014 at 11:15 AM, rjemery@... wrote:
>
>
> =RCHGetElementNumber("Version&quot;)
>
> And what should the resulting string state if one has the latest
> version?
>
>
>

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

Tidak ada komentar:

Posting Komentar