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?
>
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?
"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?
"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?
>
=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:
Posting Komentar