Sabtu, 30 Juli 2011

[smf_addin] Digest Number 1902[2 Attachments]

Messages In This Digest (14 Messages)

Messages

1a.

Get Underlying Price From Same (non-yahoo) Source As Options Prices

Posted by: "bs2167" bs2167@yahoo.com   bs2167

Fri Jul 29, 2011 10:39 am (PDT)



Hello,

I am currently using the add-in to pull in prices for weekly options. Unfortunately, Yahoo does not list next week's weekly options (e.g. there are no 8/5/2011 expiry prices for SPY options as of today)...meanwhile Google, MSN, etc. do have prices for the 8/5/2011 expiration. The issue I am coming across is that when I try to use the smfgetoptionquotes() to pull the last price for the underlying using "u" for one of the other data sources (e.g. "G","MSN","MW"), I am getting an error that says "Unrecognized item ID: U".

Is it possible to retrieve the underlying stock's last trade price that is "synced" with the option prices from the same source? I am wary of using the last underlying price from Yahoo and pairing it with option quotes from a different source since if the prices are not synced it can throw implied vol calcs and the like. As always, appreciate any advice...the addin has been incredibly useful to me in a multitude of ways.

Thanks

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)
1b.

Re: Get Underlying Price From Same (non-yahoo) Source As Options Pri

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Fri Jul 29, 2011 2:08 pm (PDT)



The "u" should be working for all data sources. However, you do need the
beta version of the add-in from the "Works in Progress" folder for it to
work. What version of the add-in are you running?

=RCHGetElementNumber("Version")

On Fri, Jul 29, 2011 at 10:39 AM, bs2167 <bs2167@yahoo.com> wrote:

>
> I am currently using the add-in to pull in prices for weekly options.
> Unfortunately, Yahoo does not list next week's weekly options (e.g. there
> are no 8/5/2011 expiry prices for SPY options as of today)...meanwhile
> Google, MSN, etc. do have prices for the 8/5/2011 expiration. The issue I
> am coming across is that when I try to use the smfgetoptionquotes() to pull
> the last price for the underlying using "u" for one of the other data
> sources (e.g. "G","MSN","MW"), I am getting an error that says "Unrecognized
> item ID: U".
>
> Is it possible to retrieve the underlying stock's last trade price that is
> "synced" with the option prices from the same source? I am wary of using
> the last underlying price from Yahoo and pairing it with option quotes from
> a different source since if the prices are not synced it can throw implied
> vol calcs and the like. As always, appreciate any advice...the addin has
> been incredibly useful to me in a multitude of ways.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)
1c.

Re: Get Underlying Price From Same (non-yahoo) Source As Options Pri

Posted by: "bs2167" bs2167@yahoo.com   bs2167

Fri Jul 29, 2011 2:34 pm (PDT)



That must be it...I'm using 2.1.2010.08.02. Thanks Randy, I will give it a try.

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)
2a.

Full security name

Posted by: "mike_sobieski" mike_sobieski@yahoo.com   mike_sobieski

Fri Jul 29, 2011 11:23 am (PDT)



I've been using this functionality for a while and have recently run into a snag with retrieving the full name of a security, given only its ticker symbol.

I must admit, I am very uneducated in this area and really need some basic-level help.

I don't think I even know the right question to ask.

Thanks in advance for any help you may provide.

Mike Sobieski

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (7)
2b.

Re: Full security name

Posted by: "mike_sobieski" mike_sobieski@yahoo.com   mike_sobieski

Fri Jul 29, 2011 1:11 pm (PDT)





--- In smf_addin@yahoogroups.com, "mike_sobieski" <mike_sobieski@...> wrote:
>
> I've been using this functionality for a while and have recently run into a snag with retrieving the full name of a security, given only its ticker symbol.
>
> I must admit, I am very uneducated in this area and really need some basic-level help.
>
> I don't think I even know the right question to ask.
>
> Thanks in advance for any help you may provide.
>
> Mike Sobieski

Post Script:
I see the below. If I get this correctly, it seems that the Full and Complete security name (e.g. International Business Machines vs. International Bus) may not be available.

That said, I have to believe getting the full & complete name is possible - it just may require much smarter minds than mine.

Please advise... and feel free to call me 480-820-2660.
>
--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> The RCHGetYahooQuotes() function can only return to you what Yahoo provides:
>
>
> Yahoo may be providing full info on their web page, but they are not
> providing it via their CSV interface -- which is the process from Yahoo that
> the RCHGetYahooQuotes() function uses.
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (7)
2c.

Re: Full security name

Posted by: "mike_sobieski" mike_sobieski@yahoo.com   mike_sobieski

Fri Jul 29, 2011 1:26 pm (PDT)



Excel 2007 via a citrix metaframe connection.

--- In smf_addin@yahoogroups.com, "mike_sobieski" <mike_sobieski@...> wrote:
>
>
>
> --- In smf_addin@yahoogroups.com, "mike_sobieski" <mike_sobieski@> wrote:
> >
> > I've been using this functionality for a while and have recently run into a snag with retrieving the full name of a security, given only its ticker symbol.
> >
> > I must admit, I am very uneducated in this area and really need some basic-level help.
> >
> > I don't think I even know the right question to ask.
> >
> > Thanks in advance for any help you may provide.
> >
> > Mike Sobieski
>
>
> Post Script:
> I see the below. If I get this correctly, it seems that the Full and Complete security name (e.g. International Business Machines vs. International Bus) may not be available.
>
> That said, I have to believe getting the full & complete name is possible - it just may require much smarter minds than mine.
>
> Please advise... and feel free to call me 480-820-2660.
> >
> --- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@> wrote:
> >
> > The RCHGetYahooQuotes() function can only return to you what Yahoo provides:
> >
> >
> > Yahoo may be providing full info on their web page, but they are not
> > providing it via their CSV interface -- which is the process from Yahoo that
> > the RCHGetYahooQuotes() function uses.
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (7)
2d.

Re: Full security name

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Fri Jul 29, 2011 2:11 pm (PDT)



No matter what method you use to get the name of the security, you're at the
mercy of the data source as to what they choose to provide.

On Fri, Jul 29, 2011 at 1:11 PM, mike_sobieski <mike_sobieski@yahoo.com>wrote:

>
> --- In smf_addin@yahoogroups.com, "mike_sobieski" <mike_sobieski@...>
> wrote:
> >
> > I've been using this functionality for a while and have recently run into
> a snag with retrieving the full name of a security, given only its ticker
> symbol.
> >
> > I must admit, I am very uneducated in this area and really need some
> basic-level help.
> >
> > I don't think I even know the right question to ask.
> >
> > Thanks in advance for any help you may provide.
> >
> > Mike Sobieski
>
>
> Post Script:
> I see the below. If I get this correctly, it seems that the Full and
> Complete security name (e.g. International Business Machines vs.
> International Bus) may not be available.
>
> That said, I have to believe getting the full & complete name is possible -
> it just may require much smarter minds than mine.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (7)
2e.

Re: Full security name

Posted by: "mike_sobieski" mike_sobieski@yahoo.com   mike_sobieski

Fri Jul 29, 2011 2:36 pm (PDT)




Randy,

Do you know of a data source that provides the complete security name?

So far, the best I could come up with is:

https://personal.vanguard.com/us/funds/stocks/snapshot?Ticker=~~~~~

But even this is a little messy with the "...Co( New York Stock Exchange)" stuff at the end.

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> No matter what method you use to get the name of the security, you're at the
> mercy of the data source as to what they choose to provide.
>
> On Fri, Jul 29, 2011 at 1:11 PM, mike_sobieski <mike_sobieski@...>wrote:
>
> >
> > --- In smf_addin@yahoogroups.com, "mike_sobieski" <mike_sobieski@>
> > wrote:
> > >
> > > I've been using this functionality for a while and have recently run into
> > a snag with retrieving the full name of a security, given only its ticker
> > symbol.
> > >
> > > I must admit, I am very uneducated in this area and really need some
> > basic-level help.
> > >
> > > I don't think I even know the right question to ask.
> > >
> > > Thanks in advance for any help you may provide.
> > >
> > > Mike Sobieski
> >
> >
> > Post Script:
> > I see the below. If I get this correctly, it seems that the Full and
> > Complete security name (e.g. International Business Machines vs.
> > International Bus) may not be available.
> >
> > That said, I have to believe getting the full & complete name is possible -
> > it just may require much smarter minds than mine.
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (7)
2f.

Re: Full security name

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Fri Jul 29, 2011 2:40 pm (PDT)



The name and exchange are in separate "span" tags. Try something like:

=smfGetTagContent("
https://personal.vanguard.com/us/funds/stocks/snapshot?Ticker=
"&C4,"span",1,"HeadTag")

I'm not sure how reliable the search string is.

On Fri, Jul 29, 2011 at 2:33 PM, mike_sobieski <mike_sobieski@yahoo.com>wrote:

>
> Do you know of a data source that provides the complete security name?
>
> So far, the best I could come up with is:
>
> https://personal.vanguard.com/us/funds/stocks/snapshot?Ticker=~~~~~
>
> But even this is a little messy with the "...Co( New York Stock Exchange)"
> stuff at the end.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (7)
2g.

Re: Full security name

Posted by: "mike_sobieski" mike_sobieski@yahoo.com   mike_sobieski

Fri Jul 29, 2011 3:15 pm (PDT)



Randy, You're The Man. This works.

Timeless Proverb (paraphrased):
"the man who knows how will always be at the mercy of the man who knows why."

Now, at least, now I know how. Thank you.

I have no idea what you mean by reliable string, but I guess I'll find out if it doesn't work in the future.

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> The name and exchange are in separate "span" tags. Try something like:
>
> =smfGetTagContent("
> https://personal.vanguard.com/us/funds/stocks/snapshot?Ticker=
> "&C4,"span",1,"HeadTag")
>
> I'm not sure how reliable the search string is.
>
> On Fri, Jul 29, 2011 at 2:33 PM, mike_sobieski <mike_sobieski@...>wrote:
>
> >
> > Do you know of a data source that provides the complete security name?
> >
> > So far, the best I could come up with is:
> >
> > https://personal.vanguard.com/us/funds/stocks/snapshot?Ticker=~~~~~
> >
> > But even this is a little messy with the "...Co( New York Stock Exchange)"
> > stuff at the end.
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (7)
3a.

Fwd: [smf_addin] Re: Quotes on Stock Options including Greeks

Posted by: "MIGUEL ANGEL GONZALEZ" spectratecharchitecture@gmail.com   spectratecharchitecture

Fri Jul 29, 2011 12:08 pm (PDT)

[Attachment(s) from MIGUEL ANGEL GONZALEZ included below]

---------- Forwarded message ----------
From: MIGUEL ANGEL GONZALEZ <spectratecharchitecture@gmail.com>
Date: Fri, Jul 29, 2011 at 10:05 AM
Subject: Re: [smf_addin] Re: Quotes on Stock Options including Greeks
To: rharmelink@gmail.com

i had sent this to your gmail...

Hello, Thank you for your help.
I am trying to get streaming options quotes from OptionsXpress, I
dowloaded the SMF add-in to my computer and then I opened up an example from
the files on yahoo groups. I got the examples to work once I specified the
new add-in location on my computer.
I then used the getcelltable formula to find the information i needed
from OptionsXpress. Please see the attached excel and txt file. I used the
web address:
https://www.optionsxpress.com/OXNetTools/Chains/index.aspx?Symbol=aapl&ChainType=0&Range=10&lstMonths=9/17/2011;1

I have an OptionsXpress account and i can see the streaming options on their
website, and this excel sheet is somewhat delayed, but sometimes it does
match their streaming quotes. But, to keep refreshing the prices I have to
close the excel file and reopen it. Having said that, my two questions are:

1) How can I refresh the cells without having to close/open the excel file?
Do i have to write a macro that I can reload/refresh that inlcudes the
getcelltable formulas? I hit the refresh all button under the data tab in
excel and that won't do it.

2)Is there a way to create a connection to a page that is framed? I use
google chrome and I can actually find the streaming options text if i go to
the option chains and right click + inspect element. The webpage that shows
me this just has a general web address:
https://www.optionsxpress.com/login.asp.

Thank you for your time and help.

--
Miguel Angel Gonzalez

--
Miguel Angel Gonzalez

Attachment(s) from MIGUEL ANGEL GONZALEZ

2 of 2 File(s)

STREAMING OPTIONS.xlsm
options download code piece.txt
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)
3b.

Re: Quotes on Stock Options including Greeks [2 Attachments]

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Fri Jul 29, 2011 2:14 pm (PDT)



Answers:

1. Use the smfForceRecalculation macro. See the "Links" area of the group
for more information on it.

2. Use the URL of the frame. Note that content of ASP pages can be
difficult to retrieve because they don't have to have a direct URL to the
content you are after. Which means the add-in cannot get the data. You do
need a "bookmarkable" URL in order for the add-in to retrieve the data.

On Fri, Jul 29, 2011 at 12:08 PM, MIGUEL ANGEL GONZALEZ <
spectratecharchitecture@gmail.com> wrote:

>
> 1) How can I refresh the cells without having to close/open the excel file?
> Do i have to write a macro that I can reload/refresh that inlcudes the
> getcelltable formulas? I hit the refresh all button under the data tab in
> excel and that won't do it.
>
> 2)Is there a way to create a connection to a page that is framed? I use
> google chrome and I can actually find the streaming options text if i go to
> the option chains and right click + inspect element. The webpage that shows
> me this just has a general web address:
> https://www.optionsxpress.com/login.asp.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)
3c.

Re: Quotes on Stock Options including Greeks

Posted by: "MIGUEL ANGEL GONZALEZ" spectratecharchitecture@gmail.com   spectratecharchitecture

Fri Jul 29, 2011 8:45 pm (PDT)



I understand now. One more question:

How can i get the following formula to replace the strike price (last 3
numbers in the formula) with a value in a cell?
='C:\Program Files\SMF
Add-in\RCH_Stock_Market_Functions.xla'!RCHGetTableCell("
https://www.optionsxpress.com/OXNetTools/Chains/index.aspx?
Symbol=aapl&ChainType=0&Range=10&lstMonths=9/17/2011;1",3,"*395*")

for example, i would like the formula to get any value that i place in cell
A1 and place it where the *395 *is in the formula. I tried the INDIRECT
function in excel and I could not get it to work...

On Fri, Jul 29, 2011 at 3:14 PM, Randy Harmelink <rharmelink@gmail.com>wrote:

> **
>
>
> Answers:
>
> 1. Use the smfForceRecalculation macro. See the "Links" area of the
> group for more information on it.
>
> 2. Use the URL of the frame. Note that content of ASP pages can be
> difficult to retrieve because they don't have to have a direct URL to the
> content you are after. Which means the add-in cannot get the data. You do
> need a "bookmarkable" URL in order for the add-in to retrieve the data.
>
> On Fri, Jul 29, 2011 at 12:08 PM, MIGUEL ANGEL GONZALEZ <
> spectratecharchitecture@gmail.com> wrote:
>
>>
>> 1) How can I refresh the cells without having to close/open the excel
>> file? Do i have to write a macro that I can reload/refresh that inlcudes the
>> getcelltable formulas? I hit the refresh all button under the data tab in
>> excel and that won't do it.
>>
>> 2)Is there a way to create a connection to a page that is framed? I use
>> google chrome and I can actually find the streaming options text if i go to
>> the option chains and right click + inspect element. The webpage that shows
>> me this just has a general web address:
>> https://www.optionsxpress.com/login.asp.
>>
>
>
>

--
Miguel Angel Gonzalez
SpectraTech Systems
President/Owner
(915)345-5668
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)
3d.

Re: Quotes on Stock Options including Greeks

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Fri Jul 29, 2011 8:54 pm (PDT)



Just replace the "395" with the cell reference itself -- A1.

By the way, if you have the path on the formula like that, your links aren't
resolving correctly. See:

http://finance.groups.yahoo.com/group/smf_addin/message/11346

On Fri, Jul 29, 2011 at 8:45 PM, MIGUEL ANGEL GONZALEZ <
spectratecharchitecture@gmail.com> wrote:

>
> I understand now. One more question:
>
> How can i get the following formula to replace the strike price (last 3
> numbers in the formula) with a value in a cell?
> ='C:\Program Files\SMF
> Add-in\RCH_Stock_Market_Functions.xla'!RCHGetTableCell("
> https://www.optionsxpress.com/OXNetTools/Chains/index.aspx?
> Symbol=aapl&ChainType=0&Range=10&lstMonths=9/17/2011;1",3,"*395*")
>
> for example, i would like the formula to get any value that i place in cell
> A1 and place it where the *395 *is in the formula. I tried the INDIRECT
> function in excel and I could not get it to work...
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)
Recent Activity
Visit Your Group
Need traffic?

Drive customers

With search ads

on Yahoo!

Yahoo! Finance

It's Now Personal

Guides, news,

advice & more.

Yahoo! News

Get it all here

Breaking news to

entertainment news

Need to Reply?

Click one of the "Reply" links to respond to a specific message in the Daily Digest.

Create New Topic | Visit Your Group on the Web
Diposting oleh EXCEL FEED LEARNING di 03.43

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)