Messages In This Digest (2 Messages)

Messages

1a.: Re: Standalone SMF Addin

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

Sun Jun 5, 2011 5:13 am (PDT)

You could certainly create your own "lite" version by copying over the VBA code and then setting the proper reference libraries.

The .txt files would need to be in the same folder as the "lite" workbook if you want to use the RCHGetElementNumber() function.

But it would be possible to relocate the .txt files to some location online and modify the code that loads them. I don't think it would add a lot of overhead time when they get loaded.

Of course, if the add-in code is changed, or the .txt files are changed, you need to manually do updates of everything. That's one reason I did it as an add-in. But it would be possible to maintain all of the code automatically, with some VBA processing.

--- In smf_addin@yahoogroups.com, "alexander" <alex.life2539@...> wrote:
>
> I've noticed that there are "lite" versions of specific addins. I am
> interested in a consolidated one if that were possible. I was
> thinking that if an online copy of the .txt files can be stored
> online, it could also be looked up as well.
>
> Probably someone has done this before so I am just curious if anybody
> knows where I can start my search.

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

2a.: Re: AdvFn and S&P 500

Posted by: "iradave" web@iradave.com iradave

Sun Jun 5, 2011 8:52 am (PDT)

Randy,

DUH - I missed the fact that most of the ones missing data were either classified as Financials or Healthcare.

Thanks again,

Ira

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> I would quibble with there being "proper yearly data" -- go back and look at
> the URL you give for ACE. You'll see that because it's a financial
> institution, it has different line items than the statements of a normal
> company. For example, there is no line item for ACE called "Total Revenue".
>
> On Sat, Jun 4, 2011 at 9:55 PM, iradave <web@...> wrote:
>
> >
> > I attempted to do a retrieval of data for each of the S&P 500 stocks using
> > elements 5196, 5296, 5356 & 5616 in the RCHGetElementNumber function. For
> > about 400 of the stocks - no problems retrieving data for the last ten
> > years. But for about 100 of them the 5196-5206 come back with dates but the
> > other fields all come back with errors. Tickers that return errors include
> > ACE, AET, AFL, ALL, AXP, AIG, AMP, and so on.
> >
> > I can go to the pages on AdvFN and it shows the proper yearly data. For
> > example here is the page for ACE
> > http://www.advfn.com/p.php?pid=financials&btn=annual_reports&mode=&symbol=NYSE%3AACE
> >
> > Any thoughts on how to figure out what is wrong?
> >
>

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