Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Earnings Dates into Excel

  Asked By: Kristopher    Date: Feb 06    Category: MS Office    Views: 1731
  

I know that a lot of you use Excel for analysis, so hopefully this isn't to
far off topic. I know a bunch of websites that I can go to for a list of
the past and future earnings release dates for a company. However, I'm
trying to get the last earnings release date and the next earnings release
date auto populated into a two cells. So, if I had a symbol, say CSCO in
A1, I want the last earnings date in A2 and the next earnings date in A3.
Does anyone know of a way to do this? Or has written the logic in Excel
with this ability.

Ex. CSCO 2-6-07 5-8-07

Share: 

 

1 Answer Found

 
Answer #1    Answered By: Hilma Miller     Answered On: Feb 06

I have a free open-source add-in that can do that for you.
For example, these two formulas:

=RCHGetElementNumber("CSCO",1290)
=RCHGetElementNumber("CSCO",1295)

...return:

8-May-07
6-Feb-07

...from earnings.com. There is a template in the files area to return
the last 23 earnings announcements from earnings.com.

 
Didn't find what you were looking for? Find more on Earnings Dates into Excel Or get search suggestion and latest updates.




Tagged: