Rabu, 30 November 2011

[smf_addin] Digest Number 2031[2 Attachments]

Messages In This Digest (22 Messages)

Messages

1a.

What url for HTMLGetTable for OX "All expirations"?

Posted by: "MikeM" mikemcq802@yahoo.com   mikemcq802

Tue Nov 29, 2011 8:13 am (PST)



Given the troubles with the other options providers I started to look at OptionsXpress. At least the data looks reliable.

I'm using the GetHTMLTable just fine but I'm only seeing the chain for Dec. On their webpage I can click on the Expiration dropdown to select "All" and I see them all - I just can't figure out how to configure the url to make that happen for the GetHTMLTable.

Here's what I started with. Any ideas appreciated.

=RCHGetHTMLTable("https://www.optionsxpress.com/OXNetTools/Chains/index.aspx?Symbol=INTC&ChainType\=o&Range=14&lstMonths=All;1",">OpInt",-1,"",4)

No matter what I put for "lstMonths=" I still only see the Dec chain for any ticker I try. I tried "1stMonths=", "Expiration=" and a couple others but the table returned always starts with Dec option chain.

Thanks

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (6)
1b.

Re: What url for HTMLGetTable for OX "All expirations"?

Posted by: "MikeM" mikemcq802@yahoo.com   mikemcq802

Tue Nov 29, 2011 8:34 am (PST)



Oh, I just realized I had a typo in the url but correcting it makes the retrieval not work at all. Note I had a \ after ChainType and before the equal sign. But, oddly, removing that \ causes the retrieval to not work at all. With the \ in place I always see just the Dec chain for whatever the ticker is. ???

thanks, mike

--- In smf_addin@yahoogroups.com, "MikeM" <mikemcq802@...> wrote:
>
> Given the troubles with the other options providers I started to look at OptionsXpress. At least the data looks reliable.
>
> I'm using the GetHTMLTable just fine but I'm only seeing the chain for Dec. On their webpage I can click on the Expiration dropdown to select "All" and I see them all - I just can't figure out how to configure the url to make that happen for the GetHTMLTable.
>
> Here's what I started with. Any ideas appreciated.
>
> =RCHGetHTMLTable("https://www.optionsxpress.com/OXNetTools/Chains/index.aspx?Symbol=INTC&ChainType\=o&Range=14&lstMonths=All;1",">OpInt",-1,"",4)
>
> No matter what I put for "lstMonths=" I still only see the Dec chain for any ticker I try. I tried "1stMonths=", "Expiration=" and a couple others but the table returned always starts with Dec option chain.
>
> Thanks
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (6)
1c.

Re: What url for HTMLGetTable for OX "All expirations"?

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Tue Nov 29, 2011 9:36 am (PST)



Yes -- since the changeover in options symbols, consistency of options data
has been an issue for Yahoo, Google, MSN, and MarketWatch. I was converting
everything over to Google, since it seemed to be the most reliable. But,
lately, they don't even have the weekly options.

In any case, this appears to work for me (note fewer parameters on the URL):

=RCHGetHTMLTable("
https://www.optionsxpress.com/OXNetTools/Chains/index.aspx?Symbol=INTC&lstMonths=12/17/2011;7
",">Chg",-1,"in-the-money",-3)

Or, if you want Implied Volatility and Delta instead of Open Interest:

=RCHGetHTMLTable("
https://www.optionsxpress.com/OXNetTools/Chains/index.aspx?Range=All&lstMarket=0&ChainType=14&lstMonths=12/17/2011;7&Symbol=INTC
",">Chg",-1,"in-the-money",-3)

However, without any identifiers on the row to tell you the months of the
options, you're going to need helper columns to determine expiration months
and other info.

I've never liked using RCHGetHTMLTable() for option tables. The size of
what's available simply varies too much from equity to equity, especially
if you sometimes use the index ETFs.

If I got the two new option functions working for OX (
http://finance.groups.yahoo.com/group/smf_addin/message/14130), it might
make them a lot easier to use. Although they are slower at web page
retrieval than the other data sources.

On Tue, Nov 29, 2011 at 9:13 AM, MikeM <mikemcq802@yahoo.com> wrote:

> Given the troubles with the other options providers I started to look at
> OptionsXpress. At least the data looks reliable.
>
> I'm using the GetHTMLTable just fine but I'm only seeing the chain for
> Dec. On their webpage I can click on the Expiration dropdown to select
> "All" and I see them all - I just can't figure out how to configure the url
> to make that happen for the GetHTMLTable.
>
> Here's what I started with. Any ideas appreciated.
>
> =RCHGetHTMLTable("
> https://www.optionsxpress.com/OXNetTools/Chains/index.aspx?Symbol=INTC&ChainType\=o&Range=14&lstMonths=All;1
> ",">OpInt",-1,"",4)
>
> No matter what I put for "lstMonths=" I still only see the Dec chain for
> any ticker I try. I tried "1stMonths=", "Expiration=" and a couple others
> but the table returned always starts with Dec option chain.
>
> Thanks
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (6)
1d.

Re: What url for HTMLGetTable for OX "All expirations"?

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Tue Nov 29, 2011 4:24 pm (PST)



I just uploaded a new beta version of the add-in to the "Works in Progress"
folder. I've added OptionsXpress as a possible data source for the new
smfGetOptionExpirations() and smfGetOptionStrikes() functions. I've also
added documentation for those two functions, as well as the two new utility
functions -- smfJoin() and smfWord().

On Tue, Nov 29, 2011 at 9:13 AM, MikeM <mikemcq802@yahoo.com> wrote:

> Given the troubles with the other options providers I started to look at
> OptionsXpress. At least the data looks reliable.
>
> I'm using the GetHTMLTable just fine but I'm only seeing the chain for
> Dec. On their webpage I can click on the Expiration dropdown to select
> "All" and I see them all - I just can't figure out how to configure the url
> to make that happen for the GetHTMLTable.
>
> Here's what I started with. Any ideas appreciated.
>
> =RCHGetHTMLTable("
> https://www.optionsxpress.com/OXNetTools/Chains/index.aspx?Symbol=INTC&ChainType\=o&Range=14&lstMonths=All;1
> ",">OpInt",-1,"",4)
>
> No matter what I put for "lstMonths=" I still only see the Dec chain for
> any ticker I try. I tried "1stMonths=", "Expiration=" and a couple others
> but the table returned always starts with Dec option chain.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (6)
1e.

Re: What url for HTMLGetTable for OX "All expirations"?

Posted by: "Mike McQuaid" mikemcq802@yahoo.com   mikemcq802

Tue Nov 29, 2011 9:37 pm (PST)

[Attachment(s) from Mike McQuaid included below]

I downloaded the Nov 29 beta with the new OX option functions (and smfJoin)
but can only retrieve 1 option quote using smfGetOptionQuotes when I
provided a cell that contained multiple smf ticker symbols (joined by
smfJoin).

I attached a sample spreadsheet.

My idea was:

Get list of expirations using smfGetOptionExpirations
From this expiry list, use GetOptionStrikes to generate ticker symbols with
multiple strikes for several Expiry dates
Use smfJoin to concatenate these ticker symbols into one cell
Use smfGetOptionQuotes to retrieve quotes for all of these tickers

Every smf function is array entered except for the Join.

I'm trying to create a clean, contiguous list of option chains for the next
several months. I used the getHTMLtable for OX and that got me the data I
wanted - although was a little ugly (not crucial). Was hoping these new
functions would give me a solution that wasn't as tightly tied to a specific
url format.

Pls let me know what's wrong.
Thanks, Mike

PS: One big advantage of OX and getHTMLTable is that I can get the volume
and open interest columns. These don't work for OX in GetOptionQuotes - it
would be great if it would :)

_____

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf
Of Randy Harmelink
Sent: Tuesday, November 29, 2011 7:24 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] What url for HTMLGetTable for OX "All expirations"?

I just uploaded a new beta version of the add-in to the "Works in Progress"
folder. I've added OptionsXpress as a possible data source for the new
smfGetOptionExpirations() and smfGetOptionStrikes() functions. I've also
added documentation for those two functions, as well as the two new utility
functions -- smfJoin() and smfWord().

On Tue, Nov 29, 2011 at 9:13 AM, MikeM <mikemcq802@yahoo.com> wrote:

Given the troubles with the other options providers I started to look at
OptionsXpress. At least the data looks reliable.

I'm using the GetHTMLTable just fine but I'm only seeing the chain for Dec.
On their webpage I can click on the Expiration dropdown to select "All" and
I see them all - I just can't figure out how to configure the url to make
that happen for the GetHTMLTable.

Here's what I started with. Any ideas appreciated.

=RCHGetHTMLTable("https://www.optionsxpress.com/OXNetTools/Chains/index.aspx
?Symbol=INTC
<https://www.optionsxpress.com/OXNetTools/Chains/index.aspx?Symbol=INTC&Chai
nType%5C=o&Range=14&lstMonths=All;1>
&ChainType\=o&Range=14&lstMonths=All;1",">OpInt",-1,"",4)

No matter what I put for "lstMonths=" I still only see the Dec chain for any
ticker I try. I tried "1stMonths=", "Expiration=" and a couple others but
the table returned always starts with Dec option chain.

Attachment(s) from Mike McQuaid

1 of 1 File(s)

Option Beta.xls
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (6)
1f.

Re: What url for HTMLGetTable for OX "All expirations"? [1 Attachmen

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Tue Nov 29, 2011 10:56 pm (PST)



Interesting -- the problem is that if you give it a cell or range reference
for the TIcker List, my expectation was that each cell would contain only
one ticker symbol. An easy fix (will upload soon). But, in fact, if you use
a "+" as the delimiters instead of commas, it would work for you right now.
You don't need the individual Join cells either -- you could do something
like:

=smfGetOptionQuotes(smfJoin(D5:D16,"+")&"+"&smfJoin(E5:E16,"+")&"+"&smfJoin(F5:F16,"+"),"xsba6",1,"OX2")

Another interesting item -- I see that you were only getting the first two
ITM and first two OTM strike prices for IBM even though you entered a range
of 12 cells, which should give you the first 6 of each. I was getting full
ranges in testing, but to get IBM's, I had to add a few more parameters to
the URL. Strange. Now I'm getting a full set of 12 strike prices for each
expiration date. When I upload a new beta version, it will include this
change.

Until your messages, I wasn't even aware of the web page with the open
interest and volume -- that it was available without a login. I'm
considering adding an "OX3" data source for that web page.

By the way, an easier way to do your process:

- Array-enter this formula in cells G5:R5:

IF(B5="","",TRANSPOSE(smfGetOptionStrikes($B$2,B5,"C","OX",1,12,1)))

- Now that the strike prices are all on a row with the expiration date,
you can just copy G5:R5 down into G6:R7 (or do more rows if you want). No
need to manually change any cell references for each range.

- Then you can use the smfJoin() with the entire range of transposed
ticker symbols:

=smfGetOptionQuotes(smfJoin(G5:R7,"+"),"xsba6",1,"OX2")

In fact, you could easily fill the entire G5:R16 range with that formula
and then use that entire range in the smfJoin() function, if you wanted to
get all available expiration dates.

Or, if you want to maintain the placement of all data -- have 12 rows for
each expiration date, you could simply do this in the final function:

=smfGetOptionQuotes(G5:R16,"xsba6",1,"OX2")

Since it processes by row and keeps a placeholder for blank ticker symbol
cells, everything should always be in the same place, grouped by expiration
date.

On Tue, Nov 29, 2011 at 10:38 PM, Mike McQuaid <mikemcq802@yahoo.com> wrote:

> **
>
> I downloaded the Nov 29 beta with the new OX option functions (and
> smfJoin) but can only retrieve 1 option quote using smfGetOptionQuotes when
> I provided a cell that contained multiple smf ticker symbols (joined by
> smfJoin).
>
> I attached a sample spreadsheet.
>
> My idea was:
>
> Get list of expirations using smfGetOptionExpirations
> From this expiry list, use GetOptionStrikes to generate ticker symbols
> with multiple strikes for several Expiry dates
> Use smfJoin to concatenate these ticker symbols into one cell
> Use smfGetOptionQuotes to retrieve quotes for all of these tickers
>
> Every smf function is array entered except for the Join.
>
> I'm trying to create a clean, contiguous list of option chains for the
> next several months. I used the getHTMLtable for OX and that got me the
> data I wanted - although was a little ugly (not crucial). Was hoping these
> new functions would give me a solution that wasn't as tightly tied to a
> specific url format.
>
> Pls let me know what's wrong.
> Thanks, Mike
>
> PS: One big advantage of OX and getHTMLTable is that I can get the volume
> and open interest columns. These don't work for OX in GetOptionQuotes - it
> would be great if it would :)
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (6)
2a.

Re: question on refresh and forcerecalculation

Posted by: "Ashish" ashishkm@yahoo.com   ashishkm

Tue Nov 29, 2011 3:46 pm (PST)



Hi Randy .... Is this CSV file available somewhere? ... If so, how to get access to it? ...Thanks ...

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> NOW() is a volatile function, so it makes the RCHGetYahooQuotes() function
> volatile. Then, whenever a change is made in the worksheet, or if you
> request recalculation via something like the F9 key, it will trigger a
> recalculation by EXCEL.
>
> Since this function retrieves a CSV file, there is no web page to
> re-download. But it does get a new copy of the CSV file -- ALWAYS. That's
> because the entire file is consumed whenever the function is run. Other
> functions, like RCHGetTableCell(), only get a single item off of the web
> page it is getting the data from. I store the web page first, then extract
> the data from the stored copy of the web page, because otherwise every
> function getting another data item from the same URL would need to retrieve
> the web page again -- which would be VERY slow.
>
> But that's also why RCHGetYahooQuotes() should be used as an array-entered
> function -- if you use individual functions, EACH function goes back to the
> Internet EVERY TIME it recalculates. But, as an array-entered function, it
> can retrieve thousands of data items with a single Internet access. That's
> a much faster recalculation. :)
>
> On Thu, Nov 17, 2011 at 5:29 AM, wu_ming_sg <nghongchong@...> wrote:
>
> >
> > When I use eg. "RCHGetYahooQuotes(Ticker,"v",,NOW())", how does it renew
> > its data?
> >
> > Does it re-download the webpage just like SMFForceReCalculation?
> >
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)
2b.

Re: question on refresh and forcerecalculation

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Tue Nov 29, 2011 4:01 pm (PST)



One is available on almost every Yahoo stock quotes or portfolio page. For
example:

http://finance.yahoo.com/q?s=MMM

Look for the "Download Data (delayed)" link on the lowest area of the
right-most column of text. You should see something like:

http://download.finance.yahoo.com/d/quotes.csv?s=MMM&f=sl1d1t1c1ohgv&e=.csv

All the RCHGetYahooQuotes() function does is create the ticker symbols
(i.e. "s=...") and data codes (i.e. "&f=...") URL parameters based on the
function parameters it was given. If you go to a portfolio page on Yahoo,
you'll see a similar download link for the portfolio.

On Tue, Nov 29, 2011 at 4:46 PM, Ashish <ashishkm@yahoo.com> wrote:

> Hi Randy .... Is this CSV file available somewhere? ... If so, how to get
> access to it? ...Thanks ...
>
> --- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
> >
> > NOW() is a volatile function, so it makes the RCHGetYahooQuotes()
> function
> > volatile. Then, whenever a change is made in the worksheet, or if you
> > request recalculation via something like the F9 key, it will trigger a
> > recalculation by EXCEL.
> >
> > Since this function retrieves a CSV file, there is no web page to
> > re-download. But it does get a new copy of the CSV file -- ALWAYS. That's
> > because the entire file is consumed whenever the function is run. Other
> > functions, like RCHGetTableCell(), only get a single item off of the web
> > page it is getting the data from. I store the web page first, then
> extract
> > the data from the stored copy of the web page, because otherwise every
> > function getting another data item from the same URL would need to
> retrieve
> > the web page again -- which would be VERY slow.
> >
> > But that's also why RCHGetYahooQuotes() should be used as an
> array-entered
> > function -- if you use individual functions, EACH function goes back to
> the
> > Internet EVERY TIME it recalculates. But, as an array-entered function,
> it
> > can retrieve thousands of data items with a single Internet access.
> That's
> > a much faster recalculation. :)
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)
3a.

smfGetOptionQuotes

Posted by: "Ashish" ashishkm@yahoo.com   ashishkm

Tue Nov 29, 2011 4:15 pm (PST)



I am wondering why I am observing times of 12:55PM EST thru 1:09PM EST for a set of options for which I downloaded data even though the last time I did that was around 5PM EST !!!

I used smfGETOptionQuotes function with "t" option in an array ....

What may I be doing wrong?

Thanks

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (17)
3b.

Re: smfGetOptionQuotes

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Tue Nov 29, 2011 4:47 pm (PST)



Check items 9.5 and 9.4.2 in the "Links" area of the group.

At this point, I have no idea what "downloaded" means in your description
below. Various times would lead me to believe either IE is caching the web
pages, or you are changing parameters of some functions but not others. It
all depends on how your functions are entered and are updated. But you
didn't give any specific examples...

OTOH, if they are not heavily traded options, they could easily have not
been traded since those times.

Also, note that the "t" choice comes from a different web page than the
"Fast" items like bid or ask prices, so it might not accurately reflect
them.

Array-entering the smfGetOptionQuotes() function doesn't really speed
anything up. It still has to access the Internet the same number of times.
It was just done to have some consistency with how RCHGetYahooQuotes() is
used.

On Tue, Nov 29, 2011 at 5:15 PM, Ashish <ashishkm@yahoo.com> wrote:

> I am wondering why I am observing times of 12:55PM EST thru 1:09PM EST for
> a set of options for which I downloaded data even though the last time I
> did that was around 5PM EST !!!
>
> I used smfGETOptionQuotes function with "t" option in an array ....
>
> What may I be doing wrong?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (17)
3c.

Re: smfGetOptionQuotes

Posted by: "Ashish Mukerji" ashishkm@yahoo.com   ashishkm

Tue Nov 29, 2011 8:28 pm (PST)

[Attachment(s) from Ashish Mukerji included below]

Based upon one of the Links that you mentioned I did go through Internet Browser Option to properly "toggle switch" by chosing the button "Evry Time I Visit the Web Page" and then tried Ctrl+Shift+Enter the Excel sheet using the function smfGetOptionQuotes() .... The result did not make any difference to the outcome and the image of the sheet is attached .... Obviously, I am not doing something right ... ???? .... Thanks ...

 
Ashish         

>________________________________
> From: Randy Harmelink <rharmelink@gmail.com>
>To: smf_addin@yahoogroups.com
>Sent: Tuesday, November 29, 2011 7:47 PM
>Subject: Re: [smf_addin] smfGetOptionQuotes
>
>
> 
>Check items 9.5 and 9.4.2 in the "Links" area of the group.
>
>At this point, I have no idea what "downloaded" means in your description below. Various times would lead me to believe either IE is caching the web pages, or you are changing parameters of some functions but not others. It all depends on how your functions are entered and are updated. But you didn't give any specific examples...
>
>OTOH, if they are not heavily traded options, they could easily have not been traded since those times.
>
>Also, note that the "t" choice comes from a different web page than the "Fast" items like bid or ask prices, so it might not accurately reflect them.
>
>Array-entering the smfGetOptionQuotes() function doesn't really speed anything up. It still has to access the Internet the same number of times. It was just done to have some consistency with how RCHGetYahooQuotes() is used.
>
>
>On Tue, Nov 29, 2011 at 5:15 PM, Ashish <ashishkm@yahoo.com> wrote:
>
>I am wondering why I am observing times of 12:55PM EST thru 1:09PM EST for a set of options for which I downloaded data even though the last time I did that was around 5PM EST !!!
>>
>>I used smfGETOptionQuotes function with "t" option in an array ....
>>
>>What may I be doing wrong?
>>
>
>
>
>

Attachment(s) from Ashish Mukerji

1 of 1 File(s)

smfGetOptionQuotes.doc
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (17)
3d.

Re: smfGetOptionQuotes [1 Attachment]

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Tue Nov 29, 2011 8:42 pm (PST)



Re-entering the smfGetOptionQuotes() formula with Ctrl+Shift+Enter would
NOT update anything. You would still have the same saved web pages in VBA,
from which the add-in is extracting the data, so it would just re-extract
the exact same data. That's the "Overview" processing described in one of
the "Link" area entries.

That's why you need to run the smfForceRecalculation macro -- it purges the
saved web pages from the add-in, so that fresh copies will be retrieved.

On Tue, Nov 29, 2011 at 9:28 PM, Ashish Mukerji <ashishkm@yahoo.com> wrote:

>
> Based upon one of the Links that you mentioned I did go through Internet
> Browser Option to properly "toggle switch" by chosing the button "Evry Time
> I Visit the Web Page" and then tried Ctrl+Shift+Enter the Excel sheet using
> the function smfGetOptionQuotes() .... The result did not make any
> difference to the outcome and the image of the sheet is attached ....
> Obviously, I am not doing something right ... ???? ....
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (17)
3e.

Re: smfGetOptionQuotes

Posted by: "Ashish Mukerji" ashishkm@yahoo.com   ashishkm

Tue Nov 29, 2011 9:06 pm (PST)



Thanks .... Took a while but it did refresh the data and time stamp ....

 
Ashish         

>________________________________
> From: Randy Harmelink <rharmelink@gmail.com>
>To: smf_addin@yahoogroups.com
>Sent: Tuesday, November 29, 2011 11:42 PM
>Subject: Re: [smf_addin] smfGetOptionQuotes
>
>
> 
>Re-entering the smfGetOptionQuotes() formula with Ctrl+Shift+Enter would NOT update anything. You would still have the same saved web pages in VBA, from which the add-in is extracting the data, so it would just re-extract the exact same data. That's the "Overview" processing described in one of the "Link" area entries.
>
>That's why you need to run the smfForceRecalculation macro -- it purges the saved web pages from the add-in, so that fresh copies will be retrieved.
>
>
>On Tue, Nov 29, 2011 at 9:28 PM, Ashish Mukerji <ashishkm@yahoo.com> wrote:
>
>
>>
>>Based upon one of the Links that you mentioned I did go through Internet Browser Option to properly "toggle switch" by chosing the button "Evry Time I Visit the Web Page" and then tried Ctrl+Shift+Enter the Excel sheet using the function smfGetOptionQuotes() .... The result did not make any difference to the outcome and the image of the sheet is attached .... Obviously, I am not doing something right ... ???? ....
>>
>
>
>
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (17)
3f.

Re: smfGetOptionQuotes

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Tue Nov 29, 2011 9:12 pm (PST)



Well, like I said earlier, the "time stamp" is a slow item -- it needs to
get a new web page for EACH one of those when smfForceRecalculation is run.

On Tue, Nov 29, 2011 at 10:06 PM, Ashish Mukerji <ashishkm@yahoo.com> wrote:

>
> Thanks .... Took a while but it did refresh the data and time stamp ....
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (17)
4a.

Why do negative P/E ratios from morningstar show as 0?

Posted by: "Les S" dolce7ss@yahoo.com   dolce7ss

Tue Nov 29, 2011 9:05 pm (PST)



If you go to morningstar valuation tab and take Citigroup for example:

2010 P/E was 13.5, so =RCHGetElementNumber("c",13970) shows 13.5
2009 P/E was -4.4, but =RCHGetElementNumber("c",13969) shows 0

Am I doing something wrong?

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)
4b.

Re: Why do negative P/E ratios from morningstar show as 0?

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Tue Nov 29, 2011 9:09 pm (PST)



When I go to the web page:

http://quicktake.morningstar.com/stocknet/Valuation10.aspx?Symbol=C

...it shows no 2009 P/E, which is why it is set to 0.

On Tue, Nov 29, 2011 at 10:04 PM, Les S <dolce7ss@yahoo.com> wrote:

> If you go to morningstar valuation tab and take Citigroup for example:
>
> 2010 P/E was 13.5, so =RCHGetElementNumber("c",13970) shows 13.5
> 2009 P/E was -4.4, but =RCHGetElementNumber("c",13969) shows 0
>
> Am I doing something wrong?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)
4c.

Re: Why do negative P/E ratios from morningstar show as 0?

Posted by: "Les S" dolce7ss@yahoo.com   dolce7ss

Tue Nov 29, 2011 9:34 pm (PST)



I see, thanks. Any way to tap into the javascript of the main morningstar page? http://financials.morningstar.com/valuation/price-ratio.html?t=C

Or is that the limit for now?

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> When I go to the web page:
>
> http://quicktake.morningstar.com/stocknet/Valuation10.aspx?Symbol=C
>
> ...it shows no 2009 P/E, which is why it is set to 0.
>
> On Tue, Nov 29, 2011 at 10:04 PM, Les S <dolce7ss@...> wrote:
>
> > If you go to morningstar valuation tab and take Citigroup for example:
> >
> > 2010 P/E was 13.5, so =RCHGetElementNumber("c",13970) shows 13.5
> > 2009 P/E was -4.4, but =RCHGetElementNumber("c",13969) shows 0
> >
> > Am I doing something wrong?
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)
4d.

Re: Why do negative P/E ratios from morningstar show as 0?

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Tue Nov 29, 2011 10:03 pm (PST)



Unfortunately that page is dynamically generated, so there is nothing in
the source code of the web page for the add-in to extract. However, the
data from that page you're interested in actually comes from here:

http://financials.morningstar.com/valuation/valuation-history.action?t=C&type=price-earnings

So, this appears to work, but the page is not a real HTML page, but one to
be consumed by JavaScript:

=RCHGetTableCell("
http://financials.morningstar.com/valuation/valuation-history.action?t=C&type=price-earnings
",9,"abbr=""Price/Earnings")

On Tue, Nov 29, 2011 at 10:34 PM, Les S <dolce7ss@yahoo.com> wrote:

> I see, thanks. Any way to tap into the javascript of the main morningstar
> page? http://financials.morningstar.com/valuation/price-ratio.html?t=C
>
> Or is that the limit for now?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)
5a.

Bloomberg.com refresh

Posted by: "taurines_morgan" taurines_morgan@yahoo.fr   taurines_morgan

Tue Nov 29, 2011 9:52 pm (PST)



Hi,

Just used the RCHGetTableCell to get yields of countries from www.bloomberg.com
As I want different maturities for different ticker, I use many times this function so It takes a while to get the whole set

Does someone knows how can I optimize that like the GetYahooQuotes?

thks

rgds,

Morgan

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
5b.

Re: Bloomberg.com refresh

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Tue Nov 29, 2011 11:06 pm (PST)



RCHGetYahooQuotes() is fast when array-entered because Yahoo provides all
of the data in a CSV file with a single Internet access. I don't know of
anything on Bloomberg like that -- but I only rarely use Bloomberg.

On Tue, Nov 29, 2011 at 10:27 PM, taurines_morgan
<taurines_morgan@yahoo.fr>wrote:

>
> Just used the RCHGetTableCell to get yields of countries from
> www.bloomberg.com
> As I want different maturities for different ticker, I use many times this
> function so It takes a while to get the whole set
>
> Does someone knows how can I optimize that like the GetYahooQuotes?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
6a.

Data from Bloomberg Chart

Posted by: "newengwongpeggy" tong82@gmail.com   newengwongpeggy

Tue Nov 29, 2011 10:19 pm (PST)



hi Randy,

Is it possible to extract data from the chart?
http://www.bloomberg.com/apps/quote?ticker=GDBR10:IND

thx
Ant

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
6b.

Re: Data from Bloomberg Chart

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Tue Nov 29, 2011 11:10 pm (PST)



Nope, sorry. One chart is an image, the other is a Flash application.
Neither has source code data that is extractable by the add-in.

On Tue, Nov 29, 2011 at 11:19 PM, newengwongpeggy <tong82@gmail.com> wrote:

>
> Is it possible to extract data from the chart?
> http://www.bloomberg.com/apps/quote?ticker=GDBR10:IND
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
Recent Activity
Visit Your Group
New web site?

Drive traffic now.

Get your business

on Yahoo! search.

Yahoo! Finance

It's Now Personal

Guides, news,

advice & more.

Yahoo! News

Odd News

You won't believe

it, but it's true

Need to Reply?

Click one of the "Reply" links to respond to a specific message in the Daily Digest.

Create New Topic | Visit Your Group on the Web
MARKETPLACE

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.

Diposting oleh EXCEL FEED LEARNING di 02.17

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)