New Members: Be sure to confirm your email address by clicking on the link that was sent to your email inbox. You will not be able to post messages until you click that link.

Export Chartlist data into CSV file

I am trying to download a csv file of the data that is in my chartlist. Can someone please provide me a simple way to make this happen. Thank you in advance.

Comments

  • markdmarkd mod
    edited May 4
    I may have missed it, but I don't see a button in any of the list views for downloading as CSV, so I get the question.

    However, if you run a scan on the list, there is a 'Download CSV' button at the top of the results page under the green "Save to Chartlist" button.

    The scan is just the chart list name, no additional logic (unless you want to - maybe add a 'rank by' line). On your Member page, open the Advanced Scan page (Scan Workbench), delete the default text in the scan window, find the Your Chartlists dropdown at the bottom of the page under the scan window. Open the dropdown, find the list you want to CSV and click on it. Then click "Add".

    The number of the list and the full name will appear in the scan window. For example,

    and [ChartList is 3] // 10 10 01 00 (w8) XLE OL + + + ENERGY $DJUS OL Integrated Oil and Gas

    Yours will be different.

    Delete the "and" preceding the list name to get rid of the error message. (the error is there because a scan must begin with a left bracket "[" ; it can't begin with "and"). So,

    [ChartList is 3] // 10 10 01 00 (w8) XLE OL + + + ENERGY $DJUS OL Integrated Oil and Gas

    Then run the scan. Then click the Download CSV button at the top of the results page. Easy after you've done it once.

    If you feel like it, you could send a (politely worded) suggestion to Support to put a CSV button on the Summary view page (or whatever page(s) you think would be most convenient).



  • tleatlea
    Thank you very much for the detailed response. Your suggestion works great for my workflow, the simple additional step of scanning an existing chartlist isn't worth the programmer's effort for my purpose so I will hold off on a request for now. Thanks again...
Sign In or Register to comment.