9 Messages
Digest #3193
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.
On this early Sunday morning, I am using:
=RCHGetYahooHistory
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",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.
>
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
>
> 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.
>
http://finance.yahoo.com/q/hp?s=^SP400+Historical+
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?
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?
>
=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")
And what should the resulting string state if one has the latest version?
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")
>
> And what should the resulting string state if one has the latest version?
>
2.1.2014.05.
On Sun, Sep 28, 2014 at 11:15 AM, rjemery@... wrote:
>
> =RCHGetElementNumbe
>
> 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")
>
> And what should the resulting string state if one has the latest
> version?
>
>
>
=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.
> was 2.1.2014.05.
>
> On Sun, Sep 28, 2014 at 11:15 AM, rjemery@... wrote:
>
>
> =RCHGetElementNumbe
>
> 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