[smf_addin] Digest Number 3344

EXCEL Stock Market Functions Add-in Group

3 Messages

Digest #3344

1a

Re: Finviz Heatmaps by bushpilote

2a

Date of Previous Close by rjemery7

2b

Re: Date of Previous Close by "Randy Harmelink" rharmelink

Messages

1a

Re: Finviz Heatmaps

Tue Mar 3, 2015 4:05 am (PST) . Posted by:

bushpilote

Thanks Randy.

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

2a

Date of Previous Close

Tue Mar 3, 2015 2:28 pm (PST) . Posted by:

rjemery7

RCHGetYahooQuotes("MMM", "D1") gets me the date of the last trade. How can I obtain the date of the previous close?

If the last trade was a Monday, then the Previous Close was probably the previous Friday!

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

2b

Re: Date of Previous Close

Tue Mar 3, 2015 3:51 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

During the trading day, you could pick it up from the historical quotes web
page, with either:

=RCHGetTableCell("http://finance.yahoo.com/q/hp?s=MMM",1,">Adj Close",,,,1)
=RCHGetYahooHistory("MMM",,,,,,,,"d",0)

On Tue, Mar 3, 2015 at 3:28 PM, rjemery@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> RCHGetYahooQuotes("MMM", "D1") gets me the date of the last trade. How
> can I obtain the date of the previous close?
>
> If the last trade was a Monday, then the Previous Close was probably the
> previous Friday!
>

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 32

• Privacy • Unsubscribe • Terms of Use