7 New Messages
Digest #2403
Messages
Sat Nov 17, 2012 7:01 am (PST) . Posted by:
"Ron Spruell" hashky
Michael -
I couldn't get the links to work.
Ron Spruell
>________________________________
> From: Michael McIntyre <michaelmcintyre2000@yahoo.com >
>To: "smf_addin@yahoogroups.com " <smf_addin@yahoogroups.com >
>Sent: Friday, November 16, 2012 6:19 PM
>Subject: Re: [smf_addin] help getting started
>
>
>
>In addition, take a look in the Files section for:
>
>Message-2281-Yahoo-Options-Calls-and-Puts.xls
>Message-2281-Yahoo-Options.xls
>
>Also, you'll need to know the strike increments in each case (or use the ITM/OTM parameters.)
>
>
>But as Randy mentioned, pulling 200 quotes with multiple option data will require quite a bit of patience.
>
>
>From: bsmth12 <bsmth12@yahoo.com >
>To: smf_addin@yahoogroups.com
>Sent: Friday, November 16, 2012 12:59 PM
>Subject: [smf_addin] help getting started
>
>
>Does anyone have a template for this, or something close:
>____
>
>I want to open a spreadsheet, enter stock symbols (up to 200?)
>
>Hit a "download data" button, and it grabs stock and Options data from either yahoo or google feed, does simple calculations and displays updated data in cells.
>
>I'm looking to input Call and Put prices into the spreadsheet, within a certain range of the current share price, at all the available expiration months. I'll use that data as inputs into formulas contained in other cells, and the results of the calculation gets displayed in another cell.
>
>___
>
>I tried to figure it out but I couldn't get far, I'm looking through the documentation and it seems to be aimed at people who already know what they're doing and just need the specifics. I'm at a basic level, what do I read up on to be able to make a sheet like that, is this "excel programming"
?
>
>Thanks,
>
>
>
>
>
I couldn't get the links to work.
Ron Spruell
>___________
> From: Michael McIntyre <michaelmcintyre2000
>To: "smf_addin@yahoogrou
>Sent: Friday, November 16, 2012 6:19 PM
>Subject: Re: [smf_addin] help getting started
>
>
>
>In addition, take a look in the Files section for:
>
>Message-2281-
>Message-2281-
>
>Also, you'll need to know the strike increments in each case (or use the ITM/OTM parameters.)
>
>
>But as Randy mentioned, pulling 200 quotes with multiple option data will require quite a bit of patience.
>
>
>From: bsmth12 <bsmth12@yahoo.
>To: smf_addin@yahoogrou
>Sent: Friday, November 16, 2012 12:59 PM
>Subject: [smf_addin] help getting started
>
>
>Does anyone have a template for this, or something close:
>____
>
>I want to open a spreadsheet, enter stock symbols (up to 200?)
>
>Hit a "download data" button, and it grabs stock and Options data from either yahoo or google feed, does simple calculations and displays updated data in cells.
>
>I'm looking to input Call and Put prices into the spreadsheet, within a certain range of the current share price, at all the available expiration months. I'll use that data as inputs into formulas contained in other cells, and the results of the calculation gets displayed in another cell.
>
>___
>
>I tried to figure it out but I couldn't get far, I'm looking through the documentation and it seems to be aimed at people who already know what they're doing and just need the specifics. I'm at a basic level, what do I read up on to be able to make a sheet like that, is this "excel programming"
?
>
>Thanks,
>
>
>
>
>
Sat Nov 17, 2012 7:12 am (PST) . Posted by:
"Ron Spruell" hashky
I have a spreadsheet that pulls OTM1, OTM2, ITM1, ITM2, RSI, Percent of Bollinger Bands, Percent of the 52-wk Hi Lo spread, Return (Calls only), Annualized Return for 1 Option Expiry date.
I have 105 stocks presently. It takes 4 minutes to run. If you want I can clean up and post. I can do 200 stocks, but I would have time to eat lunch while it runs especially if you want all Expiry dates.
Ron Spruell
>________________________________
> From: bsmth12 <bsmth12@yahoo.com >
>To: smf_addin@yahoogroups.com
>Sent: Friday, November 16, 2012 2:59 PM
>Subject: [smf_addin] help getting started
>
>
>
>Does anyone have a template for this, or something close:
>____
>
>I want to open a spreadsheet, enter stock symbols (up to 200?)
>
>Hit a "download data" button, and it grabs stock and Options data from either yahoo or google feed, does simple calculations and displays updated data in cells.
>
>I'm looking to input Call and Put prices into the spreadsheet, within a certain range of the current share price, at all the available expiration months. I'll use that data as inputs into formulas contained in other cells, and the results of the calculation gets displayed in another cell.
>
>___
>
>I tried to figure it out but I couldn't get far, I'm looking through the documentation and it seems to be aimed at people who already know what they're doing and just need the specifics. I'm at a basic level, what do I read up on to be able to make a sheet like that, is this "excel programming" ?
>
>Thanks,
>
>
>
>
>
I have 105 stocks presently. It takes 4 minutes to run. If you want I can clean up and post. I can do 200 stocks, but I would have time to eat lunch while it runs especially if you want all Expiry dates.
Ron Spruell
>___________
> From: bsmth12 <bsmth12@yahoo.
>To: smf_addin@yahoogrou
>Sent: Friday, November 16, 2012 2:59 PM
>Subject: [smf_addin] help getting started
>
>
>
>Does anyone have a template for this, or something close:
>____
>
>I want to open a spreadsheet, enter stock symbols (up to 200?)
>
>Hit a "download data" button, and it grabs stock and Options data from either yahoo or google feed, does simple calculations and displays updated data in cells.
>
>I'm looking to input Call and Put prices into the spreadsheet, within a certain range of the current share price, at all the available expiration months. I'll use that data as inputs into formulas contained in other cells, and the results of the calculation gets displayed in another cell.
>
>___
>
>I tried to figure it out but I couldn't get far, I'm looking through the documentation and it seems to be aimed at people who already know what they're doing and just need the specifics. I'm at a basic level, what do I read up on to be able to make a sheet like that, is this "excel programming" ?
>
>Thanks,
>
>
>
>
>
Sat Nov 17, 2012 11:43 am (PST) . Posted by:
"bsmth12" bsmth12
>
--- In smf_addin@yahoogroups.com , Ron Spruell <hashky@...> wrote:
>
> I have a spreadsheet that pulls OTM1, OTM2, ITM1, ITM2, RSI, Percent of Bollinger Bands, Percent of the 52-wk Hi Lo spread, Return (Calls only), Annualized Return for 1 Option Expiry date.Â
>
> I have 105 stocks presently. It takes 4 minutes to run. If you want I can clean up and post. I can do 200 stocks, but I would have time to eat lunch while it runs especially if you want all Expiry dates.
>
> Ron Spruell
I'm very interested, I'd really appreciate it if you posted that.
Whenever you have the chance, Thanks man,
--- In smf_addin@yahoogrou
>
> I have a spreadsheet that pulls OTM1, OTM2, ITM1, ITM2, RSI, Percent of Bollinger Bands, Percent of the 52-wk Hi Lo spread, Return (Calls only), Annualized Return for 1 Option Expiry date.Â
>
> I have 105 stocks presently. It takes 4 minutes to run. If you want I can clean up and post. I can do 200 stocks, but I would have time to eat lunch while it runs especially if you want all Expiry dates.
>
> Ron Spruell
I'm very interested, I'd really appreciate it if you posted that.
Whenever you have the chance, Thanks man,
Sat Nov 17, 2012 11:55 am (PST) . Posted by:
"bsmth12" bsmth12
--- In smf_addin@yahoogrou
>
> Take a look at the documentation for RCHGetYahooQuotes(
> smfGetOptionQuotes(
>
> These messages in the archives may be of help:
>
> http://finance.
> http://finance.
>
> The first is a step-by-step example of using RCHGetYahooQuotes(
> second contains a number of examples of using the various option functions
> that are available, in addition to smfGetOptionQuotes(
>
> Note that the LINKS area of the group has pointers to some FAQs and tips...
>
> However, getting a lot of options data on 200 stocks could make for a slow
> spreadsheet.
>
This page is very helpful, Thanks Randy,
http://finance.
Sat Nov 17, 2012 12:37 pm (PST) . Posted by:
"cdtrad123" cdtrad123
Another great example!
--- In smf_addin@yahoogroups.com , "Randy H" <rharmelink@...> wrote:
>
> The purpose of this exercise is not necessarily to create a useful
> template, but more to acquaint you with the various option functions
> available in the latest version of the add-in. I've uploaded a copy of
> the final workbook, after additional formatting was added. It can be
> found here:
>
> smfGetOptionQuotes-Example-Table-Building-Exercise.xls
> <http://finance.groups.yahoo.com/group/smf_addin/files/Requested%20Sampl\
> es/smfGetOptionQuotes-Example-Table-Building-Exercise.xls>
>
> Step 1
>
> Open up a new workbook. The first think we're going to do is create two
> basic input fields -- ticker symbol and data source. So, put these
> values in the designated cells:
>
> B2: IWM
> C2: <=== Ticker Symbol of Underlying Equity
> B3: OX
> C3: <=== Data Source to use for Retrieving Data
>
> Note that there are two spaces in front of the greater than sign in cell
> C2 and C3. These days, I typically use OX (i.e. OptionsXPress) as my
> data source. It is more comprehensive than the other data sources (i.e.
> Yahoo, Google, MSN), probably because their customers are actually
> trading the options, while the other data sources are just reporting
> quotes and data. However, of the data sources, OptionsXPress is the
> slowest one to retrieve data from. That's why I like to have this as an
> input field -- so I can easily toggle between data sources if I want to.
>
> Step 2
>
> Now we're going to create a table of five ITM and five OTM options for
> the underlying equity in cell B2. However, we need another input first
> -- an expiration date to use for the table. So, another input field is
> necessary:
>
> B5: =smfGetOptionExpiry()
> C5: <=== Option expiration to use for table below
> C8: Tickers
>
> The formula in cell B5 should return the next monthly expiration date.
> However, you can manually override that to be any valid expiration date.
> I'm just using the formula both to let you know it exists and to get a
> default value in the input field.for the rest of this exercise. Cell C8
> is just a a column heading.
>
> Step 3
>
> Now let's create some option ticker symbols for the strike prices --
> highlight cells C9:C18 and type in this formula:
>
> =smfGetOptionStrikes($B$2,$B$5,"Call",$B$3,1)
>
> ...and press Ctrl+Shift+Enter to array-enter that formula over the
> 10-row by 1-column range.
>
> The first parameter is our input ticker symbol. The second parameter is
> our input expiration date. The third parameter indicates whether we want
> strike prices for puts or calls, although they should be the same for a
> given expiration date. In this case, I chose to hard-code a value of
> "Call" instead of making it another input field. The fourth parameter is
> our input data source. The fifth parameter is telling the function to
> generate option symbols for smfGetOptionQuotes() functions for each
> strike price. If you leave this parameter off or set it to zero, the
> returned values would simply be the numeric strike prices.
>
> Because the formula was entered over a 10-row range, the function will
> return five ITM strikes and five OTM strike prices, or however many are
> available. If there are only three ITM strike prices, the first two
> cells will be left empty. The center of the range should always contain
> the first ITM and OTM strike prices.
>
> Step 4
>
> Now we're just going to put in a few item codes, just so the
> smfGetOptionQuotes() will actually retrieve something from that list of
> ticker symbols we created:
>
> D7: l
> E7: b
> F7: a
>
> Those correspond with Last price (it's a lower case L, in case you were
> wondering), Bid price, and Ask price.
>
> Now, in cell D8, put this formula:
>
> =smfGetOptionQuotes("",D$7,1)
>
> ...and copy right-ward as needed. This will create column headings based
> on the items codes we entered in row 7.
>
> Step 5
>
> Now let's get some option quotes. In cell D9, enter this formula:
>
> =smfGetOptionQuotes($C9,D$7,,$B$3)
>
> That says to get the option quote for the ticker symbol in cell C9, the
> item code in cell D7, from the input data source listed in cell B3. The
> "$" prefixes on row and column designation mean those are absolute
> references to rows or columns and will not change when you copy the
> formula to other cells. Because we know the option ticker symbols will
> always be in column "C" and the item codes will always be in row 7.
>
> Now, simply copy that formula to fill out the table. And we're done with
> that table!
>
> Step 6
>
> Now we're going to create a table of eight expiration dates for a given
> strike price for the underlying equity in cell B2. However, we need
> another input first -- a strike price to use for the table. So, another
> input field is necessary:
>
> B20: =smfGetOptionStrikes($B$2,$B$5,"Call",$B$3,,2,1)
> C20: <=== Strike price to use for table below
> C23: Tickers
>
> The formula in cell B20 should return the first ITM strike price.
> However, you can manually override that to be any valid strike price.
> Again, I'm just using the formula both to let you know it exists and to
> get a default value in the input field.for the rest of this exercise.
> Cell C23 is just a a column heading. Note that it is the same function
> we used in step (3) above. However, this time I left off the parameter
> that says to make option ticker symbols out of the strike prices. I also
> added the "2,1" for the pDim1 and pDim2 parameters. This tells the
> function to return two rows and one column of data, which would be the
> first ITM and first OTM strike prices. However, by entering the function
> normally into a cell instead of array-entering it over a range, it will
> just display the first item of the array. In this case, the first ITM
> strike price. But, again, just so I had a good default value to go from.
>
> Step 7
>
> Now let's create some option ticker symbols for the various expiration
> dates -- highlight cells C24:C31 and type in this formula:
>
> =smfGetOptionExpirations($B$2,$B$3,"Call",$B$20)
>
> ...and press Ctrl+Shift+Enter to array-enter that formula over the 8-row
> by 1-column range.
>
> The first parameter is our input ticker symbol. The second parameter is
> our input data source. The third parameter indicates whether we want
> option ticker symbols with expiration dates for puts or calls. Again, I
> chose to hard-code a value of "Call" instead of making it another input
> field. The fourth parameter is telling the function which strike price
> to use to generate option symbols for smfGetOptionQuotes() functions for
> each expiration date. If you leave the 3rd and 4th parameters off, the
> returned values would simply be the expiration dates. They are only
> needed when you want the function to generate option ticker symbols.
>
> Step 8
>
> Now we're basically going to repeat step (4) for this table -- just put
> in a few item codes, just so the smfGetOptionQuotes() will actually
> retrieve something from that list of ticker symbols we created (or you
> can just copy them from row 7 down to row 22):
>
> D22: l
> E22: b
> F22: a
>
> Again, those correspond with Last price, Bid price, and Ask price.
>
> In cell D23, put this formula (very similar to what we put in cell D8,
> except that we're referring to a different row of item codes):
>
> =smfGetOptionQuotes("",D$22,1)
>
> And, again, copy right-ward as needed. This will create column headings
> based on the items codes we entered in row 22.
>
> Step 9
>
> Now we're just going to repeat step (5) for this table. In cell D24,
> enter this formula:
>
> =smfGetOptionQuotes($C24,D$22,,$B$3)
>
> ...and copy that formula to fill out the table.
>
> All done!
>
--- In smf_addin@yahoogrou
>
> The purpose of this exercise is not necessarily to create a useful
> template, but more to acquaint you with the various option functions
> available in the latest version of the add-in. I've uploaded a copy of
> the final workbook, after additional formatting was added. It can be
> found here:
>
> smfGetOptionQuotes-
> <http://finance.
>
> Step 1
>
> Open up a new workbook. The first think we're going to do is create two
> basic input fields -- ticker symbol and data source. So, put these
> values in the designated cells:
>
> B2: IWM
> C2: <=== Ticker Symbol of Underlying Equity
> B3: OX
> C3: <=== Data Source to use for Retrieving Data
>
> Note that there are two spaces in front of the greater than sign in cell
> C2 and C3. These days, I typically use OX (i.e. OptionsXPress) as my
> data source. It is more comprehensive than the other data sources (i.e.
> Yahoo, Google, MSN), probably because their customers are actually
> trading the options, while the other data sources are just reporting
> quotes and data. However, of the data sources, OptionsXPress is the
> slowest one to retrieve data from. That's why I like to have this as an
> input field -- so I can easily toggle between data sources if I want to.
>
> Step 2
>
> Now we're going to create a table of five ITM and five OTM options for
> the underlying equity in cell B2. However, we need another input first
> -- an expiration date to use for the table. So, another input field is
> necessary:
>
> B5: =smfGetOptionExpiry
> C5: <=== Option expiration to use for table below
> C8: Tickers
>
> The formula in cell B5 should return the next monthly expiration date.
> However, you can manually override that to be any valid expiration date.
> I'm just using the formula both to let you know it exists and to get a
> default value in the input field.for the rest of this exercise. Cell C8
> is just a a column heading.
>
> Step 3
>
> Now let's create some option ticker symbols for the strike prices --
> highlight cells C9:C18 and type in this formula:
>
> =smfGetOptionStrike
>
> ...and press Ctrl+Shift+Enter to array-enter that formula over the
> 10-row by 1-column range.
>
> The first parameter is our input ticker symbol. The second parameter is
> our input expiration date. The third parameter indicates whether we want
> strike prices for puts or calls, although they should be the same for a
> given expiration date. In this case, I chose to hard-code a value of
> "Call" instead of making it another input field. The fourth parameter is
> our input data source. The fifth parameter is telling the function to
> generate option symbols for smfGetOptionQuotes(
> strike price. If you leave this parameter off or set it to zero, the
> returned values would simply be the numeric strike prices.
>
> Because the formula was entered over a 10-row range, the function will
> return five ITM strikes and five OTM strike prices, or however many are
> available. If there are only three ITM strike prices, the first two
> cells will be left empty. The center of the range should always contain
> the first ITM and OTM strike prices.
>
> Step 4
>
> Now we're just going to put in a few item codes, just so the
> smfGetOptionQuotes(
> ticker symbols we created:
>
> D7: l
> E7: b
> F7: a
>
> Those correspond with Last price (it's a lower case L, in case you were
> wondering), Bid price, and Ask price.
>
> Now, in cell D8, put this formula:
>
> =smfGetOptionQuotes
>
> ...and copy right-ward as needed. This will create column headings based
> on the items codes we entered in row 7.
>
> Step 5
>
> Now let's get some option quotes. In cell D9, enter this formula:
>
> =smfGetOptionQuotes
>
> That says to get the option quote for the ticker symbol in cell C9, the
> item code in cell D7, from the input data source listed in cell B3. The
> "$" prefixes on row and column designation mean those are absolute
> references to rows or columns and will not change when you copy the
> formula to other cells. Because we know the option ticker symbols will
> always be in column "C" and the item codes will always be in row 7.
>
> Now, simply copy that formula to fill out the table. And we're done with
> that table!
>
> Step 6
>
> Now we're going to create a table of eight expiration dates for a given
> strike price for the underlying equity in cell B2. However, we need
> another input first -- a strike price to use for the table. So, another
> input field is necessary:
>
> B20: =smfGetOptionStrike
> C20: <=== Strike price to use for table below
> C23: Tickers
>
> The formula in cell B20 should return the first ITM strike price.
> However, you can manually override that to be any valid strike price.
> Again, I'm just using the formula both to let you know it exists and to
> get a default value in the input field.for the rest of this exercise.
> Cell C23 is just a a column heading. Note that it is the same function
> we used in step (3) above. However, this time I left off the parameter
> that says to make option ticker symbols out of the strike prices. I also
> added the "2,1" for the pDim1 and pDim2 parameters. This tells the
> function to return two rows and one column of data, which would be the
> first ITM and first OTM strike prices. However, by entering the function
> normally into a cell instead of array-entering it over a range, it will
> just display the first item of the array. In this case, the first ITM
> strike price. But, again, just so I had a good default value to go from.
>
> Step 7
>
> Now let's create some option ticker symbols for the various expiration
> dates -- highlight cells C24:C31 and type in this formula:
>
> =smfGetOptionExpira
>
> ...and press Ctrl+Shift+Enter to array-enter that formula over the 8-row
> by 1-column range.
>
> The first parameter is our input ticker symbol. The second parameter is
> our input data source. The third parameter indicates whether we want
> option ticker symbols with expiration dates for puts or calls. Again, I
> chose to hard-code a value of "Call" instead of making it another input
> field. The fourth parameter is telling the function which strike price
> to use to generate option symbols for smfGetOptionQuotes(
> each expiration date. If you leave the 3rd and 4th parameters off, the
> returned values would simply be the expiration dates. They are only
> needed when you want the function to generate option ticker symbols.
>
> Step 8
>
> Now we're basically going to repeat step (4) for this table -- just put
> in a few item codes, just so the smfGetOptionQuotes(
> retrieve something from that list of ticker symbols we created (or you
> can just copy them from row 7 down to row 22):
>
> D22: l
> E22: b
> F22: a
>
> Again, those correspond with Last price, Bid price, and Ask price.
>
> In cell D23, put this formula (very similar to what we put in cell D8,
> except that we're referring to a different row of item codes):
>
> =smfGetOptionQuotes
>
> And, again, copy right-ward as needed. This will create column headings
> based on the items codes we entered in row 22.
>
> Step 9
>
> Now we're just going to repeat step (5) for this table. In cell D24,
> enter this formula:
>
> =smfGetOptionQuotes
>
> ...and copy that formula to fill out the table.
>
> All done!
>
Sat Nov 17, 2012 3:56 pm (PST) . Posted by:
"José Azevedo" jma_resende
*Hello!*
*
*
*Thanks for the answer below.*
*Works.*
*I have other two questions, if it is possible give me a help.*
*
*
*1- For resolve the other question I discovered other web page:*
*http://biz.yahoo.com/p/industries.html* <http://biz.yahoo.com/p/industries.html >
*But I have a error, when I try make the same suggest using the
"SUBSTITUTE" in above link.*
*Example: If I have *
*B4=VNET (example stock)*
*B33 =RCHGetTableCell("http://finance.yahoo.com/q/pr?s= "&B4;1;"Industry:")*
*and*
*=RCHGetTableCell("http://biz.yahoo.com/p/industries.html ";3;SUBSTITUTE(B33;"
";""))*
*I have a error. Not all but in this spcific I have. The Industry here are
"Information Technology Services"*
*
*
*
*
*
*
*2- Other doubt:*
*In this topic "Dividend Yield on the Reuters template appears to be
incorrect"*
*and in this message:
http://finance.groups.yahoo.com/group/smf_addin/message/19262*
*The table in last column "S&P 500" in error are resolved? If yes, how?*
*Many thanks*
-.----------------------------------------------------------
Thu Nov 15, 2012 1:05 pm (PST) . Posted by: "Randy Harmelink"
rharmelink<rharmelink@gmail.com ?subject=Re%3A%20%3DRCHGetTableCell>
You're getting an error because the coding for the
http://biz.yahoo.**com/p/s_conameu.**html <http://biz.yahoo.com/p/s_conameu.html >
web
page has a line feed between
"Industrial" and "Goods". Which is also why "Healthcare" works -- no line
feed in the middle.
Additionally, the add-in strips out line feeds and carriage returns from a
web page when it processes it, so you could try something like:
=RCHGetTableCell(**"http://biz.yahoo.**com/p/s_conameu.**html <http://biz.yahoo.com/p/s_conameu.html >
",3,SUBSTITUTE(**F31,"
",""))
----------------------------------------------------------
*
*
*Thanks for the answer below.*
*Works.*
*I have other two questions, if it is possible give me a help.*
*
*
*1- For resolve the other question I discovered other web page:*
*http://biz.yahoo.
*But I have a error, when I try make the same suggest using the
"SUBSTITUTE" in above link.*
*Example: If I have *
*B4=VNET (example stock)*
*B33 =RCHGetTableCell(
*and*
*=RCHGetTableCell(
";""))*
*I have a error. Not all but in this spcific I have. The Industry here are
"Information Technology Services"*
*
*
*
*
*
*
*2- Other doubt:*
*In this topic "Dividend Yield on the Reuters template appears to be
incorrect"*
*and in this message:
http://finance.
*The table in last column "S&P 500" in error are resolved? If yes, how?*
*Many thanks*
-.----------
Thu Nov 15, 2012 1:05 pm (PST) . Posted by: "Randy Harmelink"
rharmelink<rharmelink@gmail.
You're getting an error because the coding for the
http://biz.yahoo.
web
page has a line feed between
"Industrial" and "Goods". Which is also why "Healthcare" works -- no line
feed in the middle.
Additionally, the add-in strips out line feeds and carriage returns from a
web page when it processes it, so you could try something like:
=RCHGetTableCell(
",3,SUBSTITUTE(
",""))
------------
Sat Nov 17, 2012 7:50 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
On Sat, Nov 17, 2012 at 4:56 PM, José Azevedo <jmazevedo@gmail.com > wrote:
>
> 1- For resolve the other question I discovered other web page:
> http://biz.yahoo.com/p/industries.html
> But I have a error, when I try make the same suggest using the
"SUBSTITUTE" in above link.
> Example: If I have
> B4=VNET (example stock)
> B33 =RCHGetTableCell("http://finance.yahoo.com/q/pr?s= "&B4;1;"Industry:")
> and
> =RCHGetTableCell("http://biz.yahoo.com/p/industries.html ";3;SUBSTITUTE(B33;"
";""))
> I have a error. Not all but in this spcific I have. The Industry here are
"Information Technology Services"
It appears that they are not consistent in the coding on the page. Some
industry descriptions contain the line feeds, others don't. I don't really
have a solution for that.
Hmmm. You could use the industry number instead, since it is within the
links on both pages. Try:
B4: VNET
E4: =smfStrExtr(smfGetTagContent("http://finance.yahoo.com/q/pr?s=
"&B4,"td",1,"Industry:"),"/ic/",".html")
F4: =RCHGetTableCell("http://biz.yahoo.com/p/industries.html
",3,E4&"conameu")
> 2- Other doubt:
> In this topic "Dividend Yield on the Reuters template appears to be
incorrect"
> and in this message:
http://finance.groups.yahoo.com/group/smf_addin/message/19262
> The table in last column "S&P 500" in error are resolved? If yes, how?
Reuters dropped the S&P 500 data from their web page, so it's no longer
available.
>
> 1- For resolve the other question I discovered other web page:
> http://biz.yahoo.
> But I have a error, when I try make the same suggest using the
"SUBSTITUTE" in above link.
> Example: If I have
> B4=VNET (example stock)
> B33 =RCHGetTableCell(
> and
> =RCHGetTableCell(
";""))
> I have a error. Not all but in this spcific I have. The Industry here are
"Information Technology Services"
It appears that they are not consistent in the coding on the page. Some
industry descriptions contain the line feeds, others don't. I don't really
have a solution for that.
Hmmm. You could use the industry number instead, since it is within the
links on both pages. Try:
B4: VNET
E4: =smfStrExtr(
"&B4,"td",1,
F4: =RCHGetTableCell(
",3,E4&"conameu"
> 2- Other doubt:
> In this topic "Dividend Yield on the Reuters template appears to be
incorrect"
> and in this message:
http://finance.
> The table in last column "S&P 500" in error are resolved? If yes, how?
Reuters dropped the S&P 500 data from their web page, so it's no longer
available.
Tidak ada komentar:
Posting Komentar