Jumat, 10 Juni 2016

[smf_addin] Digest Number 3726

6 Messages

Digest #3726

Messages

Thu Jun 9, 2016 9:26 am (PDT) . Posted by:

john_hoel

I want to retrieve the closing price quote as of the most recent market day prior to today, or if today is not a market day, the second most recent market day. I can do this with an arbitrary number of nested IF statements, but I would rather do something simpler and easier to maintain. Can you think of any way to do this?


Thu Jun 9, 2016 11:44 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

I don't see how that can be done. If today is a market day, but the market
hasn't opened yet, how would I tell it would be open later that day?

On the Yahoo quotes page, there is a "Prev Close" price. Would that fit
your needs?

On Thu, Jun 9, 2016 at 9:26 AM, john@nerva.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> I want to retrieve the closing price quote as of the most recent market
> day prior to today, or if today is not a market day, the second most recent
> market day. I can do this with an arbitrary number of nested IF statements,
> but I would rather do something simpler and easier to maintain. Can you
> think of any way to do this?
>

Thu Jun 9, 2016 11:52 am (PDT) . Posted by:

john_hoel

Good question.

"Prev Close" is exactly what I need. Can you tell me how to get it?

Thu Jun 9, 2016 11:57 am (PDT) . Posted by:

john_hoel

That is a very good question.

"Prev Close" is exactly what I want. How do I get it?

Thu Jun 9, 2016 12:35 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Try:

=smfGetTagContent("http://finance.yahoo.com/q?s=MMM","td",1,"Prev
Close:",,,,1)

On Thu, Jun 9, 2016 at 11:52 AM, john@nerva.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> "Prev Close" is exactly what I need. Can you tell me how to get it?
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar