10 New Messages
Digest #2716
1a
Re: Problem reading ticker symbol for Indian stocks in Morningstar by "Randy Harmelink" rharmelink
Messages
Tue Jul 30, 2013 2:19 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
That's going to be a problematic extraction, no matter what. And I'm not
sure how applicable to other usage. But it starts with:
=smfGetTagContent("http://www.screener.in/company/?q=500530 ","p",0,"Market
Cap:")
...which extracts:
<span class="WebRupee">Rs.</span> 27806.90 Crores</b>
So, a possible way to pull it out of there would be:
=smfConvertData(smfStrExtr(smfGetTagContent("
http://www.screener.in/company/?q=500530 ","p",0,"Market
Cap:"),"span>","Crores"))
On Tue, Jul 30, 2013 at 12:17 AM, Gururaj Rao <honyakusha@gmail.com > wrote:
>
> Based on one of your templates below,
> I tried to collect data from this URL:
> http://www.screener.in/company/?q=500530
> I thought I could pick up one, I could probably make some headway with the
> other elements (including 10 year data given here but alas!
>
> This is the source data for Market cap <p class='span4'>Market
> Cap: <b><span class="WebRupee">Rs.</span> 27806.90 Crores</b></p>
> They have introduced a symbol for the Rupee which has thrown me off
> completely.
> Here's what I tried to write ignoring the symbol for rupees:
>
> =smfConvertData(smfGetTagContent("http://www.screener.in/company/q=500530 ","'span4'=""Market
> Cap:""")) <http://quotes.morningstar.com/stock/c-header?&t=MMM >
>
> Which gave an "Error"
>
> Can somebody give me a start? I'd like to make a template for this URL,
> and pull in data.
>
>
>
>
sure how applicable to other usage. But it starts with:
=smfGetTagContent(
Cap:")
...which extracts:
<span class="
So, a possible way to pull it out of there would be:
=smfConvertData(
http://www.screener
Cap:"),
On Tue, Jul 30, 2013 at 12:17 AM, Gururaj Rao <honyakusha@gmail.
>
> Based on one of your templates below,
> I tried to collect data from this URL:
> http://www.screener
> I thought I could pick up one, I could probably make some headway with the
> other elements (including 10 year data given here but alas!
>
> This is the source data for Market cap <p class='span4&#
> Cap: <b><
> They have introduced a symbol for the Rupee which has thrown me off
> completely.
> Here's what I tried to write ignoring the symbol for rupees:
>
> =smfConvertData(
> Cap:""
>
> Which gave an "Error"
>
> Can somebody give me a start? I'd like to make a template for this URL,
> and pull in data.
>
>
>
>
Tue Jul 30, 2013 6:15 am (PDT) . Posted by:
"Lawrence" lawleesh
Hi Randy
I have had intermittent success with getting a result from this formula:
=RCHGetTableCell("http://markets.ft.com/research/Markets/Tearsheets/Financials?s=G05:SES&subview=BalanceSheet ",1,">Cash and Short Term Investments")
It worked fine on the first computer then stopped working. In another computer the same formula worked.
The first computer that failed to get a result for this formula above has no problem with this formula =RCHGetTableCell("http://finance.yahoo.com/q/is?s=g05.si ",1,"Period Ending","Total Revenue",,,,"Add to Portfolio")
Do you know what may have caused this as the RCHGetTableCell function is obviously working fine in the first computer?
thanks
LL
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Easy peasy lemon-squeezy:
>
> =RCHGetTableCell("
> http://markets.ft.com/research/Markets/Tearsheets/Financials?s=G05:SES&subview=BalanceSheet ",1,">Cash and Short Term Investments")
>
> ...will get the first column of data. It may not always be for 2012 though.
> It will depend on the company's fiscal year and when they announce their
> results (and when FT posts those results).
>
> On Sun, Jul 14, 2013 at 12:08 PM, Lawrence <lawrence.leesh@...> wrote:
>
> >
> > If I want to retrieve Cash and Short Term Investments for 2012 from this
> > page
> >
> > http://markets.ft.com/research/Markets/Tearsheets/Financials?s=G05:SES&subview=BalanceSheet
> > what formula should I key into Excel?
> >
>
I have had intermittent success with getting a result from this formula:
=RCHGetTableCell(
It worked fine on the first computer then stopped working. In another computer the same formula worked.
The first computer that failed to get a result for this formula above has no problem with this formula =RCHGetTableCell(
Do you know what may have caused this as the RCHGetTableCell function is obviously working fine in the first computer?
thanks
LL
--- In smf_addin@yahoogrou
>
> Easy peasy lemon-squeezy:
>
> =RCHGetTableCell(
> http://markets.
>
> ...will get the first column of data. It may not always be for 2012 though.
> It will depend on the company'
> results (and when FT posts those results).
>
> On Sun, Jul 14, 2013 at 12:08 PM, Lawrence <lawrence.
>
> >
> > If I want to retrieve Cash and Short Term Investments for 2012 from this
> > page
> >
> > http://markets.
> > what formula should I key into Excel?
> >
>
Tue Jul 30, 2013 7:43 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Was it maybe not working on companies that don't have a line item of "Cash
and Short Term Investments", like a financial institution? Or did you try
it on the same ticker, and it worked one place, but not the other?
Otherwise, I'm at a loss, unless they have different servers delivering web
pages in different formats...
On Tue, Jul 30, 2013 at 6:15 AM, Lawrence <lawrence.leesh@gmail.com > wrote:
>
> I have had intermittent success with getting a result from this formula:
> =RCHGetTableCell("
> http://markets.ft.com/research/Markets/Tearsheets/Financials?s=G05:SES&subview=BalanceSheet ",1,">Cash
> and Short Term Investments")
>
> It worked fine on the first computer then stopped working. In another
> computer the same formula worked.
>
> The first computer that failed to get a result for this formula above has
> no problem with this formula =RCHGetTableCell("
> http://finance.yahoo.com/q/is?s=g05.si ",1,"Period Ending","Total
> Revenue",,,,"Add to Portfolio")
>
> Do you know what may have caused this as the RCHGetTableCell function is
> obviously working fine in the first computer?
>
and Short Term Investments"
it on the same ticker, and it worked one place, but not the other?
Otherwise, I'm at a loss, unless they have different servers delivering web
pages in different formats...
On Tue, Jul 30, 2013 at 6:15 AM, Lawrence <lawrence.leesh@
>
> I have had intermittent success with getting a result from this formula:
> =RCHGetTableCell(
> http://markets.
> and Short Term Investments"
>
> It worked fine on the first computer then stopped working. In another
> computer the same formula worked.
>
> The first computer that failed to get a result for this formula above has
> no problem with this formula =RCHGetTableCell(
> http://finance.
> Revenue"
>
> Do you know what may have caused this as the RCHGetTableCell function is
> obviously working fine in the first computer?
>
Tue Jul 30, 2013 7:44 am (PDT) . Posted by:
"Lawrence" lawleesh
It's the same ticker that worked in one computer but not in another. Thanks.
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Was it maybe not working on companies that don't have a line item of "Cash
> and Short Term Investments", like a financial institution? Or did you try
> it on the same ticker, and it worked one place, but not the other?
>
> Otherwise, I'm at a loss, unless they have different servers delivering web
> pages in different formats...
>
> On Tue, Jul 30, 2013 at 6:15 AM, Lawrence <lawrence.leesh@...> wrote:
>
> >
> > I have had intermittent success with getting a result from this formula:
> > =RCHGetTableCell("
> > http://markets.ft.com/research/Markets/Tearsheets/Financials?s=G05:SES&subview=BalanceSheet ",1,">Cash
> > and Short Term Investments")
> >
> > It worked fine on the first computer then stopped working. In another
> > computer the same formula worked.
> >
> > The first computer that failed to get a result for this formula above has
> > no problem with this formula =RCHGetTableCell("
> > http://finance.yahoo.com/q/is?s=g05.si ",1,"Period Ending","Total
> > Revenue",,,,"Add to Portfolio")
> >
> > Do you know what may have caused this as the RCHGetTableCell function is
> > obviously working fine in the first computer?
> >
>
--- In smf_addin@yahoogrou
>
> Was it maybe not working on companies that don't have a line item of "Cash
> and Short Term Investments"
> it on the same ticker, and it worked one place, but not the other?
>
> Otherwise, I'm at a loss, unless they have different servers delivering web
> pages in different formats...
>
> On Tue, Jul 30, 2013 at 6:15 AM, Lawrence <lawrence.
>
> >
> > I have had intermittent success with getting a result from this formula:
> > =RCHGetTableCell(
> > http://markets.
> > and Short Term Investments"
> >
> > It worked fine on the first computer then stopped working. In another
> > computer the same formula worked.
> >
> > The first computer that failed to get a result for this formula above has
> > no problem with this formula =RCHGetTableCell(
> > http://finance.
> > Revenue"
> >
> > Do you know what may have caused this as the RCHGetTableCell function is
> > obviously working fine in the first computer?
> >
>
Tue Jul 30, 2013 7:56 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Then, on the machine where it doesn't work, try:
=RCHGetWebData("
http://markets.ft.com/research/Markets/Tearsheets/Financials?s=G05:SES&subview=BalanceSheet
",,100)
=RCHGetWebData("
http://markets.ft.com/research/Markets/Tearsheets/Financials?s=G05:SES&subview=BalanceSheet ","Short
Term",100,-30)
On Tue, Jul 30, 2013 at 7:44 AM, Lawrence <lawrence.leesh@gmail.com > wrote:
> It's the same ticker that worked in one computer but not in another.
> Thanks.
>
=RCHGetWebData(
http://markets.
",,100)
=RCHGetWebData(
http://markets.
Term",100,
On Tue, Jul 30, 2013 at 7:44 AM, Lawrence <lawrence.leesh@
> It's the same ticker that worked in one computer but not in another.
> Thanks.
>
Tue Jul 30, 2013 8:26 am (PDT) . Posted by:
"Lawrence" lawleesh
The first formula returned blank, not even Error.
The second returned "Error".
thanks
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Then, on the machine where it doesn't work, try:
>
> =RCHGetWebData("
> http://markets.ft.com/research/Markets/Tearsheets/Financials?s=G05:SES&subview=BalanceSheet
> ",,100)
>
> =RCHGetWebData("
> http://markets.ft.com/research/Markets/Tearsheets/Financials?s=G05:SES&subview=BalanceSheet ","Short
> Term",100,-30)
>
> On Tue, Jul 30, 2013 at 7:44 AM, Lawrence <lawrence.leesh@...> wrote:
>
> > It's the same ticker that worked in one computer but not in another.
> > Thanks.
> >
>
The second returned "Error"
thanks
--- In smf_addin@yahoogrou
>
> Then, on the machine where it doesn't work, try:
>
> =RCHGetWebData(
> http://markets.
> ",,100)
>
> =RCHGetWebData(
> http://markets.
> Term",100,
>
> On Tue, Jul 30, 2013 at 7:44 AM, Lawrence <lawrence.
>
> > It's the same ticker that worked in one computer but not in another.
> > Thanks.
> >
>
Tue Jul 30, 2013 9:05 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Hmmm. Sounds like it didn't get the web page from FT.com. Try the
smfForceRecalculation macro and see if getting a fresh copy of the web page
from the web site gives you different results.
On Tue, Jul 30, 2013 at 8:26 AM, Lawrence <lawrence.leesh@gmail.com > wrote:
> The first formula returned blank, not even Error.
>
> The second returned "Error".
>
smfForceRecalculati
from the web site gives you different results.
On Tue, Jul 30, 2013 at 8:26 AM, Lawrence <lawrence.leesh@
> The first formula returned blank, not even Error.
>
> The second returned "Error"
>
Tue Jul 30, 2013 12:55 pm (PDT) . Posted by:
"nautilustech" nautilustech
Bunge Group (Ticker BG) is currently trading at $76.55. This formula:
smfGetYahooQuote("BG","C",DATE(2013,8,17),"OTM1","s")
returns 75.00, which is an ITM strike price.
Can anyone tell me what I'm doing wrong?
Many thanks in advance.
smfGetYahooQuote(
returns 75.00, which is an ITM strike price.
Can anyone tell me what I'm doing wrong?
Many thanks in advance.
Tue Jul 30, 2013 1:00 pm (PDT) . Posted by:
"nautilustech" nautilustech
--- In smf_addin@yahoogrou
>
> Bunge Group (Ticker BG) is currently trading at $76.55. This formula:
>
> smfGetYahooQuote(
>
> returns 75.00, which is an ITM strike price.
>
> Can anyone tell me what I'm doing wrong?
>
> Many thanks in advance.
My error. The formula should be:
=smfGetYahooOptionQ
Tue Jul 30, 2013 1:18 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
It returns the $77.50 strike price for me, with the last trade at $76.41.
It could be you had an old web page that the function was extracting the
data from. You could check with:
=smfGetYahooOptionQuote("BG","C",DATE(2013,8,17),"OTM1","u")
...which would get you the price of the underlying from the same web page.
Otherwise, use the smfForceRecalculation macro to refresh all saved web
pages. See the LINKS area of the group for info on this macro.
Also, Yahoo can be unreliable with the OTMn and ITMn parameters, when Yahoo
carries multiple expiration dates on the same web page. I would suggest
using the smfGetOptionStrikes() function instead. There is an entry for a
step-by-step example of such option functions in the LINKS area of the
group.
On Tue, Jul 30, 2013 at 1:00 PM, nautilustech <nautilustech@yahoo.com >wrote:
>
> --- In smf_addin@yahoogroups.com , "nautilustech" <nautilustech@...> wrote:
> >
> > Bunge Group (Ticker BG) is currently trading at $76.55. This formula:
> >
> > smfGetYahooQuote("BG","C",DATE(2013,8,17),"OTM1","s")
> >
> > returns 75.00, which is an ITM strike price.
> >
> > Can anyone tell me what I'm doing wrong?
> >
> > Many thanks in advance.
>
> My error. The formula should be:
>
> =smfGetYahooOptionQuote("BG","C",DATE(2013,8,17),"OTM1","s")
>
It could be you had an old web page that the function was extracting the
data from. You could check with:
=smfGetYahooOptionQ
...which would get you the price of the underlying from the same web page.
Otherwise, use the smfForceRecalculati
pages. See the LINKS area of the group for info on this macro.
Also, Yahoo can be unreliable with the OTMn and ITMn parameters, when Yahoo
carries multiple expiration dates on the same web page. I would suggest
using the smfGetOptionStrikes
step-by-step example of such option functions in the LINKS area of the
group.
On Tue, Jul 30, 2013 at 1:00 PM, nautilustech <nautilustech@
>
> --- In smf_addin@yahoogrou
> >
> > Bunge Group (Ticker BG) is currently trading at $76.55. This formula:
> >
> > smfGetYahooQuote(
> >
> > returns 75.00, which is an ITM strike price.
> >
> > Can anyone tell me what I'm doing wrong?
> >
> > Many thanks in advance.
>
> My error. The formula should be:
>
> =smfGetYahooOptionQ
>
Tidak ada komentar:
Posting Komentar