Excel API that accepts functions with arguments?

Discussion in 'Automated Trading' started by cordura21, Jan 30, 2009.

  1. Hello. I used to have Bloomberg with has connectivity to excel thru DDE.
    I checked some API's like the IB one and they offer this feature too.

    However, Bloomberg has the alternative to use functions with arguments, so they are not 'hard-coded' like many of the DDE implementations.

    Do you know of an API that gives this options, something like "=GET.DATA("MSFT","LAST")

    Google Finance via Google Docs does it, but not for intraday.

    I'm not ruling IB out, it's just that I couldn't find it.

    Thanks a lot.

    Cheers, Andrés
  2. google spreadsheets should update prices as they change intraday... it does for me... not on every tick, but maybe once a minute or as it changes.
  3. That's true. But it doesn't allow you to ask him for older intraday prices (it allows you for older daily ones), and since it doesn't have macros you can't collect them yourself. I'd like to have something that's backfilled. Plus, it's still cumbersome when you try to use it as a spreadsheet.
  4. Looks very promising and cool. Gonna check it out.