Announcement

Collapse
No announcement yet.

Automatically Exporting Data Into Excel

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Automatically Exporting Data Into Excel

    Hi

    Is there a way to programme ESignal to export price/info data to an excel file automatically.

    Regards

    Mike

  • #2
    I'm not quite sure what you mean, but there is a way to link an Excel sheet to the eSignal Datafeedmanager via a DDE link.

    For more info:

    http://www.esignal.com/support/eSignal/Tips/tipsDDE.asp

    and

    http://www.esignal.com/exchange/v18_..._spotlight.asp

    Cheers,


    Edo.

    Comment


    • #3
      Hi

      Thank you for responding my question wasn't well worded.

      I about to purchase a backtesting software, and was wondering if there was a way to export daily data so that I can compile history on a specific stock.

      I am familiar with a DDE link and currently use one, however I thought there may be a way of writing a macro to export data from a specific stock into a text or csv file.

      Thanks

      Mike

      Comment


      • #4
        Hi Mike.....U probably have seen this but u can use yahoo downlaod quote or yahoo portfolio to download stock data directly to a CSV file read by Excel for free....here is an example link

        INTC quote Yahoo finance site

        but if u already own a DDE link, that would likely be a faster way to read in the data....

        What do u plan on using to backtest, I would like to test a few things out myself..........

        Comment


        • #5
          I am looking to use the TradeSim simulation platform.

          Regards

          Mike

          Comment


          • #6
            Originally posted by mickson

            I about to purchase a backtesting software, and was wondering if there was a way to export daily data so that I can compile history on a specific stock.

            I am familiar with a DDE link and currently use one, however I thought there may be a way of writing a macro to export data from a specific stock into a text or csv file.

            If you want to export data on an ad hoc basis. The simplest and cheapest way is to just open an advanced chart. Make sure you have sufficient data on the chart (I use a time template for this purpose which has nr. of bars / days set to 10000). Right click on the chart, choose tools, choose, Data Export, select the columns you want to export, filename, voila).

            If you want to export data on a very regular basis, you can choose the option mentioned by Marginman (don't know this). May I also highly recommend Qcollector for eSignal (http://www.mechtrading.com/qcollector/esignal/ ).
            I'm using this to build my own database of data, for external programs. You can set automatic downloads for symbols, if you want.

            Cheers,

            Edo.

            Comment

            Working...
            X