Selasa, 23 April 2013

[smf_addin] Digest Number 2593

5 New Messages

Digest #2593
1a
AIG Warrants by "navman92000" navman92000
1b
Re: AIG Warrants by "Randy Harmelink" rharmelink
2a
2b
Re: Call to ForceRecalculation by "Randy Harmelink" rharmelink

Messages

Mon Apr 22, 2013 1:36 pm (PDT) . Posted by:

"navman92000" navman92000

I own some AIG warrants, ticker AIG.WS according to E-Trade. I can't get quotes using the standard RCHGetYahooQuotes for that ticker symbol. Can anyone help me?

Mon Apr 22, 2013 1:37 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Try using the Yahoo ticker symbol: AIG-WT?

On Mon, Apr 22, 2013 at 12:26 PM, navman92000 <navman9@comcast.net> wrote:

> I own some AIG warrants, ticker AIG.WS according to E-Trade. I can't get
> quotes using the standard RCHGetYahooQuotes for that ticker symbol. Can
> anyone help me?
>

Mon Apr 22, 2013 1:46 pm (PDT) . Posted by:

"ssztaba" ssztaba

I'm getting good stock pricing updates using the smfForceRecalculation after having set up the add-in as a Reference Library.

My question now is about getting option pricing: while the stock prices update whenever I do the ForceRecalculation routine, the Option prices don't change.

For example, now at 4:40 pm my worksheet update of the IOC May $72.50 Call option shows a price of $ 6.50 which it has shown throughout the day. Yet Yahoo shows that this option closed at $ 7.51. The stock closed at $ 76.99 which is correctly shown in my update.

I'm using the smfGETOptionQuotes routine. The formulas were set up individually, -- not as an array -- but the stock requests were also set-up similarlly and they're working fine.

If there a different smfForceRecalculation routine that needs to be called to clear the web pages of options in order to get current prices ??

Thanks

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> 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@...> 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 ??
> >
>

Mon Apr 22, 2013 2:22 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

You probably need to change your Internet Options to make sure you get
fresh content every time a web page is accessed. See the LINKS area of the
Yahoo group. It's the other item related to smfForceRecalculation.

There is no advantage to doing the smfGetOptionQuotes() as an array-entered
function. It was just done that way to be consistent with how
RCHGetYahooQuotes() is used. But there can be a big advantage to doing
RCHGetYahooQuotes() as an array-entered function.

On Mon, Apr 22, 2013 at 1:46 PM, ssztaba <ssjurik@optonline.net> wrote:

> I'm getting good stock pricing updates using the smfForceRecalculation
> after having set up the add-in as a Reference Library.
>
> My question now is about getting option pricing: while the stock prices
> update whenever I do the ForceRecalculation routine, the Option prices
> don't change.
>
> For example, now at 4:40 pm my worksheet update of the IOC May $72.50
> Call option shows a price of $ 6.50 which it has shown throughout the day.
> Yet Yahoo shows that this option closed at $ 7.51. The stock closed at
> $ 76.99 which is correctly shown in my update.
>
> I'm using the smfGETOptionQuotes routine. The formulas were set up
> individually, -- not as an array -- but the stock requests were also set-up
> similarlly and they're working fine.
>
> If there a different smfForceRecalculation routine that needs to be called
> to clear the web pages of options in order to get current prices ??
>

Mon Apr 22, 2013 10:45 pm (PDT) . Posted by:

"sewuzy" sewuzy



Thanks Randy.

I was just thinking of that old book I read so many years ago, "How I Made $2,000,000 in the Stock Market", by Nicholas Darvas, while he was a cruise ship dance instructor back in the sixties when he had to wait a week or two before picking up a Barron's on a port call, and then going over all the stock data and focusing on those with large volume upticks ..... indicating insider buying on mergers / acquisitions / or large earnings gains. Of course quarterly volume data is not going to be enough, more like weekly for the last two months. Or better yet a moving average or MACD or whatever based on volume.

Just a thought.

Seth

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Personally, I don't see volume for a given date as being all that valuable.
> It would never occur to me to make a special function for it.
>
> You could look at the smfPricesBetween() function, which could give you the
> cumulative volume between two dates. For example:
>
> =smfPricesBetween("MMM",DATE(2013,4,1),DATE(2013,4,1),"09")
>
> And, of course, any or all of those parameters could be cell references.
>
> On Sat, Apr 20, 2013 at 10:44 AM, sewuzy <sewuzy@...> wrote:
>
> > I was hoping if there might be something simple like
> >
> > =smfVolumesByDates("Ticker&quot;,"Date")
> >
> > =smfVolumesByDates("MMM",Date_A)
> >
> > I would like to have several date headings (say 12 months ago, 9 months
> > ago, 6 months ago, 3 months ago, Today), over the volumes for such dates
> > for a column of Symbols.
> >
> > I am not that good with Excel formulas, and the problem I have with
> > RCHGetYahooHistory, is that I think have to parse each date into three
> > different cells (year cell, month cell, date cell), and then use string
> > arithmetic to recombine them.
> >
> > Maybe we just have to use RCHGetYahooHistory for this. If so I wonder if
> > there might be some available formula to directly pick up the date
> > specified by some column header?
> >
> > Another question would be if whether the Average Volume for a stock on a
> > particular date is somehow available somewhere. I think the Yahoo
> > elements Average Volume is only as of Last Date, not as of any historical
> > date.
> >
>

Tidak ada komentar:

Posting Komentar