4 New Messages

Digest #2876

Re: Can not retrive data from ADFN-A by jegorah

Morningstar Daily Returns by mkelly7274

Re: Morningstar Daily Returns by "Randy Harmelink" rharmelink

Extracting 10 yrs of data from moneycontrol by vasim_07

Messages

1a

Re: Can not retrive data from ADFN-A

Tue Nov 26, 2013 11:36 am (PST) . Posted by:

jegorah

Sorry. I'm not really used to the way these group conversations are listed. It's a tad confusing.

---In smf_addin@yahoogroups.com, <rharmelink@...> wrote:

It's only been a topic of conversation for months (and will probably be again in the near future)...

See: http://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/24009 http://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/24009
On Sun, Nov 24, 2013 at 5:25 AM, <jegorah@... mailto:jegorah@...> wrote:
Using the RCHGetElementNumber function, I can no longer retrieve any data from ADFN-A sources. They all just show 'Error' in the cells. Is there something I need to do to get this to work?

Reply to sender . Reply to group . Reply via Web Post . All Messages (3) . Top ^

2a

Morningstar Daily Returns

Tue Nov 26, 2013 7:41 pm (PST) . Posted by:

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.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 Total Returns")

Mark

Reply to sender . Reply to group . Reply via Web Post . All Messages (2) . Top ^

2b

Re: Morningstar Daily Returns

Tue Nov 26, 2013 7:50 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

For the 1-Month return, try:

=RCHGetTableCell("
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@yahoo.com> 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
>
> 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",">TrailingTotal Returns")
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (2) . Top ^

3 Extracting 10 yrs of data from moneycontrol

Wed Nov 27, 2013 12:24 am (PST) . Posted by:

vasim_07

Hi Sir,

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.

PS: THANKS....and lastly.... ur just awsome.....

Regards,
Vasim