Jumat, 09 Maret 2012

[smf_addin] Digest Number 2141[1 Attachment]

Messages In This Digest (7 Messages)

Messages

1a.

Downloading financials from www.moneycontrol.com

Posted by: "vinod bhat" vinodnbhat@gmail.com   vinodnbhat

Thu Mar 8, 2012 8:02 am (PST)



Dear Randy,

I am looking to automate the downloading of P&L and Balance Sheet data to
Excel from the link below (www.moneycontrol.com) for a sample company (Axis
Bank):

http://www.moneycontrol.com/financials/axisbank/consolidated-profit-loss/AB16

Would it be possible for you to please take a look to see if that is
possible and how it can be done? I'd appreciate it.

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

Re: Downloading financials from www.moneycontrol.com

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

Thu Mar 8, 2012 11:07 am (PST)



Did you try anything? It's as straight-forward as they come:

=RCHGetTableCell("
http://www.moneycontrol.com/financials/axisbank/consolidated-profit-loss/AB16",1,">Interest
Earned")

On Thu, Mar 8, 2012 at 9:02 AM, vinod bhat <vinodnbhat@gmail.com> wrote:

>
> I am looking to automate the downloading of P&L and Balance Sheet data to
> Excel from the link below (www.moneycontrol.com) for a sample company
> (Axis Bank):
>
>
> http://www.moneycontrol.com/financials/axisbank/consolidated-profit-loss/AB16
>
> Would it be possible for you to please take a look to see if that is
> possible and how it can be done? I'd appreciate it.
>
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)
1c.

Re: Downloading financials from www.moneycontrol.com

Posted by: "vinod bhat" vinodnbhat@gmail.com   vinodnbhat

Thu Mar 8, 2012 11:38 am (PST)



Thanks Randy. Sorry about that. I did try out a couple of things, including
RCHGetTableCell but I guess I didn't get the syntax correct. It is very
simple indeed.

On Fri, Mar 9, 2012 at 12:37 AM, Randy Harmelink <rharmelink@gmail.com>wrote:

> **
>
>
> Did you try anything? It's as straight-forward as they come:
>
> =RCHGetTableCell("
> http://www.moneycontrol.com/financials/axisbank/consolidated-profit-loss/AB16",1,">Interest
> Earned")
>
>
> On Thu, Mar 8, 2012 at 9:02 AM, vinod bhat <vinodnbhat@gmail.com> wrote:
>
>>
>> I am looking to automate the downloading of P&L and Balance Sheet data to
>> Excel from the link below (www.moneycontrol.com) for a sample company
>> (Axis Bank):
>>
>>
>> http://www.moneycontrol.com/financials/axisbank/consolidated-profit-loss/AB16
>>
>> Would it be possible for you to please take a look to see if that is
>> possible and how it can be done? I'd appreciate it.
>>
>>
>
>
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)
2a.

Re: RCHGetYahooHistory() stopped working?

Posted by: "Ian" irianr43@gmail.com   irianr43

Thu Mar 8, 2012 5:26 pm (PST)



I had a similar problem when a new version of Internet explorer was instaslled. Had to change some Advanced Internet Options
Ian

--- In smf_addin@yahoogroups.com, "fdtseng" <e11years@...> wrote:
>
> Used to work okay with Excel 2010 and Windows 7. However since today it stopped with the cells filled with "#NAME?". The example file in the links directory also displays the same problem.
>

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

Re: RCHGetYahooHistory() stopped working?

Posted by: "fdtseng" e11years@gmail.com   fdtseng

Thu Mar 8, 2012 6:52 pm (PST)



In my case, Excel unexpectedly uninstalled all my add-ins

--- In smf_addin@yahoogroups.com, "Ian" <irianr43@...> wrote:
>
> I had a similar problem when a new version of Internet explorer was instaslled. Had to change some Advanced Internet Options
> Ian
>
> --- In smf_addin@yahoogroups.com, "fdtseng" <e11years@> wrote:
> >
> > Used to work okay with Excel 2010 and Windows 7. However since today it stopped with the cells filled with "#NAME?". The example file in the links directory also displays the same problem.
> >
>

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

getting data from IBD stock checkup page

Posted by: "Mike Fitzpatrick" mff3429@comcast.net   mff2805

Fri Mar 9, 2012 1:16 am (PST)

[Attachment(s) from Mike Fitzpatrick included below]

hi,
i have a subscription to IBD and use their stock checkup page on a very
regular basis.
I was looking to pull data off that page into a summary spreadsheet, but
am having difficulties getting something useful. i can build the
appropriate web address and am trying the rchgettablecell function and
the rchgetwebdata function - to no avail. the attached screenshot shows
my work to date. do i need to get more knowledgeable about web pages
and the addin to learn how to get info such as composite rating,
industry rank, etc? or is there an easier way? i've snooped through
messages and files and am a few hrs into this exercise.

looking for help. thanks much. i enjoy the addin; must be a lot of
work, randy.

-mike

Attachment(s) from Mike Fitzpatrick

1 of 1 Photo(s)

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

Re: getting data from IBD stock checkup page

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

Fri Mar 9, 2012 1:41 am (PST)



This formula:

=RCHGetTableCell("http://research.investors.com/stockcheckup/nyse-agrium\
-inc-agu.aspx",1,">EPS")

...returns the EPS Due Date for me.

Two things you have to make sure of:

1. You need to visit the site with the EXCEL Web Query dialog or with
IE before using the add-in. Sometimes they do a "first visit of the
day" redirection to some advertising page. If that never gets resolved
via the IE object, the cookie that does that redirection will never get
updated.

2. You need to log into the site with the EXCEL Web Query dialog or
with IE before using the add-in. This creates the security cookie you'll
need to access the web pages on the site. Note that if you happen to
use something like FireFox to visit the site, your IE cookie will
automatically be voided. IBD only allows you to be logged in with one
browser at the same time.

On Fri, Mar 9, 2012 at 2:16 AM, Mike Fitzpatrick <mff3429@comcast.net>
wrote:

i have a subscription to IBD and use their stock checkup page on a very
regular basis.
I was looking to pull data off that page into a summary spreadsheet, but
am having difficulties getting something useful. i can build the
appropriate web address and am trying the rchgettablecell function and
the rchgetwebdata function - to no avail. the attached screenshot shows
my work to date. do i need to get more knowledgeable about web pages
and the addin to learn how to get info such as composite rating,
industry rank, etc? or is there an easier way? i've snooped through
messages and files and am a few hrs into this exercise.

looking for help. thanks much. i enjoy the addin; must be a lot of
work, randy.

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
Recent Activity
Visit Your Group
Ads on Yahoo!

Learn more now.

Reach customers

searching for you.

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
Diposting oleh EXCEL FEED LEARNING di 01.55

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)