Earnings 2

****NOTE: A new version is now available here. This version is no longer maintained.

A version that downloads from briefing.com.


  1. I have been trying to use earnings.xls for the last couple of days but and I keep getting - run-time error "9". Subscript out of range. This was happening once in a while before so I would just re download but now it is happening all the time. I also tried to download your new version but I keep getting sent back to the original.
    Your help would be much appreciated.

  2. Hi again, I got the first version working. It was my security - for some reason it had reset so I followed your previous instructions - enabling macros etc. and it worked just fine. But, I would like to check out the 2nd version from Get briefing.com.

  3. ExcelTrader says:

    There are two links, one refers to the old post and the second is a direct link to the newer version. In the post, click on "new version"

  4. i have been trying to get earnings.xls to work but i keep getting run time error '-2147417848 (80010108)
    automation error
    the object invoked has disconnected from its clients

  5. ExcelTrader says:

    sean, I just tested and cannot duplicate the issue you report. Download the original file and verify that the issue is occurring on a completely unaltered version of earnings.xls. If so, let me know the Excel version that you are using and I will look into it in more detail.

  6. i downloaded the original, i tried again with same result, im running excel 2007 on vista ultimate

  7. I keep getting these messages:
    *Data unavailable for ANV
    *Data unavailable for NUS
    *Data unavailable for BONT
    *Data unavailable for X
    *Data unavailable for ASIA
    *Data unavailable for MSFT
    *Data unavailable for GOOG
    *Data unavailable for XKSJBS
    *Data unavailable for MSFT

  8. Hi, I have downloaded the B_earnings.xlt spreadsheet and found that when I search for earning dates, the error log says earning dates are unavailable for all. Why is this happening?

    Thanks and best regards,

Speak Your Mind