Messages In This Digest (25 Messages)
- 1a.
- Re: Quotes on Stock Options including Greeks From: swiftyjpowell
- 1b.
- Re: Quotes on Stock Options including Greeks From: swiftyjpowell
- 1c.
- Re: Quotes on Stock Options including Greeks From: swiftyjpowell
- 1d.
- Re: Quotes on Stock Options including Greeks From: Randy Harmelink
- 1e.
- Re: Quotes on Stock Options including Greeks From: swiftyjpowell
- 1f.
- Re: Quotes on Stock Options including Greeks From: swiftyjpowell
- 1g.
- Re: Quotes on Stock Options including Greeks From: Randy Harmelink
- 1h.
- Re: Quotes on Stock Options including Greeks From: swiftyjpowell
- 1i.
- Re: Quotes on Stock Options including Greeks From: Randy Harmelink
- 1j.
- Re: Quotes on Stock Options including Greeks From: swiftyjpowell
- 1k.
- Re: Quotes on Stock Options including Greeks From: Randy Harmelink
- 2a.
- RCHGetYahooHistory for large number of stocks From: Michael Thomas
- 2b.
- Re: RCHGetYahooHistory for large number of stocks From: Randy Harmelink
- 3a.
- dividends From: Mike
- 3b.
- Re: dividends From: Randy Harmelink
- 3c.
- Re: dividends From: Mike S
- 3d.
- Re: dividends From: Mike S
- 4a.
- Please help!! From: siamees
- 4b.
- Re: Please help!! From: Randy Harmelink
- 4c.
- Re: Please help!! From: siamees
- 4d.
- Re: Please help!! From: Randy Harmelink
- 4e.
- Re: Please help!! From: siamees
- 4f.
- Re: Please help!! From: Randy Harmelink
- 5a.
- able to get chart off website using the plugin? From: wu_ming_sg
- 5b.
- Re: able to get chart off website using the plugin? From: Randy Harmelink
Messages
- 1a.
-
Re: Quotes on Stock Options including Greeks
Posted by: "swiftyjpowell" telework@live.com swiftyjpowell
Tue Aug 16, 2011 11:05 am (PDT)
Does anyone have updated info on what we should be entering currently for the options ticker symbol? I looked at some of the VB code but don't understand what should be entered here.
I simply need to populate a single cell with the Options Delta.
The other issue I have run into is that many of the formulas require editing of the formula for ticker symbol, expiration date, ask/bid, etc. instead of allowing a cell reference. Is there any solution to this?
Thanks,
Josh
- 1b.
-
Re: Quotes on Stock Options including Greeks
Posted by: "swiftyjpowell" telework@live.com swiftyjpowell
Tue Aug 16, 2011 11:16 am (PDT)
What I'm looking for is an update to the following formula so that it will work with the current options symbol format.
=RCHGetTableCell("https://www. optionsxpress. ",6,".DIWBK"com/OXNetTools/ Chains/index. aspx?Symbol= IWM&ChainType= 3&Range=0& lstMonths= 2/20/2010; 1 )
Ie. the ".DIWBK" is no longer a valid format but I cannot figure out what to replace it with.
If someone can post the correct formula it would be much appreciated.
Thanks,
Josh
- 1c.
-
Re: Quotes on Stock Options including Greeks
Posted by: "swiftyjpowell" telework@live.com swiftyjpowell
Tue Aug 16, 2011 11:48 am (PDT)
I really want to pull down an entire table including greeks but I still don't understand how to implement the following formula. When I enter it into a cell it simply returns "Last".
RCHGetHTMLTable("https://www. optionsxpress. ",">OpInt",-com/OXNetTools/ Chains/index. aspx?Symbol= aapl&ChainType= 0&Range=10& lstMonths= 9/17/2011; 1 1,"",2)
I want to easily pull down a table like the one Miguel has except I need it to include the Delta as well.
Any help greatly appreciated!
Josh
--- In smf_addin@yahoogroups.com , MIGUEL ANGEL GONZALEZ <spectratecharchitecture@... > wrote:
>
> I COULD KISS YOU IF I WEREN'T STRAIGHT!!, THANKS[?]
>
> On Sat, Jul 30, 2011 at 6:21 PM, Randy Harmelink <rharmelink@...>wrote:
>
> > **
> >
> >
> > The value you have in J7 *IS* 345. You just have it formatted as 345.00.
> > Values and formats are two separate attributes of a cell.
> >
> > You need to format it in you formula as well. Try:
> >
> > TEXT(J7,"0.00")
> >
> > However, note that a strike price alone is a very poor choice for a search
> > string. If the underlying equity has a last price, a bid price, or an ask
> > price of that, THAT is the search string you will find. I key off of the URL
> > for the option, since that will be more likely to be unique, and then go
> > backwards from the end of the row. For example:
> >
> > =RCHGetTableCell("
> > https://www.optionsxpress. com/OXNetTools/ Chains/index. aspx?Symbol= aapl&ChainType= 0&Range=10& lstMonths= 9/17/2011; 1
> > ",-6,TEXT(1000*J7,"C00000000" ))
> >
> > But if you want the whole table, why not:
> >
> > RCHGetHTMLTable("
> > https://www.optionsxpress. com/OXNetTools/ Chains/index. aspx?Symbol= aapl&ChainType= 0&Range=10& lstMonths= 9/17/2011; 1
> > ",">OpInt",-1,"",2)
> >
> > Then you don't have to worry if prices increment by $1, $2.50, or $5.
> >
> > Or just use the RCHGetTableCell() and increment the rows and columns as
> > necessary to get the whole table.
> >
> >
> > On Sat, Jul 30, 2011 at 5:05 PM, MIGUEL ANGEL GONZALEZ <
> > spectratecharchitecture@...> wrote:
> >
> >>
> >> I managed to make the formula read the value in the cell that i wanted,
> >> see the formula below...
> >>
> >> =RCHGetTableCell("
> >> https://www.optionsxpress. com/OXNetTools/ Chains/index. aspx?Symbol= aapl&ChainType= 0&Range=10& lstMonths= 9/17/2011; 1
> >> ",4,"*" & J7 & "*")
> >>
> >> ...by entering the extra *" & J7 & "* into the formula, i got it to read
> >> the value. I have one more problem, the value that i placed in cell J7 is
> >> *345.00*, no matter how i enter it, as a number or as text, the formula
> >> bar picks it up as *345*. I need it to pick up the *345.00*
> >> *
> >> *
> >> just to let you know what im trying to do, the chains on OXnettools are
> >> not as streaming as the real OX account, but they are definately more
> >> streaming that anything i've found elsewhere. Everytime i open the excel
> >> sheet, new options prices are shown, i can use the forcerecalulation
> >> fucntion like you said before. What i want to work on now is a way of
> >> filling out this option chains sheet by just entering in one strike price
> >> via an input box. The strike column will have formulas like strikeprice + 5
> >> or strikeprice - 5. Then each row will fill itself out by looking a the
> >> strike price in their row.
> >>
> >> Right now I would have to go to every strike price and manually fill in
> >> the strikes (i.e. 345.00, 350.00, 355.00) in the formula and then go to each
> >> column and change the number of cells to look away from that strike value
> >> (i.e. -17, -16, -15, -14....... 2, 3, 4,). If i can get the formula bar to
> >> pick up a 345.00 value and not a 340 value i think i can take it from there.
> >> I appreciate your help. I looked everywhere for this answer and just ended
> >> up coming back here for help.
> >>
> >
> >
> >
>
>
>
> --
> Miguel Angel Gonzalez
> SpectraTech Systems
> President/Owner
> (915)345-5668
>
- 1d.
-
Re: Quotes on Stock Options including Greeks
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Tue Aug 16, 2011 12:32 pm (PDT)
Just use the smfGetOptionQuotes() function.
Google EXCEL string concatenation and you'll learn how to combine strings
and cells. It's basically something like:
"...string1..." & B1 & "...string2. .."
On Tue, Aug 16, 2011 at 11:05 AM, swiftyjpowell <telework@live.com > wrote:
> Does anyone have updated info on what we should be entering currently for
> the options ticker symbol? I looked at some of the VB code but don't
> understand what should be entered here.
>
> I simply need to populate a single cell with the Options Delta.
>
> The other issue I have run into is that many of the formulas require
> editing of the formula for ticker symbol, expiration date, ask/bid, etc.
> instead of allowing a cell reference. Is there any solution to this?
>
- 1e.
-
Re: Quotes on Stock Options including Greeks
Posted by: "swiftyjpowell" telework@live.com swiftyjpowell
Tue Aug 16, 2011 1:00 pm (PDT)
Randy, at this point I would much prefer to simply get the formula I mentioned working properly. I have everything built just how I need it and I am pulling all of the data properly except for the Delta information.
If I substitute the symbol with the strike price I can get it to pull data in but I cannot seem to get the chaintype & range correct to isolate the delta information.
Could you possible suggest the proper changes to the following formula that would point it to the Delta?
=RCHGetTableCell("https://www. optionsxpress. ",2,TEXT(1000*com/OXNetTools/ Chains/index. aspx?Symbol= SPY&ChainType= 3&Range=0& lstMonths= 9/17/2010; 1 H7,"C00000000" ))
- 1f.
-
Re: Quotes on Stock Options including Greeks
Posted by: "swiftyjpowell" telework@live.com swiftyjpowell
Tue Aug 16, 2011 1:03 pm (PDT)
I think what I actually need is the chaintype that will point to the "Delta & Implied Volatility" page so that I can pull both Call and Put data.
--- In smf_addin@yahoogroups.com , "swiftyjpowell" <telework@...> wrote:
>
> Randy, at this point I would much prefer to simply get the formula I mentioned working properly. I have everything built just how I need it and I am pulling all of the data properly except for the Delta information.
>
> If I substitute the symbol with the strike price I can get it to pull data in but I cannot seem to get the chaintype & range correct to isolate the delta information.
>
> Could you possible suggest the proper changes to the following formula that would point it to the Delta?
>
> =RCHGetTableCell("https://www. optionsxpress. ",2,TEXT(1000*com/OXNetTools/ Chains/index. aspx?Symbol= SPY&ChainType= 3&Range=0& lstMonths= 9/17/2010; 1 H7,"C00000000" ))
>
- 1g.
-
Re: Quotes on Stock Options including Greeks
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Tue Aug 16, 2011 1:27 pm (PDT)
You're going to need to change the expiration date in the URL as well. Plus,
since they usually have the weekly options listed along with the current
month, you're also going to need to include the expiration date portion in
the search string as well.
For example, to get the delta for expiration date 2011-09-17:
=RCHGetTableCell("
https://www.optionsxpress. com/OXNetTools/ Chains/index. aspx?Symbol= SPY&ChainType= 3&Range=0& lstMonths= 9/17/2011; 1
",4,"110917"&TEXT(1000* C4,"C00000000" ))
Or, to get it from the "Delta and Implied Volatility" page (different
"ChainType"):
=RCHGetTableCell("
https://www.optionsxpress. com/OXNetTools/ Chains/index. aspx?Symbol= SPY&ChainType= 14&Range= 0&lstMonths= 9/17/2011; 1
",3,"110917"&TEXT(1000* $C4,"C00000000" ))
To me, it's so much easier to just use either:
=smfGetOptionQuotes("SPY Sep 2011 $119 Call","5",," OX")
=smfGetOptionQuotes("SPY Sep 2011 $119 Call","5",," OX2")
Or, if your ticker, expiration date, strike price, and "Call" or "Put" are
in worksheet cells, just use:
=smfGetOptionQuotes(C9&" "&TEXT(D9,"mm/ dd yyyy ")&TEXT(E9," $0
")&F9,"5",,"OX")
...which means you could easily create a table where you can modify any
item:
Ticker Date Strike Type Delta SPY 2011-09-17 $119 Call 0.5432 SPY
2011-09-17 $120 Call 0.5065
On Tue, Aug 16, 2011 at 1:00 PM, swiftyjpowell <telework@live.com > wrote:
> Randy, at this point I would much prefer to simply get the formula I
> mentioned working properly. I have everything built just how I need it and I
> am pulling all of the data properly except for the Delta information.
>
> If I substitute the symbol with the strike price I can get it to pull data
> in but I cannot seem to get the chaintype & range correct to isolate the
> delta information.
>
> Could you possible suggest the proper changes to the following formula that
> would point it to the Delta?
>
> =RCHGetTableCell("
> https://www.optionsxpress. com/OXNetTools/ Chains/index. aspx?Symbol= SPY&ChainType= 3&Range=0& lstMonths= 9/17/2010; 1
> ",2,TEXT(1000*H7,"C00000000" ))
>
- 1h.
-
Re: Quotes on Stock Options including Greeks
Posted by: "swiftyjpowell" telework@live.com swiftyjpowell
Tue Aug 16, 2011 8:01 pm (PDT)
Randy, thanks so much for taking the time to share your knowledge. For now I'm using the following which is working for what I need.
=RCHGetTableCell("https://www. optionsxpress. ",12,TEXT(1000*com/OXNetTools/ Chains/index. aspx?Symbol= iwm&Range= All&lstMarket= 0&ChainType= 14&lstMonths= 9/17/2011; 1 H6,"C00000000" ))
smfGetOptionQuotes is obviously much more flexible and will allow me to reference cells with the symbol and date, etc. So I will implement this when I have time.
Thanks again,
Josh
- 1i.
-
Re: Quotes on Stock Options including Greeks
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Tue Aug 16, 2011 8:28 pm (PDT)
Just keep in mind that if you try to get the front-month expiration with
that formula on an equity with weekly options, you'll get the weekly quote,
not the monthly quote. Right now it doesn't matter, because the monthly *is*
the weekly.
On Tue, Aug 16, 2011 at 8:01 PM, swiftyjpowell <telework@live.com > wrote:
> Randy, thanks so much for taking the time to share your knowledge. For now
> I'm using the following which is working for what I need.
>
> =RCHGetTableCell("
> https://www.optionsxpress. com/OXNetTools/ Chains/index. aspx?Symbol= iwm&Range= All&lstMarket= 0&ChainType= 14&lstMonths= 9/17/2011; 1
> ",12,TEXT(1000*H6,"C00000000" ))
>
> smfGetOptionQuotes is obviously much more flexible and will allow me to
> reference cells with the symbol and date, etc. So I will implement this when
> I have time.
>
- 1j.
-
Re: Quotes on Stock Options including Greeks
Posted by: "swiftyjpowell" telework@live.com swiftyjpowell
Tue Aug 16, 2011 9:17 pm (PDT)
I decided to go ahead and implement and it's working quite well except
for an error pulling the Put Delta from OX. I actually got the same
error with several of the Put fields but was able to pull them from OX2
or Y instead. However Delta is only available from OX.
The error is "Invalid Put/Call indicator (must be a C): P". Would you
mind taking a quick look to see if there is an error in the code? File
attached.
Option Sizing Spreadsheet
<http://dl.dropbox.com/u/2702133/ >Option%20Sizing. xlsm
Josh
- 1k.
-
Re: Quotes on Stock Options including Greeks
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Tue Aug 16, 2011 9:34 pm (PDT)
As noted in the documentation, data source "OX" only gets greeks for calls,
no puts. I haven't found a bookmarkable URL for the puts. Delta should be
available for the puts from data source "OX2".
Check the documentation grid to see which fields are available from which
sources.
On Tue, Aug 16, 2011 at 9:17 PM, swiftyjpowell <telework@live.com > wrote:
>
> I decided to go ahead and implement and it's working quite well except for
> an error pulling the Put Delta from OX. I actually got the same error with
> several of the Put fields but was able to pull them from OX2 or Y instead.
> However Delta is only available from OX.
>
> The error is "Invalid Put/Call indicator (must be a C): P". Would you
> mind taking a quick look to see if there is an error in the code?
>
- 2a.
-
RCHGetYahooHistory for large number of stocks
Posted by: "Michael Thomas" thomas91112@yahoo.com thomas91112
Tue Aug 16, 2011 11:11 am (PDT)
Would like to use the subject add-in to retrieve 10 years of historical month-end prices for nearly 100 stocks. Is there a way to enter the stock symbols and start dates across the top of my Excel spreadsheet and then copy the add-in so I don't have to enter it 100 times?
ThanksMike T. - 2b.
-
Re: RCHGetYahooHistory for large number of stocks
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Tue Aug 16, 2011 12:33 pm (PDT)
Why would you copy the add-in? Just copy the formula...
On Tue, Aug 16, 2011 at 11:11 AM, Michael Thomas <thomas91112@yahoo.com >wrote:
>
> Would like to use the subject add-in to retrieve 10 years of historical
> month-end prices for nearly 100 stocks. Is there a way to enter the stock
> symbols and start dates across the top of my Excel spreadsheet and then copy
> the add-in so I don't have to enter it 100 times?
>
- 3a.
-
dividends
Posted by: "Mike" mikesadd@hotmail.com morpheusca8
Tue Aug 16, 2011 12:27 pm (PDT)
Yahoo doesnt post the dividend yield for some of the stocks i follow. Is there a way to pull them off of msn money or google instead??
- 3b.
-
Re: dividends
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Tue Aug 16, 2011 12:33 pm (PDT)
You could probably use either the RCHGetTableCell() or smfGetTagContent( )
functions to extract the data from another source.
On Tue, Aug 16, 2011 at 12:03 PM, Mike <mikesadd@hotmail.com > wrote:
> Yahoo doesnt post the dividend yield for some of the stocks i follow. Is
> there a way to pull them off of msn money or google instead??
>
- 3c.
-
Re: dividends
Posted by: "Mike S" mikesadd@hotmail.com morpheusca8
Tue Aug 16, 2011 12:44 pm (PDT)
i am in no way an excel guru.....i did manage to get an excel array setup that would take the yahoo values that i wanted for the stocks i follow.
Is there some kind of turtorial for the RCHGetTableCell() function..?? ?
Thanks in advance
mike
To: smf_addin@yahoogroups.com
From: rharmelink@gmail.com
Date: Tue, 16 Aug 2011 12:33:58 -0700
Subject: Re: [smf_addin] dividends
You could probably use either the RCHGetTableCell() or smfGetTagContent( ) functions to extract the data from another source.
On Tue, Aug 16, 2011 at 12:03 PM, Mike <mikesadd@hotmail.com > wrote:
Yahoo doesnt post the dividend yield for some of the stocks i follow. Is there a way to pull them off of msn money or google instead??
- 3d.
-
Re: dividends
Posted by: "Mike S" mikesadd@hotmail.com morpheusca8
Tue Aug 16, 2011 12:46 pm (PDT)
never mind...found some docs...under docs.....lol
From: mikesadd@hotmail.com
To: smf_addin@yahoogroups.com
Subject: RE: [smf_addin] dividends
Date: Tue, 16 Aug 2011 15:44:04 -0400
i am in no way an excel guru.....i did manage to get an excel array setup that would take the yahoo values that i wanted for the stocks i follow.
Is there some kind of turtorial for the RCHGetTableCell() function..?? ?
Thanks in advance
mike
To: smf_addin@yahoogroups.com
From: rharmelink@gmail.com
Date: Tue, 16 Aug 2011 12:33:58 -0700
Subject: Re: [smf_addin] dividends
You could probably use either the RCHGetTableCell() or smfGetTagContent( ) functions to extract the data from another source.
On Tue, Aug 16, 2011 at 12:03 PM, Mike <mikesadd@hotmail.com > wrote:
Yahoo doesnt post the dividend yield for some of the stocks i follow. Is there a way to pull them off of msn money or google instead??
- 4a.
-
Please help!!
Posted by: "siamees" siamees@yahoo.com siamees
Tue Aug 16, 2011 12:28 pm (PDT)
Hello,
I'm sorry. I have searched and tried but I can't get it to work. First I
downloaded the zip file and extracted it into the folder C:\Program
Files\SMF Add-In\RCH_Stock_Market_Functions -2.1.2010. 08.02
Then I installed the Add-In in my Excel 2010.
But now? I dont know what to do next. I want to create a excell sheet
that gives me this data that I allready found on the forum. But I don't
know how of where to implement this in excel.
   Case "Magic Formula Investing -- Earnings Yield"
        n1 =
RCHGetElementNumber(pTicker, 949)Â Â Â ' Enterprise value to
EBITDA
        RCHSpecialExtraction = 1 / n1
   Case "Magic Formula Investing -- Return on Capital"
        n1 =
RCHGetElementNumber(pTicker, 960)Â Â Â ' EBITDA
        n2 =
RCHGetElementNumber(pTicker, 964)Â Â Â ' Cash
        n3 =
RCHGetElementNumber(pTicker, 10026)Â ' FQ1, Net Fixed Assets (Plant
& Equipment)
        RCHSpecialExtraction = n1 / (n2
+ 1000 * n3)
Thank you very much!!!!
Olivier
- 4b.
-
Re: Please help!!
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Tue Aug 16, 2011 12:37 pm (PDT)
Those are elements. Take a look at the element definition XLS that was
distributed with the add-in. It has a list of the defined elements that are
available for the RCHGetElementNumber() function.
Your folder name below is not correct. You will end up having to resolve
links in all workbooks created by anyone else.
The installation instructions do give you some paths for what to do next.
On Tue, Aug 16, 2011 at 11:14 AM, siamees <siamees@yahoo.com > wrote:
> I'm sorry. I have searched and tried but I can't get it to work. First I
> downloaded the zip file and extracted it into the folder C:\Program
> Files\SMF Add-In\RCH_Stock_Market_Functions -2.1.2010. 08.02
>
> Then I installed the Add-In in my Excel 2010.
>
> But now? I dont know what to do next. I want to create a excell sheet that
> gives me this data that I allready found on the forum. But I don't know how
> of where to implement this in excel.
>
> Â Â Â Case "Magic Formula Investing -- Earnings Yield"
> Â Â Â Â Â Â Â Â n1 = RCHGetElementNumber(pTicker, 949)Â Â Â ' Enterprise
> value to EBITDA
> Â Â Â Â Â Â Â Â RCHSpecialExtraction = 1 / n1
> Â Â Â Case "Magic Formula Investing -- Return on Capital"
> Â Â Â Â Â Â Â Â n1 = RCHGetElementNumber(pTicker, 960)Â Â Â ' EBITDA
> Â Â Â Â Â Â Â Â n2 = RCHGetElementNumber(pTicker, 964)Â Â Â ' Cash
> Â Â Â Â Â Â Â Â n3 = RCHGetElementNumber(pTicker, 10026)Â ' FQ1, Net
> Fixed Assets (Plant & Equipment)
> Â Â Â Â Â Â Â Â RCHSpecialExtraction = n1 / (n2 + 1000 * n3)
>
> Thank you very much!!!!
>
> Olivier
>
- 4c.
-
Re: Please help!!
Posted by: "siamees" siamees@yahoo.com siamees
Tue Aug 16, 2011 11:44 pm (PDT)
What is the correct folder name where I have to unzip the FLA file?
As long as I enter for example the formula '=RCHGetElementNumber("IBM", 941)' and excell says that the formula is wrong the add-in isn't correctly installed right? Normally if the add-in was correctly installed this formula should work?
thank you!
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Those are elements. Take a look at the element definition XLS that was
> distributed with the add-in. It has a list of the defined elements that are
> available for the RCHGetElementNumber() function.
>
> Your folder name below is not correct. You will end up having to resolve
> links in all workbooks created by anyone else.
>
> The installation instructions do give you some paths for what to do next.
>
> On Tue, Aug 16, 2011 at 11:14 AM, siamees <siamees@...> wrote:
>
> > I'm sorry. I have searched and tried but I can't get it to work. First I
> > downloaded the zip file and extracted it into the folder C:\Program
> > Files\SMF Add-In\RCH_Stock_Market_Functions -2.1.2010. 08.02
> >
> > Then I installed the Add-In in my Excel 2010.
> >
> > But now? I dont know what to do next. I want to create a excell sheet that
> > gives me this data that I allready found on the forum. But I don't know how
> > of where to implement this in excel.
> >
> > Â Â Â Case "Magic Formula Investing -- Earnings Yield"
> > Â Â Â Â Â Â Â Â n1 = RCHGetElementNumber(pTicker, 949)Â Â Â ' Enterprise
> > value to EBITDA
> > Â Â Â Â Â Â Â Â RCHSpecialExtraction = 1 / n1
> > Â Â Â Case "Magic Formula Investing -- Return on Capital"
> > Â Â Â Â Â Â Â Â n1 = RCHGetElementNumber(pTicker, 960)Â Â Â ' EBITDA
> > Â Â Â Â Â Â Â Â n2 = RCHGetElementNumber(pTicker, 964)Â Â Â ' Cash
> > Â Â Â Â Â Â Â Â n3 = RCHGetElementNumber(pTicker, 10026)Â ' FQ1, Net
> > Fixed Assets (Plant & Equipment)
> > Â Â Â Â Â Â Â Â RCHSpecialExtraction = n1 / (n2 + 1000 * n3)
> >
> > Thank you very much!!!!
> >
> > Olivier
> >
>
- 4d.
-
Re: Please help!!
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Tue Aug 16, 2011 11:52 pm (PDT)
As per the documentation: C:\Program Files\SMF Add-In
If you are getting a #NAME! error with that function, you don't have the
add-in installed properly. The best test of installation:
=RCHGetElementNumber("Version" )
On Tue, Aug 16, 2011 at 11:44 PM, siamees <siamees@yahoo.com > wrote:
> What is the correct folder name where I have to unzip the FLA file?
> As long as I enter for example the formula
> '=RCHGetElementNumber("IBM", 941)' and excell says that the formula is wrong
> the add-in isn't correctly installed right? Normally if the add-in was
> correctly installed this formula should work?
>
- 4e.
-
Re: Please help!!
Posted by: "siamees" siamees@yahoo.com siamees
Wed Aug 17, 2011 12:35 am (PDT)
OK, I installed the Add-In in the correct folder. Installed it using the options. Closed Excel and reopend it. And when I put in the formula =RCHGetElementNumber("Version" ) It says "Stock Market Functions add-in, Version 2.1.2010.08. 02". But every other formula it gives an error saying the formula is wrong and when I press OK it highligts everything between the ( ). What am I doing wrong?
Thank you!!
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> As per the documentation: C:\Program Files\SMF Add-In
>
> If you are getting a #NAME! error with that function, you don't have the
> add-in installed properly. The best test of installation:
>
> =RCHGetElementNumber("Version" )
>
> On Tue, Aug 16, 2011 at 11:44 PM, siamees <siamees@...> wrote:
>
> > What is the correct folder name where I have to unzip the FLA file?
> > As long as I enter for example the formula
> > '=RCHGetElementNumber("IBM", 941)' and excell says that the formula is wrong
> > the add-in isn't correctly installed right? Normally if the add-in was
> > correctly installed this formula should work?
> >
>
- 4f.
-
Re: Please help!!
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Wed Aug 17, 2011 12:40 am (PDT)
I can't tell based on your description. What is it saying is wrong with the
formula? The one you had before works fine here:
=RCHGetElementNumber("IBM",941)
Or, how about:
=RCHGetYahooQuotes("IBM","l1" )
On Wed, Aug 17, 2011 at 12:35 AM, siamees <siamees@yahoo.com > wrote:
> OK, I installed the Add-In in the correct folder. Installed it using the
> options. Closed Excel and reopend it. And when I put in the formula
> =RCHGetElementNumber("Version" ) It says "Stock Market Functions add-in,
> Version 2.1.2010.08.02". But every other formula it gives an error saying
> the formula is wrong and when I press OK it highligts everything between the
> ( ). What am I doing wrong?
>
- 5a.
-
able to get chart off website using the plugin?
Posted by: "wu_ming_sg" nghongchong@hotmail.com wu_ming_sg
Tue Aug 16, 2011 2:59 pm (PDT)
Hi,
Is it possible to display chart from the websites such as http://www.google.com/finance? though the plugin?q=NASDAQ: AAPL&fstype= ii
Regards,
Hong
- 5b.
-
Re: able to get chart off website using the plugin?
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Wed Aug 17, 2011 1:21 am (PDT)
You can display some images in EXCEL by using the RCHCreateComment()
function. However, EXCEL has a limitation of 99 bytes for the URL of an
image to insert, so the charts from the Google page wouldn't be possible.
On Tue, Aug 16, 2011 at 2:58 PM, wu_ming_sg <nghongchong@hotmail.com > wrote:
>
> Is it possible to display chart from the websites such as
> http://www.google.com/finance? though the plugin?q=NASDAQ: AAPL&fstype= ii
>
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