5 New Messages
Digest #2593
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?
>
On Mon, Apr 22, 2013 at 12:26 PM, navman92000 <navman9@comcast.
> 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 ??
> >
>
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 smfForceRecalculati
Thanks
--- In smf_addin@yahoogrou
>
> Your VBA project will need to set up the add-in as a reference library.
> Otherwise, it should be good to go.
>
> If RCHGetYahooQuotes(
> 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@
>
> > 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 smfForceRecalculati
> > 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 ??
>
fresh content every time a web page is accessed. See the LINKS area of the
Yahoo group. It's the other item related to smfForceRecalculati
There is no advantage to doing the smfGetOptionQuotes(
function. It was just done that way to be consistent with how
RCHGetYahooQuotes(
RCHGetYahooQuotes(
On Mon, Apr 22, 2013 at 1:46 PM, ssztaba <ssjurik@optonline.
> I'm getting good stock pricing updates using the smfForceRecalculati
> 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 smfForceRecalculati
> 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"
Just a thought.
Seth
--- In smf_addin@yahoogrou
>
> 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(
> cumulative volume between two dates. For example:
>
> =smfPricesBetween(
>
> And, of course, any or all of those parameters could be cell references.
>
> On Sat, Apr 20, 2013 at 10:44 AM, sewuzy <sewuzy@.
>
> > I was hoping if there might be something simple like
> >
> > =smfVolumesByDates(
> >
> > =smfVolumesByDates(
> >
> > 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