8 New Messages
Digest #2877
Messages
Wed Nov 27, 2013 12:57 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Sorry. Not a clue here. The add-in needs a bookmarkable URL.
On Wed, Nov 27, 2013 at 1:24 AM, <vasim_07@yahoo.com> wrote:
>
> If you go on to the below mentioned link, there is a balance sheet Mar 13
> to Mar 09 - I am (with your help) by =RCHGETHTMLTABLE able to get this data
> in excel, however if you notice there is a "Previous Years >>" link just
> above the table, when clicked gives us the balance sheet records for Mar 08
> to Mar 04.
>
> Since the url remains the same for both new year and previous year, can
> you help me if we can get this ("Previous year") data any way for
> =RCHGETHTMLTABLE function.
>
> http://www.moneycontrol.com/financials/tcs/balance-sheet/TCS
>
> To be more clear, how can I get the previous year data in excel by your
> addin.
>
>
On Wed, Nov 27, 2013 at 1:24 AM, <vasim_07@yahoo.
>
> If you go on to the below mentioned link, there is a balance sheet Mar 13
> to Mar 09 - I am (with your help) by =RCHGETHTMLTABLE able to get this data
> in excel, however if you notice there is a "Previous Years >>" link just
> above the table, when clicked gives us the balance sheet records for Mar 08
> to Mar 04.
>
> Since the url remains the same for both new year and previous year, can
> you help me if we can get this ("Previous year") data any way for
> =RCHGETHTMLTABLE function.
>
> http://www.moneycon
>
> To be more clear, how can I get the previous year data in excel by your
> addin.
>
>
Wed Nov 27, 2013 2:06 am (PST) . Posted by:
vasim_07
Thank you
---In smf_addin@yahoogroups.com, <rharmelink@...> wrote:
Sorry. Not a clue here. The add-in needs a bookmarkable URL.
On Wed, Nov 27, 2013 at 1:24 AM, <vasim_07@... mailto:vasim_07@...> wrote:
If you go on to the below mentioned link, there is a balance sheet Mar 13 to Mar 09 - I am (with your help) by =RCHGETHTMLTABLE able to get this data in excel, however if you notice there is a "Previous Years >>" link just above the table, when clicked gives us the balance sheet records for Mar 08 to Mar 04.
Since the url remains the same for both new year and previous year, can you help me if we can get this ("Previous year") data any way for =RCHGETHTMLTABLE function.
http://www.moneycontrol.com/financials/tcs/balance-sheet/TCS http://www.moneycontrol.com/financials/tcs/balance-sheet/TCS
To be more clear, how can I get the previous year data in excel by your addin.
---In smf_addin@yahoogrou
Sorry. Not a clue here. The add-in needs a bookmarkable URL.
On Wed, Nov 27, 2013 at 1:24 AM, <vasim_07@
If you go on to the below mentioned link, there is a balance sheet Mar 13 to Mar 09 - I am (with your help) by =RCHGETHTMLTABLE able to get this data in excel, however if you notice there is a "Previous Years >>" link just above the table, when clicked gives us the balance sheet records for Mar 08 to Mar 04.
Since the url remains the same for both new year and previous year, can you help me if we can get this ("Previous year") data any way for =RCHGETHTMLTABLE function.
http://www.moneycon
To be more clear, how can I get the previous year data in excel by your addin.
Wed Nov 27, 2013 2:11 am (PST) . Posted by:
jovica.bozic
Every time I start Excel there are some new problems with their data and that's good, the bad thing is when I don't notice problems.
Beside missing quarters (chronic problem), today I noticed that financial data is absolutely unusable. All quarters are mixed up and of course data is wrong, also there is discrepancy between annual results and sum of all quarters in Income statement (for data I am using RCHGetHTMLTable)
I've double checked data and compare it with YF and GF. Company in question is DLTR.
Does any1 knows what's going on, it's kind of strange that they can not fix their site for that long?
Beside missing quarters (chronic problem), today I noticed that financial data is absolutely unusable. All quarters are mixed up and of course data is wrong, also there is discrepancy between annual results and sum of all quarters in Income statement (for data I am using RCHGetHTMLTable)
I've double checked data and compare it with YF and GF. Company in question is DLTR.
Does any1 knows what's going on, it's kind of strange that they can not fix their site for that long?
Wed Nov 27, 2013 5:46 am (PST) . Posted by:
mkelly7274
Thanks! This worked.
---In smf_addin@yahoogroups.com, <rharmelink@...> wrote:
For the 1-Month return, try:
=RCHGetTableCell("http://performance.morningstar.com/Performance/etf/trailing-total-returns.action?t= http://performance.morningstar.com/Performance/etf/trailing-total-returns.action?t="&$C4,3,">Total Return %","(Price)")
On Tue, Nov 26, 2013 at 7:12 PM, <mkelly7274@... mailto:mkelly7274@...> wrote:
I have am trying to download daily trailing returns from Morningstar, but have had no luck. I have reviewed the other threads, but they do not seem to work. I am trying to import return data from the following link:
http://performance.morningstar.com/Performance/etf/trailing-total-returns.action?t=iwv http://performance.morningstar.com/Performance/etf/trailing-total-returns.action?t=iwv
I tried the following formula, but got an error message. Can anyone help?
=RCHGetTableCell("http://performance.morningstar.com/Performance/etf/trailing-total-returns.action?t="&E7,1,">1-Month",">Trailing http://performance.morningstar.com/Performance/etf/trailing-total-returns.action?t=%22&E7,1,%22%3E1-Month%22,%22%3ETrailing Total Returns")
---In smf_addin@yahoogrou
For the 1-Month return, try:
=RCHGetTableCell(
On Tue, Nov 26, 2013 at 7:12 PM, <mkelly7274@
I have am trying to download daily trailing returns from Morningstar, but have had no luck. I have reviewed the other threads, but they do not seem to work. I am trying to import return data from the following link:
http://performance.
I tried the following formula, but got an error message. Can anyone help?
=RCHGetTableCell(
Wed Nov 27, 2013 7:50 am (PST) . Posted by:
"rtexican" rtexican
For quite some time now I have been unable to get smf-element-1 to work. When I load the Motley Fool spreadsheets, I get "error" and "value" messages in the fields. This has gone on for over a year and I do have all the latest files loaded.
I am using Windows 7, Excel 2010 and it shows using 4 processors when I first load. I have tried the force calculation method as well.
I can live without it for sure, but, I do like the worksheets that have been uploaded and they would be nice additions to my larger research workbook.
Thanks
Richard
I am using Windows 7, Excel 2010 and it shows using 4 processors when I first load. I have tried the force calculation method as well.
I can live without it for sure, but, I do like the worksheets that have been uploaded and they would be nice additions to my larger research workbook.
Thanks
Richard
Wed Nov 27, 2013 8:45 am (PST) . Posted by:
"Randy Harmelink" rharmelink
I'll need more info, since what you're telling me doesn't make sense to me.
The smf-elements-1.txt file contains element definitions for data from MSN
web pages. And I don't know which Motley Fool spreadsheets you are talking
about. In any case, the two would be unrelated. If the files are from the
"Uploads by Forum Members" folder, I don't support those workbooks.
However, if you would cite a few particular formula examples that are
having problems, I would be happy to look at those.
I will note that there was some talk several months ago on the TMF
discussion boards that TMF had bought some software that would prevent
automated web page retrieval from their web site. I've not tested that.
On Wed, Nov 27, 2013 at 8:50 AM, rtexican <RHerb505@charter.net> wrote:
> For quite some time now I have been unable to get smf-element-1 to work.
> When I load the Motley Fool spreadsheets, I get "error" and "value"
> messages in the fields. This has gone on for over a year and I do have all
> the latest files loaded.
>
> I am using Windows 7, Excel 2010 and it shows using 4 processors when I
> first load. I have tried the force calculation method as well.
>
> I can live without it for sure, but, I do like the worksheets that have
> been uploaded and they would be nice additions to my larger research
> workbook.
>
The smf-elements-
web pages. And I don't know which Motley Fool spreadsheets you are talking
about. In any case, the two would be unrelated. If the files are from the
"Uploads by Forum Members" folder, I don't support those workbooks.
However, if you would cite a few particular formula examples that are
having problems, I would be happy to look at those.
I will note that there was some talk several months ago on the TMF
discussion boards that TMF had bought some software that would prevent
automated web page retrieval from their web site. I've not tested that.
On Wed, Nov 27, 2013 at 8:50 AM, rtexican <RHerb505@charter.
> For quite some time now I have been unable to get smf-element-
> When I load the Motley Fool spreadsheets, I get "error" and "value"
> messages in the fields. This has gone on for over a year and I do have all
> the latest files loaded.
>
> I am using Windows 7, Excel 2010 and it shows using 4 processors when I
> first load. I have tried the force calculation method as well.
>
> I can live without it for sure, but, I do like the worksheets that have
> been uploaded and they would be nice additions to my larger research
> workbook.
>
Wed Nov 27, 2013 11:12 am (PST) . Posted by:
racecar00
Hi Randy,
I am trying to pull the style box data from Morningstar's static pages. I was using element 880 but it wasn't working for every security. For example, APD pulls in "Error" but shows "Large Core" on the following page (http://quicktake.morningstar.com/stocknet/printreport.aspx?symbol=apd http://quicktake.morningstar.com/stocknet/printreport.aspx?symbol=apd)
The following formula isn't working, Do you see the error?
=RCHGetTableCell("http://quicktake.morningstar.com/fund/printreport.aspx?symbol="&$B18,1,"Key Stats", "Morningstar Style Box")
Thanks
I am trying to pull the style box data from Morningstar&#
The following formula isn't working, Do you see the error?
=RCHGetTableCell(
Thanks
Wed Nov 27, 2013 11:35 am (PST) . Posted by:
"Randy Harmelink" rharmelink
The problem is that your formula is using a mutual fund print report URL,
not the stock print report URL you cite immediately before it. The actual
formula you would need to pull it from the stock print URL is:
=RCHGetTableCell("
http://quicktake.morningstar.com/stocknet/printreport.aspx?symbol="&$B18,2,"Key
Stats", "Morningstar Style Box")
However, I'm pretty sure the "Print Report" web pages will eventually
disappear, since M* no longer has any direct links to them.
Element 880 for APD works fine here, but I'm using the updated element
definitions from the "Works in Progress" folder. The new element definition
pulls the data from this web page, which M* uses to build their new dynamic
web pages:
http://quotes.morningstar.com/stock/c-company-profile?t=APD
On Wed, Nov 27, 2013 at 12:12 PM, <agelhausen@gmail.com> wrote:
>
> I am trying to pull the style box data from Morningstar's static pages. I
> was using element 880 but it wasn't working for every security. For
> example, APD pulls in "Error" but shows "Large Core" on the following page (
> http://quicktake.morningstar.com/stocknet/printreport.aspx?symbol=apd)
>
> The following formula isn't working, Do you see the error?
>
> =RCHGetTableCell("
> http://quicktake.morningstar.com/fund/printreport.aspx?symbol="&$B18,1,"Key
> Stats", "Morningstar Style Box")
>
>
not the stock print report URL you cite immediately before it. The actual
formula you would need to pull it from the stock print URL is:
=RCHGetTableCell(
http://quicktake.
Stats", "Morningstar Style Box")
However, I'm pretty sure the "Print Report" web pages will eventually
disappear, since M* no longer has any direct links to them.
Element 880 for APD works fine here, but I'm using the updated element
definitions from the "Works in Progress" folder. The new element definition
pulls the data from this web page, which M* uses to build their new dynamic
web pages:
http://quotes.
On Wed, Nov 27, 2013 at 12:12 PM, <agelhausen@gmail.
>
> I am trying to pull the style box data from Morningstar&#
> was using element 880 but it wasn't working for every security. For
> example, APD pulls in "Error" but shows "Large Core" on the following page (
> http://quicktake.
>
> The following formula isn't working, Do you see the error?
>
> =RCHGetTableCell(
> http://quicktake.
> Stats", "Morningstar Style Box")
>
>
Tidak ada komentar:
Posting Komentar