4 New Messages

Digest #2592

Call to ForceRecalculation by "ssztaba" ssztaba

Re: Call to ForceRecalculation by "Randy Harmelink" rharmelink

#25 MSN Last Price provides the previous close not the last close. by "roesterling" roesterling

Re: #25 MSN Last Price provides the previous close not the last clos by "Randy Harmelink" rharmelink

Messages

1a

I'm using the smf functions of RCHGetYahooQuotes, and smfGetOptionQuotes to get stock and option prices on about 100+ individual stocks and their options with varying expiration dates.

I'm planning on using a VBA button to ForceRecalculation prior to getting the data. Is a VBA 'Call smfForceRecalculation' sufficient or should I do anything additional ??

In the code for the button I'll also to turn ScreenUpdating to False until all the prices are gotten. Any other suggestions ??

Thanks

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

1b

Re: Call to ForceRecalculation

Sun Apr 21, 2013 6:58 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Your VBA project will need to set up the add-in as a reference library.
Otherwise, it should be good to go.

If RCHGetYahooQuotes() and smfGetOptionQuotes() are both done as two
array-entered functions, I don't think something like screenupdating will
make much of a difference. There would just be two screen updates.

On Sun, Apr 21, 2013 at 5:32 AM, ssztaba <ssjurik@optonline.net> wrote:

> I'm using the smf functions of RCHGetYahooQuotes, and smfGetOptionQuotes
> to get stock and option prices on about 100+ individual stocks and their
> options with varying expiration dates.
>
> I'm planning on using a VBA button to ForceRecalculation prior to getting
> the data. Is a VBA 'Call smfForceRecalculation' sufficient or should I do
> anything additional ??
>
> In the code for the button I'll also to turn ScreenUpdating to False until
> all the prices are gotten. Any other suggestions ??
>

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

2a

#25 MSN Last Price provides the previous close not the last close.

Sun Apr 21, 2013 8:16 pm (PDT) . Posted by:

"roesterling" roesterling

Reference: RCHGetElementNumber() Element Definitions as of 2012-02-12

#25 MSN Last Price

I have verified that this data element returns the previous close and not the last close.
Currently it provides the last close price for Thursday 4-18-2013 and not for Friday 4-19-2013.

I have not been able to find another data element to use for last close.
Do you have a suggestion or alternative to using RCHGetElementNumber(Symbol cell, 25)?

Thank you for your time and consideration.
Roger Oesterling

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

2b

Re: #25 MSN Last Price provides the previous close not the last clos

Sun Apr 21, 2013 8:41 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Yep. Ever since MSN redesigned their print page last year, they've been
defining "Last Price" as the previous day's closing price.

For current quotes, I'd suggest using the RCHGetYahooQuotes() function. It
can get multiple data items on up to 200 different stocks with a single
Internet request, so it can be much quicker than doing it one web page at a
time with RCHGetElementNumber() or RCHGetTableCell().

On Sun, Apr 21, 2013 at 8:00 PM, roesterling <roesterling@tampabay.rr.com>wrote:

> Reference: RCHGetElementNumber() Element Definitions as of 2012-02-12
>
> #25 MSN Last Price
>
> I have verified that this data element returns the previous close and not
> the last close.
> Currently it provides the last close price for Thursday 4-18-2013 and not
> for Friday 4-19-2013.
>
> I have not been able to find another data element to use for last close.
> Do you have a suggestion or alternative to using
> RCHGetElementNumber(Symbol cell, 25)?
>