15 Messages
Digest #3148
Messages
Wed Aug 13, 2014 6:16 am (PDT) . Posted by:
cgrauballe
Hi all, new to this page! Big fan already!!
I have a question though, if anyone has time. Im trying to get the data from the quote page of a stock, for example I want the market capitalization for a given stock. I've tried. Gettablecell, GetHTMLtable, extract..... Everything, but it seems like the information isn't in any table!
HOpe anyone has time, thx!
Best regards Caspar
NRDEF Nordea Bank AB PINX:NRDEF Stock Quote Price News http://quotes.morningstar.com/stock/nrdef/s?t=NRDEF
NRDEF Nordea Bank AB PINX:NRDEF Stock Quote Price News http://quotes.morningstar.com/stock/nrdef/s?t=NRDEF Today's real-time NRDEF stock quote Nordea Bank AB ticker symbol PINX:NRDEF price, news, financial statements, historical, balance sheet.
View on quotes.morningstar.com http://quotes.morningstar.com/stock/nrdef/s?t=NRDEF
Preview by Yahoo
Wed Aug 13, 2014 6:29 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Most of the MorningStar web pages are dynamically created. That means the
data is not delivered within the source code of the web page. The add-in
extracts data from the delivered source code, so if it's not there, it
can't extract it. However, they do have much of their data on static web
pages, which they use to create that dynamic web page.
For example, the Market Cap can be extracted from this web page:
=smfConvertData(smfGetTagContent("
http://quotes.morningstar.com/stock/c-header?t=NRDEF
","span",0,"id=""MarketCap"""))
At the moment, both the web page you cited, and the web page above, have no
market cap on them. I have no idea why.
Note that the data on the above page is NOT within a table. They simulate a
table using "span" HTML tags.
On Wed, Aug 13, 2014 at 6:01 AM, cgrauballe@... wrote:
> Hi all, new to this page! Big fan already!!
>
> I have a question though, if anyone has time. Im trying to get the data
> from the quote page of a stock, for example I want the market
> capitalization for a given stock. I've tried. Gettablecell, GetHTMLtable,
> extract..... Everything, but it seems like the information isn't in any
> table!
>
> HOpe anyone has time, thx!
>
> Best regards Caspar
>
> NRDEF Nordea Bank AB PINX:NRDEF Stock Quote Price News
> <http://quotes.morningstar.com/stock/nrdef/s?t=NRDEF>
>
data is not delivered within the source code of the web page. The add-in
extracts data from the delivered source code, so if it's not there, it
can't extract it. However, they do have much of their data on static web
pages, which they use to create that dynamic web page.
For example, the Market Cap can be extracted from this web page:
=smfConvertData(smfGetTagContent("
http://quotes.morningstar.com/stock/c-header?t=NRDEF
","span",0,"id=""MarketCap"""))
At the moment, both the web page you cited, and the web page above, have no
market cap on them. I have no idea why.
Note that the data on the above page is NOT within a table. They simulate a
table using "span" HTML tags.
On Wed, Aug 13, 2014 at 6:01 AM, cgrauballe@... wrote:
> Hi all, new to this page! Big fan already!!
>
> I have a question though, if anyone has time. Im trying to get the data
> from the quote page of a stock, for example I want the market
> capitalization for a given stock. I've tried. Gettablecell, GetHTMLtable,
> extract..... Everything, but it seems like the information isn't in any
> table!
>
> HOpe anyone has time, thx!
>
> Best regards Caspar
>
> NRDEF Nordea Bank AB PINX:NRDEF Stock Quote Price News
> <http://quotes.morningstar.com/stock/nrdef/s?t=NRDEF>
>
Wed Aug 13, 2014 7:30 am (PDT) . Posted by:
cgrauballe
Thank you Randy!! Perfect!
How did you find that exact webpage? did you study the HTML code or?
I think the missing market cap is because its a small Danish company
How did you find that exact webpage? did you study the HTML code or?
I think the missing market cap is because its a small Danish company
Wed Aug 13, 2014 7:31 am (PDT) . Posted by:
cgrauballe
Thx Randy! Just pefect!! How did you find that webpage if I may ask? by studying the HTML table?
I think there isn't any data on the company because its a Danish one, and not that big!
I think there isn't any data on the company because its a Danish one, and not that big!
Wed Aug 13, 2014 7:53 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
I don't recall the exact process I used to get that particular file name.
It's usually one of two methods:
1. Examining the source code of the web page and associated JavaScript
files.
2. Using HTTPFox (a FireFox add-in) to monitor which HTTP requests were
made from FireFox.
What works may depend on how the website does their processing. And, of
course, sometimes it can't be done,
On Wed, Aug 13, 2014 at 7:30 AM, cgrauballe@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> How did you find that exact webpage? did you study the HTML code or?
>
> I think the missing market cap is because its a small Danish company
>
It's usually one of two methods:
1. Examining the source code of the web page and associated JavaScript
files.
2. Using HTTPFox (a FireFox add-in) to monitor which HTTP requests were
made from FireFox.
What works may depend on how the website does their processing. And, of
course, sometimes it can't be done,
On Wed, Aug 13, 2014 at 7:30 AM, cgrauballe@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> How did you find that exact webpage? did you study the HTML code or?
>
> I think the missing market cap is because its a small Danish company
>
Wed Aug 13, 2014 10:23 am (PDT) . Posted by:
cgrauballe
Thanks a lot! hadn't heard about that add in! but great tool!I was wondering if you could help me with the following aswell, for example if i want to get the industry peer group: http://financials.morningstar.com/competitors/industry-peer-data.action?type=com&t=MSFT http://financials.morningstar.com/competitors/industry-peer-data.action?type=com&t=MSFTIve tried the following with no result:
=RCHGetHTMLTable("http://financials.morningstar.com/competitors/industry-peer-data.action?type=com&t="&TICKER,"Industry Peers MSFT",-1,"",1)=smfConvertData(smfGetTagContent("http://financials.morningstar.com/competitors/industry-peer-data.action?type=com&t="&TICKER,"span",0,"class=""r_table1 r_txt2""")Best regards Caspar
=RCHGetHTMLTable("http://financials.morningstar.com/competitors/industry-peer-data.action?type=com&t="&TICKER,"Industry Peers MSFT",-1,"",1)=smfConvertData(smfGetTagContent("http://financials.morningstar.com/competitors/industry-peer-data.action?type=com&t="&TICKER,
Wed Aug 13, 2014 12:08 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Three problems with the RCHGetHTMLTable() function:
1. In the source code, "Industry Peers" and "MSFT" are not together as you
have them. They have HTML code between them. When the easy way doesn't
work, you need to look at the source code of the web page.
2. Including "MSFT" in the search term isn't a good idea, since the web
page would only have that value when your "Ticker" cell contained MSFT as
the ticker symbol for the URL as well.
3. Even if you had used "Industry Peers" as a search term, it is outside of
the table. So the -1 direction would look for a previous table. I usually
use one of the column headers as my search string, and then using the -1 to
go backward works. However, you could have used your search term and said
the table was after it, as in:
=RCHGetHTMLTable("
http://financials.morningstar.com/competitors/industry-peer-data.action?type=com&t="&B2,"Industry
Peers",1,"",1)
With a column header of the table, it might have looked like this:
=RCHGetHTMLTable("
http://financials.morningstar.com/competitors/industry-peer-data.action?type=com&t=
"&B2,"P/S",-1,"",1)
I'm not sure what you were trying to achieve with the smfGetTagContent()
function?
On Wed, Aug 13, 2014 at 10:23 AM, cgrauballe@... wrote:
>
> Thanks a lot! hadn't heard about that add in! but great tool!I was
> wondering if you could help me with the following aswell, for example if i
> want to get the industry peer group:
> http://financials.morningstar.com/competitors/industry-peer-data.action?type=com&t=MSFTIve
> tried the following with no result:
>
> =RCHGetHTMLTable("
> http://financials.morningstar.com/competitors/industry-peer-data.action?type=com&t="&TICKER,"Industry
> Peers MSFT",-1,"",1)=smfConvertData(smfGetTagContent("
> http://financials.morningstar.com/competitors/industry-peer-data.action?type=com&t="&TICKER,"span",0,"class=""r_table1
> r_txt2""")Best regards Caspar
>
1. In the source code, "Industry Peers" and "MSFT" are not together as you
have them. They have HTML code between them. When the easy way doesn't
work, you need to look at the source code of the web page.
2. Including "MSFT" in the search term isn't a good idea, since the web
page would only have that value when your "Ticker" cell contained MSFT as
the ticker symbol for the URL as well.
3. Even if you had used "Industry Peers" as a search term, it is outside of
the table. So the -1 direction would look for a previous table. I usually
use one of the column headers as my search string, and then using the -1 to
go backward works. However, you could have used your search term and said
the table was after it, as in:
=RCHGetHTMLTable("
http://financials.morningstar.com/competitors/industry-peer-data.action?type=com&t="&B2,"Industry
Peers",1,"",1)
With a column header of the table, it might have looked like this:
=RCHGetHTMLTable("
http://financials.morningstar.com/competitors/industry-peer-data.action?type=com&t=
"&B2,"P/S",-1,"",1)
I'm not sure what you were trying to achieve with the smfGetTagContent()
function?
On Wed, Aug 13, 2014 at 10:23 AM, cgrauballe@... wrote:
>
> Thanks a lot! hadn't heard about that add in! but great tool!I was
> wondering if you could help me with the following aswell, for example if i
> want to get the industry peer group:
> http://financials.morningstar.com/competitors/industry-peer-data.action?type=com&t=MSFTIve
> tried the following with no result:
>
> =RCHGetHTMLTable("
> http://financials.morningstar.com/competitors/industry-peer-data.action?type=com&t="&TICKER,"Industry
> Peers MSFT",-1,"",1)=smfConvertData(smfGetTagContent("
> http://financials.morningstar.com/competitors/industry-peer-data.action?type=com&t="&TICKER,
> r_txt2"
>
Wed Aug 13, 2014 11:24 am (PDT) . Posted by:
c2adf9311e2c386ea6b50154ae931d42
I am using excel 2007 and can't find much working code with ETF funds, particularly with 3 mo, 1 yr, 3 yr and YTD returns. Can you please advise if there is a direct quote I can use or a working code number? Thank you.
Wed Aug 13, 2014 11:54 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
These elements are available for the RCHGetElementNumber() function:
*#* *Usage* *Source* *Element* 4943 EF YahooPM Fund Performance -- Fund
Return -- Year To Date 4944 EF YahooPM Fund Performance -- Fund Return --
1-Month 4945 EF YahooPM Fund Performance -- Fund Return -- 3-Month 4946 EF
YahooPM Fund Performance -- Fund Return -- 1-Year 4947 EF YahooPM Fund
Performance -- Fund Return -- 3-Year 4948 EF YahooPM Fund Performance --
Fund Return -- 5-Year
However, I usually use the smfPricesByDates() function, because it gives me
the freedom to do whatever periods I choose. The two templates on the web
site may help:
http://ogres-crypt.com/SMF/Templates/#smfPricesByDates%28%29
On Wed, Aug 13, 2014 at 11:17 AM, sdglobe@... wrote:
> I am using excel 2007 and can't find much working code with ETF funds,
> particularly with 3 mo, 1 yr, 3 yr and YTD returns. Can you please advise
> if there is a direct quote I can use or a working code number? Thank you.
>
*#* *Usage* *Source* *Element* 4943 EF YahooPM Fund Performance -- Fund
Return -- Year To Date 4944 EF YahooPM Fund Performance -- Fund Return --
1-Month 4945 EF YahooPM Fund Performance -- Fund Return -- 3-Month 4946 EF
YahooPM Fund Performance -- Fund Return -- 1-Year 4947 EF YahooPM Fund
Performance -- Fund Return -- 3-Year 4948 EF YahooPM Fund Performance --
Fund Return -- 5-Year
However, I usually use the smfPricesByDates() function, because it gives me
the freedom to do whatever periods I choose. The two templates on the web
site may help:
http://ogres-crypt.com/SMF/Templates/#smfPricesByDates%28%29
On Wed, Aug 13, 2014 at 11:17 AM, sdglobe@... wrote:
> I am using excel 2007 and can't find much working code with ETF funds,
> particularly with 3 mo, 1 yr, 3 yr and YTD returns. Can you please advise
> if there is a direct quote I can use or a working code number? Thank you.
>
Wed Aug 13, 2014 12:34 pm (PDT) . Posted by:
c2adf9311e2c386ea6b50154ae931d42
Thank you very much for the prompt response. much appreciated.
Wed Aug 13, 2014 11:24 am (PDT) . Posted by:
dstange1978
How can I run smfForceRecalculation every minute automaticaly?
Wed Aug 13, 2014 11:27 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
You'd need to have VBA code doing it. There's an example of one here:
http://ogres-crypt.com/SMF/Templates/RCHGetYahooQuotes-Example-Timed-Update.xls
On Wed, Aug 13, 2014 at 11:24 AM, danielcs@floripa.com.br [smf_addin] <
smf_addin@yahoogroups.com> wrote:
> How can I run smfForceRecalculation every minute automaticaly?
>
http://ogres-crypt.com/SMF/Templates/RCHGetYahooQuotes-Example-Timed-Update.xls
On Wed, Aug 13, 2014 at 11:24 AM, danielcs@floripa.com.br [smf_addin] <
smf_addin@yahoogroups.com> wrote:
> How can I run smfForceRecalculati
>
Wed Aug 13, 2014 11:33 am (PDT) . Posted by:
"Scott Hutchens" shhutchens6
I have a list of about 1000 stocks that I created a model for using the addin, which is awesome! I have been having trouble getting the composite rating from IBD. I am a subscriber. I used the IBD stock checkup template to get just the composite rating for my ticker list. I created the security cookie and logged in. I broke up the list into 300 ticker symbols per sheet so the addin doesn't get overwhelmed. The first sheet uploads fine and I am happy. I close excel and open the list 301-600 calculate it manually and it comes back with errors. For some reason it only wants to calculate the first sheet I choose no matter which one. I have tried the smfforcerecalculation macro with no luck. I have noticed that sometimes when I login to IBD and click stock checkup and enter a symbol say MMM it directs me to a product details page half the time, which leads me to believe that this is where the addin gets confused and returns errors. I noticed that IBD has been working on their site recently. Is there another way to get the composite rating from IBD? Maybe through the stocks lists page? Any help would be appreciated. And thank you so much for creating this powerful tool!
Sent from my iPad
Sent from my iPad
Wed Aug 13, 2014 11:44 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
It's probably because IBD's TOS limits you to 300 Stock Checkups in a
24-hour period.
On Wed, Aug 13, 2014 at 11:32 AM, Scott Hutchens shhutchens6@... wrote:
> I have a list of about 1000 stocks that I created a model for using the
> addin, which is awesome! I have been having trouble getting the composite
> rating from IBD. I am a subscriber. I used the IBD stock checkup template
> to get just the composite rating for my ticker list. I created the security
> cookie and logged in. I broke up the list into 300 ticker symbols per sheet
> so the addin doesn't get overwhelmed. The first sheet uploads fine and I am
> happy. I close excel and open the list 301-600 calculate it manually and it
> comes back with errors. For some reason it only wants to calculate the
> first sheet I choose no matter which one. I have tried the
> smfforcerecalculation macro with no luck. I have noticed that sometimes
> when I login to IBD and click stock checkup and enter a symbol say MMM it
> directs me to a product details page half the time, which leads me to
> believe that this is where the addin gets confused and returns errors. I
> noticed that IBD has been working on their site recently. Is there another
> way to get the composite rating from IBD? Maybe through the stocks lists
> page? Any help would be appreciated. And thank you so much for creating
> this powerful tool!
>
24-hour period.
On Wed, Aug 13, 2014 at 11:32 AM, Scott Hutchens shhutchens6@
> I have a list of about 1000 stocks that I created a model for using the
> addin, which is awesome! I have been having trouble getting the composite
> rating from IBD. I am a subscriber. I used the IBD stock checkup template
> to get just the composite rating for my ticker list. I created the security
> cookie and logged in. I broke up the list into 300 ticker symbols per sheet
> so the addin doesn't get overwhelmed. The first sheet uploads fine and I am
> happy. I close excel and open the list 301-600 calculate it manually and it
> comes back with errors. For some reason it only wants to calculate the
> first sheet I choose no matter which one. I have tried the
> smfforcerecalculati
> when I login to IBD and click stock checkup and enter a symbol say MMM it
> directs me to a product details page half the time, which leads me to
> believe that this is where the addin gets confused and returns errors. I
> noticed that IBD has been working on their site recently. Is there another
> way to get the composite rating from IBD? Maybe through the stocks lists
> page? Any help would be appreciated. And thank you so much for creating
> this powerful tool!
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar