[smf_addin] Digest Number 3188

EXCEL Stock Market Functions Add-in Group

6 Messages

Digest #3188

1a

Re: Date of 52-week High and Low by rjemery7

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

1d

Re: Date of 52-week High and Low by rjemery7

2a

Lower refresh frequency instead of =now() ? by ronaldutrecht

2b

Re: Lower refresh frequency instead of =now() ? by "Randy Harmelink" rharmelink

Messages

1a

Re: Date of 52-week High and Low

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?

Reply to sender . Reply to group . Reply via Web Post . All Messages (6) . Top ^

1b

Re: Date of 52-week High and Low

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?

Reply to sender . Reply to group . Reply via Web Post . All Messages (6) . Top ^

1c

Re: Date of 52-week High and Low

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?
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (6) . Top ^

1d

Re: Date of 52-week High and Low

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

rjemery7

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

Reply to sender . Reply to group . Reply via Web Post . All Messages (6) . Top ^

2a

Lower refresh frequency instead of =now() ?

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

Reply to sender . Reply to group . Reply via Web Post . All Messages (2) . Top ^

2b

Re: Lower refresh frequency instead of =now() ?

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?
>
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (2) . Top ^

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

Visit Your Group

• New Members 17

• Privacy • Unsubscribe • Terms of Use