Selasa, 05 Juni 2012

[smf_addin] Digest Number 2236

Messages In This Digest (23 Messages)

1a.
ADVFN Error in spreadsheet using rchgetelementnumber() From: Amir
1b.
Re: ADVFN Error in spreadsheet using rchgetelementnumber() From: Randy Harmelink
2a.
Re: NASDAQ Financial Statements From: rebalance85
2b.
Re: NASDAQ Financial Statements From: Randy Harmelink
2c.
Re: NASDAQ Financial Statements From: rebalance85
2d.
Re: NASDAQ Financial Statements From: Randy Harmelink
3a.
Morningstar CEF From: Ron Spruell
3b.
Re: Morningstar CEF From: Randy Harmelink
3c.
Re: Morningstar CEF From: Randy Harmelink
3d.
Re: Morningstar CEF From: Ron Spruell
3e.
Re: Morningstar CEF From: Randy Harmelink
3f.
Re: Morningstar CEF From: Ron Spruell
4a.
Re: A stock's listing exchange From: cherry77tree
5a.
ELEMENT FUNCTION LIST-1 From: ufdn16
5b.
Re: ELEMENT FUNCTION LIST-1 From: Randy Harmelink
6a.
Error on RCHGetElementNumber-Template-AdvFN-Financial-Statements.xls From: Jacob Jose
6b.
Re: Error on RCHGetElementNumber-Template-AdvFN-Financial-Statements From: Randy Harmelink
7a.
Re: How to get greek letter of put option and Error of  smfGetOXOpti From: 仁 王
7b.
Re: How to get greek letter of put option and Error of smfGetOXOptio From: Randy Harmelink
7c.
Re: How to get greek letter of put option and Error of smfGetOXOptio From: 仁 王
7d.
Re: How to get greek letter of put option and Error of smfGetOXOptio From: Randy Harmelink
7e.
Re: How to get greek letter of put option and Error of smfGetOXOptio From: 仁 王
7f.
Re: How to get greek letter of put option and Error of smfGetOXOptio From: 仁 王

Messages

1a.

ADVFN Error in spreadsheet using rchgetelementnumber()

Posted by: "Amir" amir.rehman@yahoo.com   amir.rehman

Mon Jun 4, 2012 6:37 am (PDT)



Hello,

I have developed a spreadsheet using rchgetelementnumber() function. Majority of the data sources are used from ADVFN. And it is working fine for me. Now the problem is that When I try to open the file in Netherlands, the entire spreadsheet generates as error. Further, in my browser when I open WWW.ADVFN.COM then it becomes UK.ADVFN.COM. Please help me to fix the issue.

Regards

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

Re: ADVFN Error in spreadsheet using rchgetelementnumber()

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

Mon Jun 4, 2012 8:34 am (PDT)



See:

http://finance.groups.yahoo.com/group/smf_addin/message/18687
http://finance.groups.yahoo.com/group/smf_addin/message/18693

On Mon, Jun 4, 2012 at 6:37 AM, Amir <amir.rehman@yahoo.com> wrote:

> Hello,
>
> I have developed a spreadsheet using rchgetelementnumber() function.
> Majority of the data sources are used from ADVFN. And it is working fine
> for me. Now the problem is that When I try to open the file in Netherlands,
> the entire spreadsheet generates as error. Further, in my browser when I
> open WWW.ADVFN.COM then it becomes UK.ADVFN.COM. Please help me to fix
> the issue.
>
>
> Regards
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
>
>
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
2a.

Re: NASDAQ Financial Statements

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

Mon Jun 4, 2012 7:54 am (PDT)



Hi, again Randy,
I just download "RCHGetTableCell-Template-NASDAQ-Annual-Financials", and how to make the correction for the new link, here are some examples, please give me the correct one, thanks!

=IF(Ticker="None","--",RCHGetTableCell("http://fundamentals.nasdaq.com/nasdaq_fundamentals.asp?documentType=1&Duration=2&NumPeriods=60&selected="&Ticker,1,"Ending:",">Total Revenue",,,,,,"--"))

This got --, and couldn't get the figure.

and

=IF(Ticker="None","--",RCHGetTableCell("http://fundamentals.nasdaq.com/nasdaq_fundamentals.asp?documentType=1&Duration=2&NumPeriods=60&selected="&Ticker,1,"Ending:",,,,,,,"--"))

This got: Trend
--- In smf_addin@yahoogroups.com, "Randy H" <rharmelink@...> wrote:
>
> You need to review the source code on the web page to find out the
> idiosyncrasies of extraction. They have changed the web page to add
> charts on each line of the page using a bunch of HTML tables, which
> makes table extraction a little more difficult. Try something like:
>
> =RCHGetTableCell("http://fundamentals.nasdaq.com/nasdaq_fundamentals.asp\
> ?documentType=2&Duration=1&NumPeriods=12&selected=AAPL",0,"Total
> Current Assets","fundnum")
>
> Replacing "AAPL" in the string is a simple EXCEL string concatenation,
> such as:
>
> "...string1..." & "...string2..." & "...string3..."
>
> PS: Questions about the add-in should be sent to the Yahoo group, not to
> me directly. Your message ended up in my SPAM folder and almost got
> deleted without me seeing it.
>
> On Tue, May 22, 2012 at 11:22 PM, rebalance85 <rebalance85@
> <mailto:rebalance85@...> > wrote:
> According to this link
> http://finance.groups.yahoo.com/group/smf_addin/message/8315
> <http://finance.groups.yahoo.com/group/smf_addin/message/8315>
> I could not get the data from Nasdaq, blank or error, use your function:
> =RCHGetTableCell("http://fundamentals.nasdaq.com/nasdaq_fundamentals.asp\
> ?documentType=2&Duration=1&NumPeriods=12&selected=AAPL
> <http://fundamentals.nasdaq.com/nasdaq_fundamentals.asp?documentType=2&D\
> uration=1&NumPeriods=12&selected=AAPL> ",1,"Total Current Assets")
> My excel version 2007.
>
> Another issue is to replace the ticker number "AAPL", and some thing
> like the documenttype, then I can get other company freely.
>

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

Re: NASDAQ Financial Statements

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

Mon Jun 4, 2012 8:39 am (PDT)



Go back and reread my previous answer. Note the "fundnum" search parameter
I added.

On Mon, Jun 4, 2012 at 7:54 AM, rebalance85 <rebalance85@yahoo.com> wrote:

> Hi, again Randy,
> I just download "RCHGetTableCell-Template-NASDAQ-Annual-Financials", and
> how to make the correction for the new link, here are some examples, please
> give me the correct one, thanks!
>
> =IF(Ticker="None","--",RCHGetTableCell("
> http://fundamentals.nasdaq.com/nasdaq_fundamentals.asp?documentType=1&Duration=2&NumPeriods=60&selected="&Ticker,1,"Ending:",">Total
> Revenue",,,,,,"--"))
>
> This got --, and couldn't get the figure.
>
> and
>
> =IF(Ticker="None","--",RCHGetTableCell("
> http://fundamentals.nasdaq.com/nasdaq_fundamentals.asp?documentType=1&Duration=2&NumPeriods=60&selected=
> "&Ticker,1,"Ending:",,,,,,,"--"))
>
> This got: Trend
> --- In smf_addin@yahoogroups.com, "Randy H" <rharmelink@...> wrote:
> >
> > You need to review the source code on the web page to find out the
> > idiosyncrasies of extraction. They have changed the web page to add
> > charts on each line of the page using a bunch of HTML tables, which
> > makes table extraction a little more difficult. Try something like:
> >
> > =RCHGetTableCell("
> http://fundamentals.nasdaq.com/nasdaq_fundamentals.asp\
> > ?documentType=2&Duration=1&NumPeriods=12&selected=AAPL",0,"Total
> > Current Assets","fundnum")
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (8)
2c.

Re: NASDAQ Financial Statements

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

Mon Jun 4, 2012 9:09 am (PDT)



I deleted the",,,,,,"--", and replaced with "fundnum", so I got the number, am right?
By the way, what's the meaning of "ENDING", and also what's the difference between "Total Revenue" and ">Total Revenue"

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Go back and reread my previous answer. Note the "fundnum" search parameter
> I added.
>
> On Mon, Jun 4, 2012 at 7:54 AM, rebalance85 <rebalance85@...> wrote:
>
> > Hi, again Randy,
> > I just download "RCHGetTableCell-Template-NASDAQ-Annual-Financials", and
> > how to make the correction for the new link, here are some examples, please
> > give me the correct one, thanks!
> >
> > =IF(Ticker="None","--",RCHGetTableCell("
> > http://fundamentals.nasdaq.com/nasdaq_fundamentals.asp?documentType=1&Duration=2&NumPeriods=60&selected="&Ticker,1,"Ending:",">Total
> > Revenue",,,,,,"--"))
> >
> > This got --, and couldn't get the figure.
> >
> > and
> >
> > =IF(Ticker="None","--",RCHGetTableCell("
> > http://fundamentals.nasdaq.com/nasdaq_fundamentals.asp?documentType=1&Duration=2&NumPeriods=60&selected=
> > "&Ticker,1,"Ending:",,,,,,,"--"))
> >
> > This got: Trend
> > --- In smf_addin@yahoogroups.com, "Randy H" <rharmelink@> wrote:
> > >
> > > You need to review the source code on the web page to find out the
> > > idiosyncrasies of extraction. They have changed the web page to add
> > > charts on each line of the page using a bunch of HTML tables, which
> > > makes table extraction a little more difficult. Try something like:
> > >
> > > =RCHGetTableCell("
> > http://fundamentals.nasdaq.com/nasdaq_fundamentals.asp\
> > > ?documentType=2&Duration=1&NumPeriods=12&selected=AAPL",0,"Total
> > > Current Assets","fundnum")
> >
>

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

Re: NASDAQ Financial Statements

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

Mon Jun 4, 2012 9:24 am (PDT)



On Mon, Jun 4, 2012 at 9:09 AM, rebalance85 <rebalance85@yahoo.com> wrote:

> I deleted the",,,,,,"--", and replaced with "fundnum", so I got the
> number, am right?
>

Yes. But you didn't need to delete anything. Just change the parameter.

> By the way, what's the meaning of "ENDING",

Check the documentation. I'm not going to go look it up and cut and paste
it here.

> and also what's the difference between "Total Revenue" and ">Total Revenue"
>

It gives you a more unique search string, PROVIDED the web page is written
up that way. You HAVE to look.

Otherwise, if a meta-tag description of the web page contains the word
"Total Revenue", your search will not leave you in the correct place on the
web page.

You NEED to have unique strings to place you on the web page for the data
extraction.
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (8)
3a.

Morningstar CEF

Posted by: "Ron Spruell" hashky@yahoo.com   hashky

Mon Jun 4, 2012 9:31 am (PDT)



Randy -

I have been able to pull some information from cefconnect.com, by logging on and running the Fund Screener and the following

=RCHGetHTMLTable("http://www.cefconnect.com/Pricing/DailyPricing.aspx",">Fund Name",-1,"",1) in an array.

I have been able to pull Total Leverage, Market Value, 6-Month Avg Discount, and 3-Year Average Discount from Morningstar using.

=RCHGetTableCell("http://cef.morningstar.com/quote?t="&$C6,6,"Total Leverage",4,,,1)
=RCHGetTableCell("http://cef.morningstar.com/quote?t="&$C6,5,"Market Value",4,,,1)
=RCHGetTableCell("http://cef.morningstar.com/quote?t="&$C6,4,"6-Month",,,,1)
=RCHGetTableCell("http://cef.morningstar.com/quote?t="&$C6,5,"6-Month",,,,1)

This information is also available from cefconnect.com, but I didn't try to get it from there.

I would like to be able to pull the Star Rating and Bronze/Silver/Gold from Morningstar.  So far, no luck.    I think that I would use smfGetTagContent() or RCHGetWebData().

Can you help?

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

Re: Morningstar CEF

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

Mon Jun 4, 2012 12:05 pm (PDT)



Sample ticker symbol please?

On Mon, Jun 4, 2012 at 9:31 AM, Ron Spruell <hashky@yahoo.com> wrote:

>
> Randy -
>
> I have been able to pull some information from cefconnect.com, by logging
> on and running the Fund Screener and the following
> =RCHGetHTMLTable("http://www.cefconnect.com/Pricing/DailyPricing.aspx",">Fund
> Name",-1,"",1) in an array.
>
> I have been able to pull Total Leverage, Market Value, 6-Month Avg
> Discount, and 3-Year Average Discount from Morningstar using.
> =RCHGetTableCell("http://cef.morningstar.com/quote?t="&$C6,6,"Total
> Leverage",4,,,1)
> =RCHGetTableCell("http://cef.morningstar.com/quote?t="&$C6,5,"Market
> Value",4,,,1)
> =RCHGetTableCell("http://cef.morningstar.com/quote?t=
> "&$C6,4,"6-Month",,,,1)
> =RCHGetTableCell("http://cef.morningstar.com/quote?t=
> "&$C6,5,"6-Month",,,,1)
>
> This information is also available from cefconnect.com, but I didn't try
> to get it from there.
>
> I would like to be able to pull the Star Rating and Bronze/Silver/Gold
> from Morningstar. So far, no luck. I think that I would use
> smfGetTagContent() or RCHGetWebData().
>
> Can you help?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (6)
3c.

Re: Morningstar CEF

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

Mon Jun 4, 2012 12:17 pm (PDT)



Oops. Got some sample ticker symbols from the first link.

For the star rating, try something like:

=smfStrExtr(RCHGetWebData("http://cef.morningstar.com/quote?t=NQI
","r_star",10),"r_star","'")

...but I don't see any context for "Bronze/Silver/Gold"...

On Mon, Jun 4, 2012 at 9:31 AM, Ron Spruell <hashky@yahoo.com> wrote:

> I have been able to pull some information from cefconnect.com, by
> logging on and running the Fund Screener and the following
> =RCHGetHTMLTable("http://www.cefconnect.com/Pricing/DailyPricing.aspx",">Fund
> Name",-1,"",1) in an array.
>
> I have been able to pull Total Leverage, Market Value, 6-Month Avg
> Discount, and 3-Year Average Discount from Morningstar using.
> =RCHGetTableCell("http://cef.morningstar.com/quote?t="&$C6,6,"Total
> Leverage",4,,,1)
> =RCHGetTableCell("http://cef.morningstar.com/quote?t="&$C6,5,"Market
> Value",4,,,1)
> =RCHGetTableCell("http://cef.morningstar.com/quote?t=
> "&$C6,4,"6-Month",,,,1)
> =RCHGetTableCell("http://cef.morningstar.com/quote?t=
> "&$C6,5,"6-Month",,,,1)
>
> This information is also available from cefconnect.com, but I didn't try
> to get it from there.
>
> I would like to be able to pull the Star Rating and Bronze/Silver/Gold
> from Morningstar. So far, no luck. I think that I would use
> smfGetTagContent() or RCHGetWebData().
>
> Can you help?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (6)
3d.

Re: Morningstar CEF

Posted by: "Ron Spruell" hashky@yahoo.com   hashky

Mon Jun 4, 2012 12:48 pm (PDT)



Thank you very much.

NPI has a Bronze Rating.

>________________________________
> From: Randy Harmelink <rharmelink@gmail.com>
>To: smf_addin@yahoogroups.com
>Sent: Monday, June 4, 2012 2:17 PM
>Subject: Re: [smf_addin] Morningstar CEF
>
>
> 
>Oops. Got some sample ticker symbols from the first link.
>
>For the star rating, try something like:
>
>=smfStrExtr(RCHGetWebData("http://cef.morningstar.com/quote?t=NQI","r_star",10),"r_star","'")
>
>...but I don't see any context for "Bronze/Silver/Gold"...
>
>
>On Mon, Jun 4, 2012 at 9:31 AM, Ron Spruell <hashky@yahoo.com> wrote:
>
>I have been able to pull some information from cefconnect.com, by logging on and running the Fund Screener and the following
>>
>>=RCHGetHTMLTable("http://www.cefconnect.com/Pricing/DailyPricing.aspx",">Fund Name",-1,"",1) in an array.
>>
>>
>>I have been able to pull Total Leverage, Market Value, 6-Month Avg Discount, and 3-Year Average Discount from Morningstar using.
>>
>>=RCHGetTableCell("http://cef.morningstar.com/quote?t="&$C6,6,"Total Leverage",4,,,1)
>>=RCHGetTableCell("http://cef.morningstar.com/quote?t="&$C6,5,"Market Value",4,,,1)
>>=RCHGetTableCell("http://cef.morningstar.com/quote?t="&$C6,4,"6-Month",,,,1)
>>=RCHGetTableCell("http://cef.morningstar.com/quote?t="&$C6,5,"6-Month",,,,1)
>>
>>
>>This information is also available from cefconnect.com, but I didn't try to get it from there.
>>
>>
>>
>>I would like to be able to pull the Star Rating and Bronze/Silver/Gold from Morningstar.  So far, no luck.    I think that I would use smfGetTagContent() or RCHGetWebData().
>>
>>
>>
>>Can you help?
>>
>
>
>
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (6)
3e.

Re: Morningstar CEF

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

Mon Jun 4, 2012 12:54 pm (PDT)



It looks like you could search for "r_bronze_" to verify a bronze rating.
Possibly a similar format for gold and sliver. And if none are found, no
such rating.

On Mon, Jun 4, 2012 at 12:48 PM, Ron Spruell <hashky@yahoo.com> wrote:

>
> NPI has a Bronze Rating.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (6)
3f.

Re: Morningstar CEF

Posted by: "Ron Spruell" hashky@yahoo.com   hashky

Mon Jun 4, 2012 12:59 pm (PDT)



I will work on it.  Thanks.

>________________________________
> From: Randy Harmelink <rharmelink@gmail.com>
>To: smf_addin@yahoogroups.com
>Sent: Monday, June 4, 2012 2:54 PM
>Subject: Re: [smf_addin] Morningstar CEF
>
>
> 
>It looks like you could search for "r_bronze_" to verify a bronze rating. Possibly a similar format for gold and sliver. And if none are found, no such rating.
>
>
>On Mon, Jun 4, 2012 at 12:48 PM, Ron Spruell <hashky@yahoo.com> wrote:
>
>
>>
>>NPI has a Bronze Rating.
>>
>
>
>
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (6)
4a.

Re: A stock's listing exchange

Posted by: "cherry77tree" david.nincic.wg99@wharton.upenn.edu   cherry77tree

Mon Jun 4, 2012 10:07 am (PDT)



That fixed it. Thanks Randy for your answer and all your work on SMF.
David

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> You probably need the new MSN element definitions file from the "Works in
> Progress" folder:
>
> http://finance.groups.yahoo.com/group/smf_addin/message/18529
>
> On Sat, Jun 2, 2012 at 12:52 PM, cherry77tree <
> david.nincic.wg99@...> wrote:
>
> >
> > Is there a way to return a stock's listing exchange? (e.g., "IBM" would
> > return NYSE, "CMMCY" would return Pink or OTC)
> >
> > I thought =RCHGetElementNumber("IBM",3) would do it, but it looks like
> > that element (Source: MSN, Element: Exchange) no longer works.
> >
> > The reason I ask is that Yahoo Finance no longer uses an exchange suffix
> > (e.g., .PK, .OB) on its ticker symbols. That suffix was a useful reminder
> > to me on whether a stock was Pink Sheet or OTC Bulletin Board. I always
> > avoid those stocks.
> >
>

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

ELEMENT FUNCTION LIST-1

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

Mon Jun 4, 2012 2:41 pm (PDT)



I opened this file from the works in progress folder.
I then saved it.
Is there more I have to do, because
27 MSN 3 Month % Price Change
28 MSN 6 Month % Price Change
29 MSN 12 Month % Price Change
functions still don't work.

David

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

Re: ELEMENT FUNCTION LIST-1

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

Mon Jun 4, 2012 2:46 pm (PDT)



I don't see the file you are mention -- are you talking about the
smf-elements-1.txt file?

If so, you should be able to exit and restart EXCEL to pick up the new
definitions. They are typically only loaded once. You could also run the
smfForceRecalculation macro to force them to reload (see LINKS area of
group for more info).

On Mon, Jun 4, 2012 at 2:41 PM, ufdn16 <ufdn16@yahoo.com> wrote:

> I opened this file from the works in progress folder.
> I then saved it.
> Is there more I have to do, because
> 27 MSN 3 Month % Price Change
> 28 MSN 6 Month % Price Change
> 29 MSN 12 Month % Price Change
> functions still don't work.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
6a.

Error on RCHGetElementNumber-Template-AdvFN-Financial-Statements.xls

Posted by: "Jacob Jose" pepecan47@yahoo.ca   pepecan47

Mon Jun 4, 2012 9:04 pm (PDT)



I nned to use AdvFN data, this is what I did:
 
- Installed the SMF Add-in from the Works-In-Progress folder
- Copied the smf-elements-1.txt from the Works-In-Progress folder to my SMF folder
- Created a file smf-AdvFN-prefix.txt with the 2 characters "ca" in the SMF folder. I work from Canada.
 
When using RCHGetElementNumber-Template-AdvFN-Financial-Statements.xls, it works fine with PG, JNJ but I cannot make it work with MCD.
 
I can access the AdvFN web site and I see the data for MCD, but I get Erros in all cells when accesing from the template. 

Can somebody from Canada try the tempalte using MCD?x

Regards,
Jose L. Jacob
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
6b.

Re: Error on RCHGetElementNumber-Template-AdvFN-Financial-Statements

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

Mon Jun 4, 2012 9:35 pm (PDT)



The problem is that ca.advfn.com reacts to ticker symbols differently,
because of the Canadian default perspective.

If I go there are type in just MCD, it brings up Macarthur Diamonds --
TSX:MCD.

If you want McDonald's, you need to use NYSE:MCD as the ticker symbol.

On Mon, Jun 4, 2012 at 9:04 PM, Jacob Jose <pepecan47@yahoo.ca> wrote:

>
> I nned to use AdvFN data, this is what I did:
>
> - Installed the SMF Add-in from the Works-In-Progress folder
> - Copied the smf-elements-1.txt from the Works-In-Progress folder to my
> SMF folder
> - Created a file smf-AdvFN-prefix.txt with the 2 characters "ca" in the
> SMF folder. I work from Canada.
>
> When using RCHGetElementNumber-Template-AdvFN-Financial-Statements.xls,
> it works fine with PG, JNJ but I cannot make it work with MCD.
>
> I can access the AdvFN web site and I see the data for MCD, but I get
> Erros in all cells when accesing from the template.
>
> Can somebody from Canada try the tempalte using MCD?x
>
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
7a.

Re: How to get greek letter of put option and Error of  smfGetOXOpti

Posted by: "仁 王" id123.id123@yahoo.com.cn   id123.id123

Mon Jun 4, 2012 11:09 pm (PDT)



Hi everyone,

  Is there any way I can get the delta, gamma, vega information of  put option from any function? I noticed smfGetOXOptionQuote()  only support Call option. (except put-call parity)

Besides, it is error =smfGetOXOptionQuote("CL","C","2012/6/15",79,"b"). Any one can help?

Thanks,

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

Re: How to get greek letter of put option and Error of smfGetOXOptio

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

Mon Jun 4, 2012 11:17 pm (PDT)



The formula you cite below is returning "Error" because has an incorrect
date format and an invalid strike price,

This works:

=smfGetOXOptionQuote("CL","C","6/16/2012",95,"b")

However, the OX web page for greeks on puts is not accessible without
logging in and using their security process.

The beta version of the add-in from the "Works in Progress" folder would
allow you to get greeks on puts from 888options.com, but you do need to
create a security cookie before using the function.

On Mon, Jun 4, 2012 at 11:00 PM, 仁 王 <id123.id123@yahoo.com.cn> wrote:

>
> Is there any way I can get the delta, gamma, vega information of put
> option from any function? I noticed smfGetOXOptionQuote() only support
> Call option. (except put-call parity)
>
> Besides, it is error =smfGetOXOptionQuote("CL","C","2012/6/15",79,"b").
> Any one can help?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (6)
7c.

Re: How to get greek letter of put option and Error of smfGetOXOptio

Posted by: "仁 王" id123.id123@yahoo.com.cn   id123.id123

Tue Jun 5, 2012 12:21 am (PDT)



Hi Randy,
  Thank you so much for your help. I've tried the 
smfGet888OptionQuote(). I got a #Name Error =smfGet888OptionQuote("SPY","C",DATE(2012,6,8),116,"s") . How can I 
create a security cookie ?  I've visit the webpage http://www.optionseducation.org/quotes.html?quote=SPY. I also log in this website with IE. What else should I do?

zx

--- 12年6月5日，周二, Randy Harmelink <rharmelink@gmail.com> 写道：

发件人: Randy Harmelink <rharmelink@gmail.com>
主题: Re: [smf_addin] How to get greek letter of put option and Error of smfGetOXOptionQuote()
收件人: smf_addin@yahoogroups.com
日期: 2012年6月5日,周二,下午2:17

 

The formula you cite below is returning "Error" because has an incorrect date format and an invalid strike price,

This works:

=smfGetOXOptionQuote("CL","C","6/16/2012",95,"b")

However, the OX web page for greeks on puts is not accessible without logging in and using their security process.

The beta version of the add-in from the "Works in Progress" folder would allow you to get greeks on puts from 888options.com, but you do need to create a security cookie before using the function.

On Mon, Jun 4, 2012 at 11:00 PM, 仁 王 <id123.id123@yahoo.com.cn> wrote:

  Is there any way I can get the delta, gamma, vega information of  put option from any function? I noticed smfGetOXOptionQuote()  only support Call option. (except put-call parity)

Besides, it is error =smfGetOXOptionQuote("CL","C","2012/6/15",79,"b"). Any one can help?

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

Re: How to get greek letter of put option and Error of smfGetOXOptio

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

Tue Jun 5, 2012 12:36 am (PDT)



If you're getting #NAME?, then you probably didn't install the beta version
of the add-in from the "Works in Progress" folder. The function is not
available in the official release.

You need to actually get a page of options quotes from the site to create
the proper security cookie.

On Tue, Jun 5, 2012 at 12:21 AM, 仁 王 <id123.id123@yahoo.com.cn> wrote:

>
> Thank you so much for your help. I've tried the smfGet888OptionQuote().
> I got a #Name Error
> =smfGet888OptionQuote("SPY","C",DATE(2012,6,8),116,"s") . How can I create
> a security cookie ? I've visit the webpage
> http://www.optionseducation.org/quotes.html?quote=SPY. I also log in this
> website with IE. What else should I do?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (6)
7e.

Re: How to get greek letter of put option and Error of smfGetOXOptio

Posted by: "仁 王" id123.id123@yahoo.com.cn   id123.id123

Tue Jun 5, 2012 1:11 am (PDT)



Thanks again!

Upon your instruction, I can get the strike price 
=smfGet888OptionQuote("SPY","C",DATE(2012,6,8),123,"s")
However, this function is still Error
=smfGet888OptionQuote("SPY","C",DATE(2012,6,8),123,"b") ?
I got the page of SPY and  logged in.

ZX

--- 12年6月5日，周二, Randy Harmelink <rharmelink@gmail.com> 写道：

发件人: Randy Harmelink <rharmelink@gmail.com>
主题: Re: [smf_addin] How to get greek letter of put option and Error of smfGetOXOptionQuote()
收件人: smf_addin@yahoogroups.com
日期: 2012年6月5日,周二,下午3:36

 

If you're getting #NAME?, then you probably didn't install the beta version of the add-in from the "Works in Progress" folder. The function is not available in the official release.

You need to actually get a page of options quotes from the site to create the proper security cookie.

On Tue, Jun 5, 2012 at 12:21 AM, 仁 王 <id123.id123@yahoo.com.cn> wrote:

  Thank you so much for your help. I've tried the 
smfGet888OptionQuote(). I got a #Name Error =smfGet888OptionQuote("SPY","C",DATE(2012,6,8),116,"s") . How can I 
create a security cookie ?  I've visit the webpage http://www.optionseducation.org/quotes.html?quote=SPY. I also log in this website with IE. What else should I do?

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

Re: How to get greek letter of put option and Error of smfGetOXOptio

Posted by: "仁 王" id123.id123@yahoo.com.cn   id123.id123

Tue Jun 5, 2012 1:16 am (PDT)



Thanks again!

Upon your instruction, I can get the strike price 
=smfGet888OptionQuote("SPY","C",DATE(2012,6,8),123,"s")
However, this function is still Error
=smfGet888OptionQuote("SPY","C",DATE(2012,6,8),123,"b") ?
I got the page of SPY and  logged in.

ZX

--- 12年6月5日，周二, Randy Harmelink <rharmelink@gmail.com> 写道：

发件人: Randy Harmelink <rharmelink@gmail.com>
主题: Re: [smf_addin] How to get greek letter of put option and Error of smfGetOXOptionQuote()
收件人: smf_addin@yahoogroups.com
日期: 2012年6月5日,周二,下午3:36

 

If you're getting #NAME?, then you probably didn't install the beta version of the add-in from the "Works in Progress" folder. The function is not available in the official release.

You need to actually get a page of options quotes from the site to create the proper security cookie.

On Tue, Jun 5, 2012 at 12:21 AM, 仁 王 <id123.id123@yahoo.com.cn> wrote:

  Thank you so much for your help. I've tried the 
smfGet888OptionQuote(). I got a #Name Error =smfGet888OptionQuote("SPY","C",DATE(2012,6,8),116,"s") . How can I 
create a security cookie ?  I've visit the webpage http://www.optionseducation.org/quotes.html?quote=SPY. I also log in this website with IE. What else should I do?

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (6)
Recent Activity
Visit Your Group
Yahoo! Finance

It's Now Personal

Guides, news,

advice & more.

Need traffic?

Drive customers

With search ads

on Yahoo!

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 01.18

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)