15 New Messages
Digest #2404
Messages
Sun Nov 18, 2012 7:05 am (PST) . Posted by:
"Ron Spruell" hashky
Jose -
In the SUBSTITUTE equation, you have a space between the first set of quotation marks.
I got 22.5 when I removed the space.
Ron Spruell
>________________________________
> From: José Azevedo <jmazevedo@gmail.com >
>To: smf_addin@yahoogroups.com
>Sent: Saturday, November 17, 2012 5:56 PM
>Subject: [smf_addin] Re: =RCHGetTableCell
>
>
>
>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
>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
>You're getting an error because the coding for the
>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 ",3,SUBSTITUTE(F31,"
>",""))
>----------------------------------------------------------
>
>
>
>
>
>
>
>
>
In the SUBSTITUTE equation, you have a space between the first set of quotation marks.
I got 22.5 when I removed the space.
Ron Spruell
>___________
> From: José Azevedo <jmazevedo@gmail.
>To: smf_addin@yahoogrou
>Sent: Saturday, November 17, 2012 5:56 PM
>Subject: [smf_addin] Re: =RCHGetTableCell
>
>
>
>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.
>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
>You're getting an error because the coding for the
>http://biz.yahoo.
>"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(
>",""))
>-----------
>
>
>
>
>
>
>
>
>
Sun Nov 18, 2012 7:13 am (PST) . Posted by:
"Ron Spruell" hashky
I lied. It only does OTM1 and ITM1 for puts and calls. I don't think it is ready for prime time.
I am working on a later version. I haven't double checked the instructions, so they may not be accurate.
I will attach.
Ron Spruell
>________________________________
> From: bsmth12 <bsmth12@yahoo.com >
>To: smf_addin@yahoogroups.com
>Sent: Saturday, November 17, 2012 1:43 PM
>Subject: [smf_addin] Re: help getting started
>
>
>
>>
>
>--- 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,
>
>
>
>
>
I am working on a later version. I haven't double checked the instructions, so they may not be accurate.
I will attach.
Ron Spruell
>___________
> From: bsmth12 <bsmth12@yahoo.
>To: smf_addin@yahoogrou
>Sent: Saturday, November 17, 2012 1:43 PM
>Subject: [smf_addin] Re: help getting started
>
>
>
>>
>
>--- 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,
>
>
>
>
>
Attachments with this message:
1 of 1 File(s)
Sun Nov 18, 2012 7:18 am (PST) . Posted by:
"kucing.comeng" kucing.comeng
hello randy i wanna request to you some picture here to excel
http://markets.ft.com/research/Markets/Tearsheets/Forecasts?s=BBRI:JKT
here the link
iwant to take "share recommendation" and "share price" section
to my spreadsheet
thanks alot for your kindness
may god bless you
http://markets.
here the link
iwant to take "share recommendation" and "share price" section
to my spreadsheet
thanks alot for your kindness
may god bless you
Sun Nov 18, 2012 7:29 am (PST) . Posted by:
"Randy Harmelink" rharmelink
The "Share Recommendation" section is generated via an API, so there is no
image to extract.
However, for the "Share Price" section, try:
=RCHCreateComment("http://markets.ft.com "&smfStrExtr(RCHGetWebData("
http://markets.ft.com/research/Markets/Tearsheets/Forecasts?s=BBRI:JKT ",">Share
price forecast",2000),"<img src=""",""""),99)
On Sun, Nov 18, 2012 at 8:10 AM, kucing.comeng <kucing.comeng@yahoo.co.id >wrote:
> hello randy i wanna request to you some picture here to excel
>
> http://markets.ft.com/research/Markets/Tearsheets/Forecasts?s=BBRI:JKT
>
> here the link
>
> iwant to take "share recommendation" and "share price" section
>
> to my spreadsheet
>
image to extract.
However, for the "Share Price" section, try:
=RCHCreateComment(
http://markets.
price forecast",2000)
On Sun, Nov 18, 2012 at 8:10 AM, kucing.comeng <kucing.comeng@
> hello randy i wanna request to you some picture here to excel
>
> http://markets.
>
> here the link
>
> iwant to take "share recommendation" and "share price" section
>
> to my spreadsheet
>
Sun Nov 18, 2012 7:53 am (PST) . Posted by:
"Ron Spruell" hashky
=RCHGetTableCell("http://markets.ft.com/research/Markets/Tearsheets/Forecasts?s=BBRI:JKT ",3,"Data definitions")
Gets 50.00 / 0.69%
If you just want the 50, you will have to use FIND and LEFT to get just the 50.
=RCHGetTableCell("http://markets.ft.com/research/Markets/Tearsheets/Forecasts?s=BBRI:JKT ",1,"Latest recommendation")
Gets Buy
Ron Spruell
>________________________________
> From: kucing.comeng <kucing.comeng@yahoo.co.id >
>To: smf_addin@yahoogroups.com
>Sent: Sunday, November 18, 2012 9:10 AM
>Subject: [smf_addin] hello randy, request ft.com picture get
>
>
>
>hello randy i wanna request to you some picture here to excel
>
>http://markets.ft.com/research/Markets/Tearsheets/Forecasts?s=BBRI:JKT
>
>here the link
>
>iwant to take "share recommendation" and "share price" section
>
>to my spreadsheet
>
>thanks alot for your kindness
>may god bless you
>
>
>
>
>
Gets 50.00 / 0.69%
If you just want the 50, you will have to use FIND and LEFT to get just the 50.
=RCHGetTableCell(
Gets Buy
Ron Spruell
>___________
> From: kucing.comeng <kucing.comeng@
>To: smf_addin@yahoogrou
>Sent: Sunday, November 18, 2012 9:10 AM
>Subject: [smf_addin] hello randy, request ft.com picture get
>
>
>
>hello randy i wanna request to you some picture here to excel
>
>http://markets.
>
>here the link
>
>iwant to take "share recommendation" and "share price" section
>
>to my spreadsheet
>
>thanks alot for your kindness
>may god bless you
>
>
>
>
>
Sun Nov 18, 2012 8:09 am (PST) . Posted by:
"Ron Spruell" hashky
Randy -
What am I missing? I was able to pull both while you were writing this. I don't know if it will work on other Tickers. I tried the equation below and could not get it to work.
Ron Spruell
>________________________________
> From: Randy Harmelink <rharmelink@gmail.com >
>To: smf_addin@yahoogroups.com
>Sent: Sunday, November 18, 2012 9:29 AM
>Subject: Re: [smf_addin] hello randy, request ft.com picture get
>
>
>
>The "Share Recommendation" section is generated via an API, so there is no image to extract.
>
>However, for the "Share Price" section, try:
>
>=RCHCreateComment("http://markets.ft.com "&smfStrExtr(RCHGetWebData("http://markets.ft.com/research/Markets/Tearsheets/Forecasts?s=BBRI:JKT ",">Share price forecast",2000),"<img src=""",""""),99)
>
>
>On Sun, Nov 18, 2012 at 8:10 AM, kucing.comeng <kucing.comeng@yahoo.co.id > wrote:
>
>hello randy i wanna request to you some picture here to excel
>>
>>http://markets.ft.com/research/Markets/Tearsheets/Forecasts?s=BBRI:JKT
>>
>>here the link
>>
>>iwant to take "share recommendation" and "share price" section
>>
>>to my spreadsheet
>>
>
>
>
>
What am I missing? I was able to pull both while you were writing this. I don't know if it will work on other Tickers. I tried the equation below and could not get it to work.
Ron Spruell
>___________
> From: Randy Harmelink <rharmelink@gmail.
>To: smf_addin@yahoogrou
>Sent: Sunday, November 18, 2012 9:29 AM
>Subject: Re: [smf_addin] hello randy, request ft.com picture get
>
>
>
>The "Share Recommendation" section is generated via an API, so there is no image to extract.
>
>However, for the "Share Price" section, try:
>
>=RCHCreateComment(
>
>
>On Sun, Nov 18, 2012 at 8:10 AM, kucing.comeng <kucing.comeng@
>
>hello randy i wanna request to you some picture here to excel
>>
>>http://markets.
>>
>>here the link
>>
>>iwant to take "share recommendation" and "share price" section
>>
>>to my spreadsheet
>>
>
>
>
>
Sun Nov 18, 2012 8:29 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Hmmm. The image URL seems to change with each visit to the web page, so it
may not be extractable. It originally did work for me, but now it doesn't...
You were able to pull both IMAGES?
On Sun, Nov 18, 2012 at 9:09 AM, Ron Spruell <hashky@yahoo.com > wrote:
>
> What am I missing? I was able to pull both while you were writing this.
> I don't know if it will work on other Tickers. I tried the equation below
> and could not get it to work.
>
>
may not be extractable. It originally did work for me, but now it doesn't...
You were able to pull both IMAGES?
On Sun, Nov 18, 2012 at 9:09 AM, Ron Spruell <hashky@yahoo.
>
> What am I missing? I was able to pull both while you were writing this.
> I don't know if it will work on other Tickers. I tried the equation below
> and could not get it to work.
>
>
Sun Nov 18, 2012 10:08 am (PST) . Posted by:
"Ron Spruell" hashky
After a reboot, I still get:
50.00 / 0.69%
Buy
>________________________________
> From: Randy Harmelink <rharmelink@gmail.com >
>To: smf_addin@yahoogroups.com
>Sent: Sunday, November 18, 2012 10:29 AM
>Subject: Re: [smf_addin] hello randy, request ft.com picture get
>
>
>
>Hmmm. The image URL seems to change with each visit to the web page, so it may not be extractable. It originally did work for me, but now it doesn't...
>
>You were able to pull both IMAGES?
>
>
>On Sun, Nov 18, 2012 at 9:09 AM, Ron Spruell <hashky@yahoo.com > wrote:
>
>
>>
>>What am I missing? I was able to pull both while you were writing this. I don't know if it will work on other Tickers. I tried the equation below and could not get it to work.
>>
>
>
>
>
50.00 / 0.69%
Buy
>___________
> From: Randy Harmelink <rharmelink@gmail.
>To: smf_addin@yahoogrou
>Sent: Sunday, November 18, 2012 10:29 AM
>Subject: Re: [smf_addin] hello randy, request ft.com picture get
>
>
>
>Hmmm. The image URL seems to change with each visit to the web page, so it may not be extractable. It originally did work for me, but now it doesn't...
>
>You were able to pull both IMAGES?
>
>
>On Sun, Nov 18, 2012 at 9:09 AM, Ron Spruell <hashky@yahoo.
>
>
>>
>>What am I missing? I was able to pull both while you were writing this. I don't know if it will work on other Tickers. I tried the equation below and could not get it to work.
>>
>
>
>
>
Sun Nov 18, 2012 7:37 am (PST) . Posted by:
"cs.holdings" cs.holdings
Help.
I finally upgraded from excel 2007 and XP to Windows 7 and excel 2010.
But now my files say object library cannot be found. Ive checked the REF file and it shows MS Excel 14 selected. Is there another that needs to be checked?
I finally upgraded from excel 2007 and XP to Windows 7 and excel 2010.
But now my files say object library cannot be found. Ive checked the REF file and it shows MS Excel 14 selected. Is there another that needs to be checked?
Sun Nov 18, 2012 7:47 am (PST) . Posted by:
"Randy Harmelink" rharmelink
My version of the add-in uses:
-- Visual Basic for Applications
-- Microsoft Excel 12.0 Object Library
-- Microsoft Office 12.0 Object Library
-- OLE Automation
-- Microsoft Internet Controls
-- Microsoft XML, 3.0
-- Microsoft HTML Object Library
On Sun, Nov 18, 2012 at 8:37 AM, cs.holdings <pc_babe@msn.com > wrote:
>
> I finally upgraded from excel 2007 and XP to Windows 7 and excel 2010.
>
> But now my files say object library cannot be found. Ive checked the REF
> file and it shows MS Excel 14 selected. Is there another that needs to be
> checked?
>
-- Visual Basic for Applications
-- Microsoft Excel 12.0 Object Library
-- Microsoft Office 12.0 Object Library
-- OLE Automation
-- Microsoft Internet Controls
-- Microsoft XML, 3.0
-- Microsoft HTML Object Library
On Sun, Nov 18, 2012 at 8:37 AM, cs.holdings <pc_babe@msn.
>
> I finally upgraded from excel 2007 and XP to Windows 7 and excel 2010.
>
> But now my files say object library cannot be found. Ive checked the REF
> file and it shows MS Excel 14 selected. Is there another that needs to be
> checked?
>
Sun Nov 18, 2012 9:10 am (PST) . Posted by:
"dguillett1" donaldb36
To all my family, friends and associates who may be interested.
Several weeks ago I went to my Doctor complaining that it was becoming increasingly hard to breath well. He ordered a heart ct which showed emphysema and a need for further heart studies.
So I went to a cardiologist for a nuclear stress test which showed that I had blockages that needed further evaluation. A few days later, 31 Oct, I went to "The Heart hospital of Austin" for a heart cauterization to see exactly how bad it was. One blockage 85%, others less which demanded that I stay at the hospital to prep for an operation 2 Nov resulting in a 4x bypass which went swimmingly. I was VERY lucky to get Dr. John David Oswalt who is the best. Check this. http://www.healthgrades.com/physician/dr-john-oswalt-2nnvf
However, there was a complication of a bowel twist which was a big problem to resolve and NOT much fun.
Anyway, after 2 weeks in the hospital, I am now at home with 24/7 oxygen, a remote vital signs monitor and a visiting home health RN and Robbie as caregiver. I will get better.
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguillett1@gmail.com
Several weeks ago I went to my Doctor complaining that it was becoming increasingly hard to breath well. He ordered a heart ct which showed emphysema and a need for further heart studies.
So I went to a cardiologist for a nuclear stress test which showed that I had blockages that needed further evaluation. A few days later, 31 Oct, I went to "The Heart hospital of Austin" for a heart cauterization to see exactly how bad it was. One blockage 85%, others less which demanded that I stay at the hospital to prep for an operation 2 Nov resulting in a 4x bypass which went swimmingly. I was VERY lucky to get Dr. John David Oswalt who is the best. Check this. http://www.healthgr
However, there was a complication of a bowel twist which was a big problem to resolve and NOT much fun.
Anyway, after 2 weeks in the hospital, I am now at home with 24/7 oxygen, a remote vital signs monitor and a visiting home health RN and Robbie as caregiver. I will get better.
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguillett1@gmail.
Sun Nov 18, 2012 11:29 pm (PST) . Posted by:
"Randy H" rharmelink
All we have available is what Yahoo reports on the web page...
They're only guesses in the first place.
On Sun, Nov 18, 2012 at 5:38 PM, andrewhills97 <andrewhills97@...
<mailto:andrewhills97@yahoo.com > > wrote:
I notice the Yahoo EPS estimates (element #563 & 564 for eg) are
rounded to the nearest 1 cent. For most companies, there is no problems
with accuracy but with companies which report EPS of say 5 cps, the
estimates could range from 4.5 to 5.4 cps which is a 20% difference. Is
it possible to retrieve Yahoo estimates rounded to the nearest 0.1 cps?
They're only guesses in the first place.
On Sun, Nov 18, 2012 at 5:38 PM, andrewhills97 <andrewhills97@
<mailto:andrewhills97@
I notice the Yahoo EPS estimates (element #563 & 564 for eg) are
rounded to the nearest 1 cent. For most companies, there is no problems
with accuracy but with companies which report EPS of say 5 cps, the
estimates could range from 4.5 to 5.4 cps which is a 20% difference. Is
it possible to retrieve Yahoo estimates rounded to the nearest 0.1 cps?
Mon Nov 19, 2012 1:31 am (PST) . Posted by:
"andrewhills97" andrewhills97
Thanks Randy,
Can you help me find the element numbers for Google Finance data for: EPS (last year), EPS (this year), EPS (next year), EPS (this year, 90 days ago), EPS (this year, 60 days ago), EPS (this year, 30 days ago), EPS (this year, 7 days ago),EPS (next year, 90 days ago), EPS (next year, 60 days ago), EPS (next year, 30 days ago), EPS (next year, 7 days ago).
Thanks. Andrew.
--- In smf_addin@yahoogroups.com , "Randy H" <rharmelink@...> wrote:
>
> All we have available is what Yahoo reports on the web page...
>
> They're only guesses in the first place.
>
> On Sun, Nov 18, 2012 at 5:38 PM, andrewhills97 <andrewhills97@
> <mailto:andrewhills97@...> > wrote:
>
> I notice the Yahoo EPS estimates (element #563 & 564 for eg) are
> rounded to the nearest 1 cent. For most companies, there is no problems
> with accuracy but with companies which report EPS of say 5 cps, the
> estimates could range from 4.5 to 5.4 cps which is a 20% difference. Is
> it possible to retrieve Yahoo estimates rounded to the nearest 0.1 cps?
>
Can you help me find the element numbers for Google Finance data for: EPS (last year), EPS (this year), EPS (next year), EPS (this year, 90 days ago), EPS (this year, 60 days ago), EPS (this year, 30 days ago), EPS (this year, 7 days ago),EPS (next year, 90 days ago), EPS (next year, 60 days ago), EPS (next year, 30 days ago), EPS (next year, 7 days ago).
Thanks. Andrew.
--- In smf_addin@yahoogrou
>
> All we have available is what Yahoo reports on the web page...
>
> They're only guesses in the first place.
>
> On Sun, Nov 18, 2012 at 5:38 PM, andrewhills97 <andrewhills97@
> <mailto:andrewhills
>
> I notice the Yahoo EPS estimates (element #563 & 564 for eg) are
> rounded to the nearest 1 cent. For most companies, there is no problems
> with accuracy but with companies which report EPS of say 5 cps, the
> estimates could range from 4.5 to 5.4 cps which is a 20% difference. Is
> it possible to retrieve Yahoo estimates rounded to the nearest 0.1 cps?
>
Mon Nov 19, 2012 2:32 am (PST) . Posted by:
"Randy Harmelink" rharmelink
As far as I know, Google doesn't have such data items. What web page are
you looking at?
On Mon, Nov 19, 2012 at 2:31 AM, andrewhills97 <andrewhills97@yahoo.com >wrote:
>
> Can you help me find the element numbers for Google Finance data for: EPS
> (last year), EPS (this year), EPS (next year), EPS (this year, 90 days
> ago), EPS (this year, 60 days ago), EPS (this year, 30 days ago), EPS (this
> year, 7 days ago),EPS (next year, 90 days ago), EPS (next year, 60 days
> ago), EPS (next year, 30 days ago), EPS (next year, 7 days ago).
>
you looking at?
On Mon, Nov 19, 2012 at 2:31 AM, andrewhills97 <andrewhills97@
>
> Can you help me find the element numbers for Google Finance data for: EPS
> (last year), EPS (this year), EPS (next year), EPS (this year, 90 days
> ago), EPS (this year, 60 days ago), EPS (this year, 30 days ago), EPS (this
> year, 7 days ago),EPS (next year, 90 days ago), EPS (next year, 60 days
> ago), EPS (next year, 30 days ago), EPS (next year, 7 days ago).
>
Mon Nov 19, 2012 2:45 am (PST) . Posted by:
"andrewhills97" andrewhills97
google finance takes you Thomson Reuters for company earnings estimates, for eg,
http://www.reuters.
--- In smf_addin@yahoogrou
>
> As far as I know, Google doesn't have such data items. What web page are
> you looking at?
>
> On Mon, Nov 19, 2012 at 2:31 AM, andrewhills97 <andrewhills97@
>
> >
> > Can you help me find the element numbers for Google Finance data for: EPS
> > (last year), EPS (this year), EPS (next year), EPS (this year, 90 days
> > ago), EPS (this year, 60 days ago), EPS (this year, 30 days ago), EPS (this
> > year, 7 days ago),EPS (next year, 90 days ago), EPS (next year, 60 days
> > ago), EPS (next year, 30 days ago), EPS (next year, 7 days ago).
> >
>
Tidak ada komentar:
Posting Komentar