Jumat, 10 Juni 2011

[smf_addin] Digest Number 1852

Messages In This Digest (9 Messages)

Messages

1a.

zacks most accurate estimate versus consensus pull

Posted by: "john doe" fulmer_r@denison.edu   ryan5099

Thu Jun 9, 2011 8:43 am (PDT)



Hi,
I was hoping someone could help me pull from zacks website (not premium) their most accurate estimate for current and forward year. Here is a url:

http://www.zacks.com/research/report.php?type=estimates&t=amzn&x=0&y=0

Thanks

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

Re: zacks most accurate estimate versus consensus pull

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

Thu Jun 9, 2011 8:48 am (PDT)



Just a straight-forward RCHGetTableCell() function:

=RCHGetTableCell("
http://www.zacks.com/research/report.php?type=estimates&t=amzn",3,">Most
Accurate Estimate")
=RCHGetTableCell("
http://www.zacks.com/research/report.php?type=estimates&t=amzn",4,">Most
Accurate Estimate")

On Thu, Jun 9, 2011 at 8:42 AM, john doe <fulmer_r@denison.edu> wrote:

>
> I was hoping someone could help me pull from zacks website (not premium)
> their most accurate estimate for current and forward year. Here is a url:
>
> http://www.zacks.com/research/report.php?type=estimates&t=amzn&x=0&y=0
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)
1c.

Re: zacks most accurate estimate versus consensus pull

Posted by: "john doe" fulmer_r@denison.edu   ryan5099

Thu Jun 9, 2011 8:52 am (PDT)



thanks for the quick response. How would I have it so that I can have the ticker as a formula rather than part of the code?

many thanks

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Just a straight-forward RCHGetTableCell() function:
>
> =RCHGetTableCell("
> http://www.zacks.com/research/report.php?type=estimates&t=amzn",3,">Most
> Accurate Estimate")
> =RCHGetTableCell("
> http://www.zacks.com/research/report.php?type=estimates&t=amzn",4,">Most
> Accurate Estimate")
>
> On Thu, Jun 9, 2011 at 8:42 AM, john doe <fulmer_r@...> wrote:
>
> >
> > I was hoping someone could help me pull from zacks website (not premium)
> > their most accurate estimate for current and forward year. Here is a url:
> >
> > http://www.zacks.com/research/report.php?type=estimates&t=amzn&x=0&y=0
> >
>

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

Re: zacks most accurate estimate versus consensus pull

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

Thu Jun 9, 2011 9:03 am (PDT)



Just do normal EXCEL string concatenation with the rest of the URL. For
example:

=RCHGetTableCell("http://www.zacks.com/research/report.php?type=estimates&t="&B4,3,">Most
Accurate Estimate")

On Thu, Jun 9, 2011 at 8:51 AM, john doe <fulmer_r@denison.edu> wrote:

> thanks for the quick response. How would I have it so that I can have the
> ticker as a formula rather than part of the code?
>
> many thanks
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)
2a.

Question about Bloomberg

Posted by: "jtravisano2002" jacob.travisano@gmail.com   jtravisano2002

Thu Jun 9, 2011 12:14 pm (PDT)



First of all, great job on all your work here!!!

I'm wondering if there is anyway to use quotes and information off of bloomberg rather than MSN or Yahoo? The thing I like about Bloomberg is they give quotes for markets in other countries like Korea. I'm not talking about any of the paid subscription stuff, just the free information they offer on their general website.

Thank you,

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

Re: Question about Bloomberg

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

Thu Jun 9, 2011 3:08 pm (PDT)



You could probably use the RCHGetTableCell() or smfGetTagContent() functions
from Bloomberg. But unless they have something like the Yahoo CSV process,
you'll need to get it one web page at a time.

On Thu, Jun 9, 2011 at 12:07 PM, jtravisano2002
<jacob.travisano@gmail.com>wrote:

>
> I'm wondering if there is anyway to use quotes and information off of
> bloomberg rather than MSN or Yahoo? The thing I like about Bloomberg is they
> give quotes for markets in other countries like Korea. I'm not talking about
> any of the paid subscription stuff, just the free information they offer on
> their general website.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
3a.

Re: Recalculation issues (GetHTMLTable function)

Posted by: "winvestr" winvestr@gmail.com   winvestr

Thu Jun 9, 2011 7:17 pm (PDT)



Hello Randy, now that i've finally learnt how to use the getHTMLTable function, i'm eager to start building some spreadsheets that will do custom calculations on the imported table data. However one thing makes me pause. I've noticed that the function will refresh data in existing table queries whenever i open the excel file. I will be working with fundamental data which only needs to be refreshed once a month or so. So would like to refresh only on demand, and will read up on the ForceRecalculation macro for that. But how do you stop updates on entire tables, particularly when opening the file? I've just started learning some VBA, and noticed that there is a setting called .RefreshOnFileOpen which can be set to False for excel web queries. Is there a simple switch like that for GetHTMLTable function? Alternatively, does the smfUpdateDownloadTable macro work with the GetHTMLTable function as well?

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Let me restate what's in message
> http://finance.groups.yahoo.com/group/smf_addin/message/3027 and give some
> visuals of creating a range to fill using the smfUpdateDownloadTable macro:
>

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

Re: Recalculation issues (GetHTMLTable function)

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

Thu Jun 9, 2011 9:30 pm (PDT)



I think your best option for such processing would be to have your own VBA
routine that retrieves the table data with the RCHGetHTMLTable() function
and then places its values into the worksheet.

And, no, the smfUpdateDownloadTable process doesn't work for the
RCHGetHTMLTable() function -- at least not any further than getting the
first cell of the table.

On Thu, Jun 9, 2011 at 7:17 PM, winvestr <winvestr@gmail.com> wrote:

> Hello Randy, now that i've finally learnt how to use the getHTMLTable
> function, i'm eager to start building some spreadsheets that will do custom
> calculations on the imported table data. However one thing makes me pause.
> I've noticed that the function will refresh data in existing table queries
> whenever i open the excel file. I will be working with fundamental data
> which only needs to be refreshed once a month or so. So would like to
> refresh only on demand, and will read up on the ForceRecalculation macro for
> that. But how do you stop updates on entire tables, particularly when
> opening the file? I've just started learning some VBA, and noticed that
> there is a setting called .RefreshOnFileOpen which can be set to False for
> excel web queries. Is there a simple switch like that for GetHTMLTable
> function? Alternatively, does the smfUpdateDownloadTable macro work with the
> GetHTMLTable function as well?
>
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (22)
3c.

Re: Recalculation issues (GetHTMLTable function)

Posted by: "winvestr" winvestr@gmail.com   winvestr

Fri Jun 10, 2011 1:51 am (PDT)



Thanks Randy, will try it out

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> I think your best option for such processing would be to have your own VBA
> routine that retrieves the table data with the RCHGetHTMLTable() function
> and then places its values into the worksheet.
>
> And, no, the smfUpdateDownloadTable process doesn't work for the
> RCHGetHTMLTable() function -- at least not any further than getting the
> first cell of the table.
>
> On Thu, Jun 9, 2011 at 7:17 PM, winvestr <winvestr@...> wrote:
>
> > Hello Randy, now that i've finally learnt how to use the getHTMLTable
> > function, i'm eager to start building some spreadsheets that will do custom
> > calculations on the imported table data. However one thing makes me pause.
> > I've noticed that the function will refresh data in existing table queries
> > whenever i open the excel file. I will be working with fundamental data
> > which only needs to be refreshed once a month or so. So would like to
> > refresh only on demand, and will read up on the ForceRecalculation macro for
> > that. But how do you stop updates on entire tables, particularly when
> > opening the file? I've just started learning some VBA, and noticed that
> > there is a setting called .RefreshOnFileOpen which can be set to False for
> > excel web queries. Is there a simple switch like that for GetHTMLTable
> > function? Alternatively, does the smfUpdateDownloadTable macro work with the
> > GetHTMLTable function as well?
> >
> >
>

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

Fashion News

What's the word on

fashion and style?

New web site?

Drive traffic now.

Get your business

on Yahoo! search.

Yahoo! Finance

It's Now Personal

Guides, news,

advice & more.

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
MARKETPLACE

Get great advice about dogs and cats. Visit the Dog & Cat Answers Center.

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.

Diposting oleh EXCEL FEED LEARNING di 03.56

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)