Rabu, 03 Agustus 2011

[smf_addin] Digest Number 1907

Messages In This Digest (6 Messages)

Messages

1a.

Downloading financial statements from AdvFn

Posted by: "bushpilote" bushpilote@yahoo.ca   bushpilote

Tue Aug 2, 2011 12:50 pm (PDT)



Hi Randy,
I'm trying to download financial statements from AdvFn.com through an excel macro (I am familiar with the smfGetAdvFNElement-Template-All-Line-Items.xls template).
Can you or anyone else on this board help me understand why the following critical lines of coding are not working:

"URL;http://www.advfn.com/p.php?pid=financials&btn=istart_date&mode=quarterly_reports&symbol=MSFT&istart_date=70" _
, Destination:=Range("$B$1"))
.Name = _
"p.php?pid=financials&btn=istart_date&mode=quarterly_reports&symbol=MSFT&istart_date=70"

Thanks.

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

Re: Downloading financial statements from AdvFn

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

Tue Aug 2, 2011 1:36 pm (PDT)



No idea, sorry.

On Tue, Aug 2, 2011 at 12:50 PM, bushpilote <bushpilote@yahoo.ca> wrote:

> Hi Randy,
> I'm trying to download financial statements from AdvFn.com through an excel
> macro (I am familiar with the smfGetAdvFNElement-Template-All-Line-Items.xls
> template).
> Can you or anyone else on this board help me understand why the following
> critical lines of coding are not working:
>
> "URL;
> http://www.advfn.com/p.php?pid=financials&btn=istart_date&mode=quarterly_reports&symbol=MSFT&istart_date=70"
> _
> , Destination:=Range("$B$1"))
> .Name = _
>
> "p.php?pid=financials&btn=istart_date&mode=quarterly_reports&symbol=MSFT&istart_date=70"
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)
1c.

Re: Downloading financial statements from AdvFn

Posted by: "dguillett1" dguillett1@gmail.com   donaldb36

Tue Aug 2, 2011 3:47 pm (PDT)




I have an external query macro that uses
With ss.QueryTables(1)
.Connection = _
"URL;http://www.advfn.com/p.php?pid=financials&btn=s_ok&mode=&symbol=" & symbol & "&s_ok=OK"
Yours also worked
"URL;http://www.advfn.com/p.php?pid=financials&btn=istart_date&mode=quarterly_reports&symbol=MSFT&istart_date=70" _
to get this
INDICATORS
quarter end date 1994/03 1994/06 1994/09 1994/12 1995/03
date preliminary data loaded 0000-00-00 0000-00-00 0000-00-00 0000-00-00 4/14/1995
earnings period indicator N F Q S N
quarterly indicator 3 4 1 2 3
basic earnings indicator N N N N N
template indicator
preliminary full context ind N N N N N
projected fiscal year date 0000-00-00 0000-00-00 0000-00-00 0000-00-00 0000-00-00
number of months last report period 3 3 3 3 3
INCOME STATEMENT
operating revenue 1,244.00 1,293.00 1,247.00 1,482.00 1,587.00
total revenue 1,244.00 1,293.00 1,247.00 1,482.00 1,587.00

From: bushpilote
Sent: Tuesday, August 02, 2011 2:50 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Downloading financial statements from AdvFn

Hi Randy,
I'm trying to download financial statements from AdvFn.com through an excel macro (I am familiar with the smfGetAdvFNElement-Template-All-Line-Items.xls template).
Can you or anyone else on this board help me understand why the following critical lines of coding are not working:

"URL;http://www.advfn.com/p.php?pid=financials&btn=istart_date&mode=quarterly_reports&symbol=MSFT&istart_date=70" _
, Destination:=Range("$B$1"))
.Name = _
"p.php?pid=financials&btn=istart_date&mode=quarterly_reports&symbol=MSFT&istart_date=70"

Thanks.

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

Looking for Intraday data....

Posted by: "cocoaacc" cocoaacc@yahoo.com.hk   cocoaacc

Tue Aug 2, 2011 6:37 pm (PDT)



Dear Randy,

I am looking for historical intraday data for U.S. stock market index and U.S. stocks.

I only know how to find daily historical data for U.S. stock market index and U.S. stocks using below formula.

=RCHGetYahooHistory(^GSPC)

Many Thanks!!!
Will

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

Re: Looking for Intraday data....

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

Tue Aug 2, 2011 7:17 pm (PDT)



Check out this template:

RCHGetWebData-Template-BarChart-Quotes-Extract.xls

On Tue, Aug 2, 2011 at 6:36 PM, cocoaacc <cocoaacc@yahoo.com.hk> wrote:

>
> I am looking for historical intraday data for U.S. stock market index and
> U.S. stocks.
>
> I only know how to find daily historical data for U.S. stock market index
> and U.S. stocks using below formula.
>
> =RCHGetYahooHistory(^GSPC)
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
3.

(no subject)

Posted by: "Judy Cheesman" judy_a_cheesman@yahoo.com   judy_a_cheesman

Wed Aug 3, 2011 3:08 am (PDT)



http://biletvkosmos.com/1xsha.htm.htm

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

It's Now Personal

Guides, news,

advice & more.

Yahoo! Groups

Small Business Group

Own a business?

Connect with others.

Find helpful tips

for Moderators

on the Yahoo!

Groups team blog.

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 03.39

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)