13 New Messages
Digest #2864
Messages
Tue Nov 19, 2013 6:48 am (PST) . Posted by:
vasim_07
Hi,
I wanted to get the profit and lose table (whole table) from the following link..
http://www.moneycontrol.com/financials/libertyshoes/consolidated-profit-loss/LS02 http://www.moneycontrol.com/financials/libertyshoes/consolidated-profit-loss/LS02
I tried,
=RCHGetHTMLTable(A1,A2,-1,"",1)
A1 = Link & A2 = Sales Turnover.
which results display on first row (not the entire table)
| Mar '12 | Mar '11 | Mar '10 |....
Any help to get the entire table please.
I wanted to get the profit and lose table (whole table) from the following link..
http://www.moneycon
I tried,
=RCHGetHTMLTable(
A1 = Link & A2 = Sales Turnover.
which results display on first row (not the entire table)
| Mar '12 | Mar '11 | Mar '10 |....
Any help to get the entire table please.
Tue Nov 19, 2013 8:26 am (PST) . Posted by:
"Randy Harmelink" rharmelink
You won't be able to use the RCHGetHTMLTable() function there. They don't
have the table properly coded in HTML. They have spacer rows with no ending
tag for the row. It looks like RCHGetTableCell() would work, to get the
individual cells. For example:
=RCHGetTableCell("
http://www.moneycontrol.com/financials/libertyshoes/consolidated-profit-loss/LS02",1,">Sales
Turnover")
There is an additional parameter for RCHGetHTMLTable() that I had played
around with at one point, to extract *rows* of a table instead of whole
tables. Then, the "pDir1" and "pDir2" parameters skip backwards and
forwards by rows instead of tables. If you use that parameter, you can
extract sections of the table by avoiding the improperly coded rows.
For example, you could array-enter this over a 6-column by 15-row range:
=RCHGetHTMLTable("
http://www.moneycontrol.com/financials/libertyshoes/consolidated-profit-loss/LS02",">Sales
Turnover",-1,"",15,1)
...and this over a 6-column by 23-row range:
=RCHGetHTMLTable("
http://www.moneycontrol.com/financials/libertyshoes/consolidated-profit-loss/LS02",">Operating
Profit",-1,"",23,1)
On Tue, Nov 19, 2013 at 7:12 AM, <vasim_07@yahoo.com> wrote:
>
> I wanted to get the profit and lose table (whole table) from the following
> link..
>
>
> http://www.moneycontrol.com/financials/libertyshoes/consolidated-profit-loss/LS02
>
> I tried,
>
> =RCHGetHTMLTable(A1,A2,-1,"",1)
> A1 = Link & A2 = Sales Turnover.
>
> which results display on first row (not the entire table)
> | Mar '12 | Mar '11 | Mar '10 |....
>
> Any help to get the entire table please.
>
have the table properly coded in HTML. They have spacer rows with no ending
tag for the row. It looks like RCHGetTableCell(
individual cells. For example:
=RCHGetTableCell(
http://www.moneycon
Turnover"
There is an additional parameter for RCHGetHTMLTable(
around with at one point, to extract *rows* of a table instead of whole
tables. Then, the "pDir1" and "pDir2" parameters skip backwards and
forwards by rows instead of tables. If you use that parameter, you can
extract sections of the table by avoiding the improperly coded rows.
For example, you could array-enter this over a 6-column by 15-row range:
=RCHGetHTMLTable(
http://www.moneycon
Turnover"
...and this over a 6-column by 23-row range:
=RCHGetHTMLTable(
http://www.moneycon
Profit"
On Tue, Nov 19, 2013 at 7:12 AM, <vasim_07@yahoo.
>
> I wanted to get the profit and lose table (whole table) from the following
> link..
>
>
> http://www.moneycon
>
> I tried,
>
> =RCHGetHTMLTable(
> A1 = Link & A2 = Sales Turnover.
>
> which results display on first row (not the entire table)
> | Mar '12 | Mar '11 | Mar '10 |....
>
> Any help to get the entire table please.
>
Tue Nov 19, 2013 9:10 am (PST) . Posted by:
peteontheroad
I don't see any downloadable files from the link you gave me. http://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/24294 http://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/24294
I downloaded the add-in from the "Files" section of this group under "Add-in Files". If this is the old version then can we move it to the "Obsolete"; folder and replace it with the current version? Basically anyone who comes into this group is downloading the old add-in? http://groups.yahoo.com/neo/groups/smf_addin/files/Add-In%20Files
---In smf_addin@yahoogroups.com, <rharmelink@...> wrote:
I just tried it and it's working here.
What version of EXCEL are you using?
Do you have the updated element definitions from smf-elements-6.txt? See:
http://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/24294 http://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/24294
What do you get with:
=RCHGetElementNumber("Version")
=RCHGetElementNumber("P-URL",848)
=RCHGetElementNumber("MMM";,848)
=smfConvertData(smfstrExtr(smfGetTagContent("http://www.zacks.com/stock/quote/MMM/detailed-estimates http://www.zacks.com/stock/quote/MMM/detailed-estimates","p",-1,"Zacks Rank :"),": ","-"))
=smfGetTagContent("http://www.zacks.com/stock/quote/MMM/detailed-estimates http://www.zacks.com/stock/quote/MMM/detailed-estimates","p",-1,"Zacks Rank :")
=RCHGetTableCell("http://www.zacks.com/stock/quote/MMM/detailed-estimates http://www.zacks.com/stock/quote/MMM/detailed-estimates",1,">Premium Research",">Zacks Rank")
=smfConvertData(smfstrExtr(RCHGetWebData("http://www.zacks.com/stock/quote/MMM/detailed-estimates http://www.zacks.com/stock/quote/MMM/detailed-estimates","Zacks Rank :",30),":","-"))
On Wed, Nov 13, 2013 at 9:15 PM, <peteontheroad@... mailto:peteontheroad@...> wrote:
RCHGetelement 848 is definitely not working, it only returns errors. How can we fix this?
I downloaded the add-in from the "Files" section of this group under "Add-in Files". If this is the old version then can we move it to the "Obsolete"
---In smf_addin@yahoogrou
I just tried it and it's working here.
What version of EXCEL are you using?
Do you have the updated element definitions from smf-elements-
http://groups.
What do you get with:
=RCHGetElementNumbe
=RCHGetElementNumbe
=RCHGetElementNumbe
=smfConvertData(
=smfGetTagContent(
=RCHGetTableCell(
=smfConvertData(
On Wed, Nov 13, 2013 at 9:15 PM, <peteontheroad@
RCHGetelement 848 is definitely not working, it only returns errors. How can we fix this?
Tue Nov 19, 2013 9:41 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Most of the recent changes are element definitions. They are not part of
the XLA file. I put them as separate files so they would be easier to
update.
I usually only update the "official"; ZIP file once or twice a year. I
prefer to be using the changes for a while before I feel comfortable with
widespread distribution.
All interim updates are in the "Works in Progress" folder of the FILES
area. If you always want to get the latest versions of everything, that's
the place to check out. It even has its own change log, so you can see if
you're interested in the changes.
On Tue, Nov 19, 2013 at 10:10 AM, <peteontheroad@yahoo.com> wrote:
>
> I don't see any downloadable files from the link you gave me.
> http://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/24294
>
> I downloaded the add-in from the "Files" section of this group under
> "Add-in Files". If this is the old version then can we move it to the
> "Obsolete"; folder and replace it with the current version? Basically
> anyone who comes into this group is downloading the old add-in?
> http://groups.yahoo.com/neo/groups/smf_addin/files/Add-In%20Files
>
>
the XLA file. I put them as separate files so they would be easier to
update.
I usually only update the "official"
prefer to be using the changes for a while before I feel comfortable with
widespread distribution.
All interim updates are in the "Works in Progress" folder of the FILES
area. If you always want to get the latest versions of everything, that's
the place to check out. It even has its own change log, so you can see if
you're interested in the changes.
On Tue, Nov 19, 2013 at 10:10 AM, <peteontheroad@
>
> I don't see any downloadable files from the link you gave me.
> http://groups.
>
> I downloaded the add-in from the "Files" section of this group under
> "Add-in Files". If this is the old version then can we move it to the
> "Obsolete"
> anyone who comes into this group is downloading the old add-in?
> http://groups.
>
>
Tue Nov 19, 2013 11:50 am (PST) . Posted by:
peteontheroad
Got it, Thank you for all you do for this group!
---In smf_addin@yahoogroups.com, <rharmelink@...> wrote:
Most of the recent changes are element definitions. They are not part of the XLA file. I put them as separate files so they would be easier to update.
I usually only update the "official"; ZIP file once or twice a year. I prefer to be using the changes for a while before I feel comfortable with widespread distribution.
All interim updates are in the "Works in Progress" folder of the FILES area. If you always want to get the latest versions of everything, that's the place to check out. It even has its own change log, so you can see if you're interested in the changes.
On Tue, Nov 19, 2013 at 10:10 AM, <peteontheroad@... mailto:peteontheroad@...> wrote:
I don't see any downloadable files from the link you gave me. http://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/24294 http://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/24294
I downloaded the add-in from the "Files" section of this group under "Add-in Files". If this is the old version then can we move it to the "Obsolete"; folder and replace it with the current version? Basically anyone who comes into this group is downloading the old add-in? http://groups.yahoo.com/neo/groups/smf_addin/files/Add-In%20Files http://groups.yahoo.com/neo/groups/smf_addin/files/Add-In%20Files
---In smf_addin@yahoogrou
Most of the recent changes are element definitions. They are not part of the XLA file. I put them as separate files so they would be easier to update.
I usually only update the "official"
All interim updates are in the "Works in Progress" folder of the FILES area. If you always want to get the latest versions of everything, that's the place to check out. It even has its own change log, so you can see if you're interested in the changes.
On Tue, Nov 19, 2013 at 10:10 AM, <peteontheroad@
I don't see any downloadable files from the link you gave me. http://groups.
I downloaded the add-in from the "Files" section of this group under "Add-in Files". If this is the old version then can we move it to the "Obsolete"
Tue Nov 19, 2013 9:35 am (PST) . Posted by:
"Charles Johnson" chasjohn02
Randy - Thanks for the update!
The Zack's element numbers produce errors, e.g.
=RCHGetElementNumber("IBM";,849) "Error"
Thoughts?
Where should I post questions?
Thanks
Chuck Johnson
Cell: 520-904-8693
email: chasjohn02@yahoo.com
On Tuesday, November 5, 2013 1:42 PM, "rharmelink@gmail.com" <rharmelink@gmail.com> wrote:
I've updated the following files to the "Works in Progress" folder:
* @Change-log.html -- Shows a log of changes to the add-in since the last official release
* RCHGetElementNumber-Element-Definitions.xls -- The current documentation of element definitions, including the many recent changes. I've added a "Usage" column to indicate if an element is for Stocks ("S"), ETFs ("E"), and/or Mutual Funds ("F").
* smf-elements-8.txt -- Contains the updates of the earnings.com earnings announcement element definitions, #1286 thru #1400, with element definitions from Zacks. I replaced the old "Prev Year Actual" elements from earnings.com with the new "Reported Time" from Zacks. Otherwise, the elements mapped one-to-one. You could even open up the old earnings.com template to see the data for the new element definitions.
* SMF-Template-Zacks-Earnings-Annoucements.xls -- A new template, to display elements #1286 thru #1400 in context.
To install the updates to the element definitions, replace the smf-elements-8.txt in your SMF
add-in folder with this new file. Then, you'll either need to exit and
restart EXCEL, or run the smfForceRecalculation macro, in order for the
add-in to load the new definitions.
One thing that does concern me about the Zacks earnings announcement table is that the older quarters have an "Estimated EPS", but not a "Reported EPS". That seem a little strange to me.
These are not trivial extractions, since the data was extracted from JavaScript code. For example, the extraction formula for element #1287 looks something like:
=smfConvertData(smfstrExtr(smfstrExtr(smfWord(smfWord(","&smfstrExtr(smfGetTagContent("http://www.zacks.com/stock/research/IBM/earnings-announcements","script",-1,"Period Ending"),"""data"" : [ ","]"),1,"}"),4,","),": ","~"),"""",""""))
But once I got the pattern down, it went fairly quickly. :)
The Zack's element numbers produce errors, e.g.
=RCHGetElementNumbe
Thoughts?
Where should I post questions?
Thanks
Chuck Johnson
Cell: 520-904-8693
email: chasjohn02@yahoo.
On Tuesday, November 5, 2013 1:42 PM, "rharmelink@gmail.
I've updated the following files to the "Works in Progress" folder:
* @Change-log.
* RCHGetElementNumber
* smf-elements-
* SMF-Template-
To install the updates to the element definitions, replace the smf-elements-
add-in folder with this new file. Then, you'll either need to exit and
restart EXCEL, or run the smfForceRecalculati
add-in to load the new definitions.
One thing that does concern me about the Zacks earnings announcement table is that the older quarters have an "Estimated EPS", but not a "Reported EPS". That seem a little strange to me.
These are not trivial extractions, since the data was extracted from JavaScript code. For example, the extraction formula for element #1287 looks something like:
=smfConvertData(
But once I got the pattern down, it went fairly quickly. :)
Tue Nov 19, 2013 9:45 am (PST) . Posted by:
"Randy Harmelink" rharmelink
What do you get for:
=RCHGetElementNumber("Version")
=smfGetAParms(849)
=RCHGetElementNumber("IBM";,849)
=RCHGetTableCell("
http://www.zacks.com/stock/research/IBM/brokerage-recommendations",1,">Average
Target Price")
What version of EXCEL are you running?
Can you see the data on this web page in IE?
http://www.zacks.com/stock/research/IBM/brokerage-recommendations
On Tue, Nov 19, 2013 at 10:35 AM, Charles Johnson <chasjohn02@yahoo.com>wrote:
>
> The Zack's element numbers produce errors, e.g.
> =RCHGetElementNumber("IBM";,849) "Error"
> Thoughts?
>
=RCHGetElementNumbe
=smfGetAParms(
=RCHGetElementNumbe
=RCHGetTableCell(
http://www.zacks.
Target Price")
What version of EXCEL are you running?
Can you see the data on this web page in IE?
http://www.zacks.
On Tue, Nov 19, 2013 at 10:35 AM, Charles Johnson <chasjohn02@yahoo.
>
> The Zack's element numbers produce errors, e.g.
> =RCHGetElementNumbe
> Thoughts?
>
Tue Nov 19, 2013 10:30 am (PST) . Posted by:
racecar00
Do you happen to have the raw data URLs for stocks as well?
---In smf_addin@yahoogroups.com, <rharmelink@...> wrote:
The URL you are using *is* a dynamic web page, so you can't extract the data from there. By going over the JavaScript code, I've learned that MorningStar *does* keep the data on static pages, but then loads them onto the dynamic page. In this case, the data you want is on this page (assuming you want the 3-year beta):
http://performance.morningstar.com/RatingRisk/fund/mpt-statistics.action?y=3&t=AFK http://performance.morningstar.com/RatingRisk/fund/mpt-statistics.action?y=3&t=AFK
Here's how to extract the five possible definitions of beta:
=RCHGetTableCell("http://performance.morningstar.com/RatingRisk/fund/mpt-statistics.action?y=3&t=AFK http://performance.morningstar.com/RatingRisk/fund/mpt-statistics.action?y=3&t=AFK",
4,"Best-Fit Index","<tr","<tr")
=RCHGetTableCell("http://performance.morningstar.com/RatingRisk/fund/mpt-statistics.action?y=3&t=AFK http://performance.morningstar.com/RatingRisk/fund/mpt-statistics.action?y=3&t=AFK",
4,"Standard Index","<tr","<tr")
=RCHGetTableCell("http://performance.morningstar.com/RatingRisk/fund/mpt-statistics.action?y=5&t=AFK http://performance.morningstar.com/RatingRisk/fund/mpt-statistics.action?y=5&t=AFK",
4,"Standard Index","<tr","<tr")
=RCHGetTableCell("http://performance.morningstar.com/RatingRisk/fund/mpt-statistics.action?y=10&t=AFK http://performance.morningstar.com/RatingRisk/fund/mpt-statistics.action?y=10&t=AFK",
4,"Standard Index","<tr","<tr")
=RCHGetTableCell("http://performance.morningstar.com/RatingRisk/fund/mpt-statistics.action?y=15&t=AFK http://performance.morningstar.com/RatingRisk/fund/mpt-statistics.action?y=15&t=AFK",
4,"Standard Index","<tr","<tr")
My current status on extraction of ETF data from MorningStar has been to identify these pages as potential sources of raw data (either from their web page or because it is loaded onto a dynamic web page):
http://performance.morningstar.com/RatingRisk/fund/mpt-statistics.action?y=3&t=AFK http://performance.morningstar.com/RatingRisk/fund/mpt-statistics.action?y=3&t=AFK
http://performance.morningstar.com/RatingRisk/fund/mpt-statistics.action?y=5&t=AFK http://performance.morningstar.com/RatingRisk/fund/mpt-statistics.action?y=5&t=AFK
http://performance.morningstar.com/RatingRisk/fund/mpt-statistics.action?y=10&t=AFK http://performance.morningstar.com/RatingRisk/fund/mpt-statistics.action?y=10&t=AFK
http://performance.morningstar.com/RatingRisk/fund/mpt-statistics.action?y=15&t=AFK http://performance.morningstar.com/RatingRisk/fund/mpt-statistics.action?y=15&t=AFK
http://performance.morningstar.com/RatingRisk/fund/volatility-measurements.action?y=3&t=AFK http://performance.morningstar.com/RatingRisk/fund/volatility-measurements.action?y=3&t=AFK
http://performance.morningstar.com/RatingRisk/fund/volatility-measurements.action?y=5&t=AFK http://performance.morningstar.com/RatingRisk/fund/volatility-measurements.action?y=5&t=AFK
http://performance.morningstar.com/RatingRisk/fund/volatility-measurements.action?y=10&t=AFK http://performance.morningstar.com/RatingRisk/fund/volatility-measurements.action?y=10&t=AFK
http://performance.morningstar.com/RatingRisk/fund/volatility-measurements.action?y=15&t=AFK http://performance.morningstar.com/RatingRisk/fund/volatility-measurements.action?y=15&t=AFK
http://portfolios.morningstar.com/fund/summary?t=AFK http://portfolios.morningstar.com/fund/summary?t=AFK
http://performance.morningstar.com/Performance/cef/premium-discount.action?t=AFK http://performance.morningstar.com/Performance/cef/premium-discount.action?t=AFK
http://performance.morningstar.com/Performance/cef/cost-risk.action?t=AFK http://performance.morningstar.com/Performance/cef/cost-risk.action?t=AFK
http://performance.morningstar.com/Performance/cef/performance-history.action?t=AFK http://performance.morningstar.com/Performance/cef/performance-history.action?t=AFK
http://performance.morningstar.com/Performance/cef/trailing-
---In smf_addin@yahoogrou
The URL you are using *is* a dynamic web page, so you can't extract the data from there. By going over the JavaScript code, I've learned that MorningStar *does* keep the data on static pages, but then loads them onto the dynamic page. In this case, the data you want is on this page (assuming you want the 3-year beta):
http://performance.
Here's how to extract the five possible definitions of beta:
=RCHGetTableCell(
4,"Best-
=RCHGetTableCell(
4,"Standard Index",
=RCHGetTableCell(
4,"Standard Index",
=RCHGetTableCell(
4,"Standard Index",
=RCHGetTableCell(
4,"Standard Index",
My current status on extraction of ETF data from MorningStar has been to identify these pages as potential sources of raw data (either from their web page or because it is loaded onto a dynamic web page):
http://performance.
http://performance.
http://performance.
http://performance.
http://performance.
http://performance.
http://performance.
http://performance.
http://portfolios.
http://performance.
http://performance.
http://performance.
http://performance.