Messages In This Digest (5 Messages)
- 1a.
- Re: How to get greek letter of put option and Error of smfGetOXOptio From: Randy Harmelink
- 2a.
- Re: Error on RCHGetElementNumber-Template-AdvFN-Financial-Statements From: Jacob Jose
- 3a.
- Re: ELEMENT FUNCTION LIST-1 From: Randy H
- 4a.
- Daily Prices and TTM Ratio Chart From: invesco88
- 4b.
- Re: Daily Prices and TTM Ratio Chart From: Randy Harmelink
Messages
- 1a.
-
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 3:29 am (PDT)
Both formulas work fine here. Try the smfForceRecalculation macro (see
LINKS area of the group for more info), as you may have saved a copy of the
web page before you were logged in, which would not contain the data you
need and cause the function to return an error.
Another option would be to get a quote using the EXCEL Web Query dialog, as
the version of IE EXCEL uses may be different than what you are using as a
browser.
On Tue, Jun 5, 2012 at 1:11 AM, ไป ็ <id123.id123@yahoo.com. > wrote:cn
>
> 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.
>
- 2a.
-
Re: Error on RCHGetElementNumber-Template-AdvFN-Financial-Statements
Posted by: "Jacob Jose" pepecan47@yahoo.ca pepecan47
Tue Jun 5, 2012 7:47 am (PDT)
Randy, thx a lot.. it works perfectly now.
Regards,
Jose L. Jacob
_____________________ _________ __
From: Randy Harmelink <rharmelink@gmail.com >
To: smf_addin@yahoogroups.com
Sent: Tuesday, June 5, 2012 12:35:17 AM
Subject: Re: [smf_addin] Error on RCHGetElementNumber-Template- AdvFN-Financial- Statements. xls
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
>
- 3a.
-
Re: ELEMENT FUNCTION LIST-1
Posted by: "Randy H" rharmelink@gmail.com rharmelink
Tue Jun 5, 2012 12:50 pm (PDT)
What do you get for the following:
=RCHGetElementNumber("Version" )
=smfGetAParms(27)
=RCHGetElementNumber("MMM",27)
PS: Please keep all add-in related queries on this forum. I found your
message sent to me in my SPAM folder and could easily have deleted it
without ever seeing it.
On Tue, Jun 5, 2012 at 12:24 PM, David Nicholas <ufdn16@...
<mailto:ufdn16@yahoo.com > > wrote:
I imported the new element file found in work in process and extracted
it into programs/smf_addin folder.I have an excel worksheet that is
populated with all sorts of data. Generally , very pleased.However, I
just don't get it: code 25, 27,28,29 return error. I saw in another
email that someone did the samething I did and was getting the price but
it wasn't current.I don't even get that. Please explain how I can get
the info I want. Thanks! David
- 4a.
-
Daily Prices and TTM Ratio Chart
Posted by: "invesco88" franklin.forward@gmail.com invesco88
Tue Jun 5, 2012 5:09 pm (PDT)
I'm trying to duplicate the chart below in excel using ADVfin quarterly
data and an import of Yahoo daily historical prices for a stock. The
problem I'm running into is that I have two sets of data with different
frequencies (daily prices and quarterly per share data) and I can't seem
to get the daily change in the TTM ratio without manually copy/pasting,
which isn't useful if you have to enter a different ticker with
different quarterly dates. Does anyone have a solution for this? Ideally
it would be easiest to use the RCHCreateComment function to pull it from
a site that has this data available for free but I haven't found a site
that has the daily Price/FCF TTM for free so I'm trying to build this
into my valuation model. Thanks Randy for the Add-in, it's a life saver.
- 4b.
-
Re: Daily Prices and TTM Ratio Chart
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Tue Jun 5, 2012 5:55 pm (PDT)
I would retrieve the FCF TTM and the posting date of same, then just align
it up with the daily quotes. You should just be able to do a
MATCH()/INDEX() or VLOOKUP() to find which FCF TTM applies to which
historical quotes dates.
On Tue, Jun 5, 2012 at 5:09 PM, invesco88 <franklin.forward@gmail.com >wrote:
>
> I'm trying to duplicate the chart below in excel using ADVfin quarterly
> data and an import of Yahoo daily historical prices for a stock. The
> problem I'm running into is that I have two sets of data with different
> frequencies (daily prices and quarterly per share data) and I can't seem to
> get the daily change in the TTM ratio without manually copy/pasting, which
> isn't useful if you have to enter a different ticker with different
> quarterly dates. Does anyone have a solution for this? Ideally it would be
> easiest to use the RCHCreateComment function to pull it from a site that
> has this data available for free but I haven't found a site that has the
> daily Price/FCF TTM for free so I'm trying to build this into my valuation
> model. Thanks Randy for the Add-in, it's a life saver.
>
Need to Reply?
Click one of the "Reply" links to respond to a specific message in the Daily Digest.
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Individual | Switch format to Traditional
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe
Tidak ada komentar:
Posting Komentar