Rabu, 24 September 2014

[smf_addin] Digest Number 3188

6 Messages

Digest #3188
1b
Re: Date of 52-week High and Low by "Kaloyan N. Kenov" isabella.ascione
1c
Re: Date of 52-week High and Low by "Randy Harmelink" rharmelink
2b

Messages

Tue Sep 23, 2014 4:14 am (PDT) . Posted by:

rjemery7

This seemingly perfectly constructed function returns nothing:

=SMFPricesBetween("A",DATE(2014,9,19),DATE(2013,9,19),"03")

The result is a blank cell. What's wrong?

Tue Sep 23, 2014 4:26 am (PDT) . Posted by:

"Kaloyan N. Kenov" isabella.ascione

Hi,

try to see if changing "A" to say "aapl" changes anything. Second, try
instead of having "A" to use say A1 where A1 is the cell containing the
ticker. Else, I do not know.

Best

On 23 Sep 2014, at 12:14, "rjemery@gmail.com [smf_addin]" <
smf_addin@yahoogroups.com> wrote:

This seemingly perfectly constructed function returns nothing:

=SMFPricesBetween("A",DATE(2014,9,19),DATE(2013,9,19),"03")

The result is a blank cell. What's wrong?

Tue Sep 23, 2014 7:59 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

The starting date is later than the ending date, so no data fit the date
range.

On Tue, Sep 23, 2014 at 4:14 AM, rjemery@... wrote:

>
> This seemingly perfectly constructed function returns nothing:
>
> =SMFPricesBetween("A",DATE(2014,9,19),DATE(2013,9,19),"03")
>
> The result is a blank cell. What's wrong?
>

Tue Sep 23, 2014 1:20 pm (PDT) . Posted by:

rjemery7

Yes, with that modification, it worked! Thank you.

Tue Sep 23, 2014 10:52 am (PDT) . Posted by:

ronaldutrecht

Hi,


Is it possible to reduce the frequency of the updating of the data like once per hour?
Is it also possible to do it manually maybe?


Thanks,


Ronald

Tue Sep 23, 2014 11:16 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

I would suggest using the smfForceRecalculation macro. Just assign it to a
button so that you can update things whenever you need. Info on the macro
can be found on the "Tips and FAQs" page on the web site.

On Tue, Sep 23, 2014 at 10:52 AM, r.kok@... wrote:

>
> Is it possible to reduce the frequency of the updating of the data like
> once per hour?
>
> Is it also possible to do it manually maybe?
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Posting Komentar