+1 888 340 6572
MultiCharts Project Management
previous_open_issue.png
Go to the previous open issue
previous_issue.png
Go to the previous issue (open or closed)
star_faded.png
Please log in to bookmark issues
feature_request_small.png
Open Feature request MC-280

Simple database api or import/export method suggestion

action_vote_minus_faded.png
8
Votes
action_vote_plus_faded.png
next_issue.png
Go to the next issue (open or closed)
next_open_issue.png
Go to the next open issue
Description

Managing market data is one of the biggest time consuming and error prone aspect of using MultiCharts.

The ideal would be a COM API that would let us create a script to:

  • List existing symbols and their attributes
  • Export symbols in CSV format
  • Delete symbols
  • Create symbols
  • Import symbol data in CSV format

    • Replacing existing data
    • Updating existing data

This would be sheer dynamite!

As a fallback, it would at least be helpful if these could be implemented via the QuoteManager by invoking it with command arguments that do these things.

For example,

quotemanager --listsymbols

quotemanager --export --symbol ZB --resolution minute --field trade --exchange cbot --source TradeStation --timezone exchange --starttime "11/8/2007 8:00am" --endtime "11/9/2007 8:00am"

quotemanager --import --symbol ZB --resolution minute --field trade --exchange cbot --source TradeStation --timezone exchange --starttime "11/8/2007 8:00am" --endtime "11/9/2007 8:00am"

This ought to be fairly easy to implement, I think, and would greatly help dealing with data stored in the database.

Steps to reproduce this issue

Just notice how long it takes to do anything that checks data or work with data!

Comments (6)
#0
user-offline.png  jek (jek)
Apr 15, 2011 - 22:14

Obviously, you would like it to be a property of export/import that the data is identical if you export, delete, then import the data without change.

#0
user-offline.png  jek (jek)
Oct 24, 2016 - 11:34

The case is marked as released but I don't see in the documentation any way to write a shell script to list and import or export symbols. It still looks like you have to go through an error prone way of automating the navigation through the user interface methods. Can you point me to the documentation that implements this request? Thanks!

#0
user-offline.png  Guest (Guest)
Oct 29, 2016 - 21:20

So can you confirm that there is still no sciptable way to import/export data?

#1
user-offline.png  jek (jek)
icon_reply.pngNov 27, 00:13, in reply to comment #0

'''Guest user wrote:'''

So can you confirm that there is still no scriptable way to import/export
data?

It looks liks #MC-1553 partially implements this, true?

#2
user-offline.png  jek (jek)
icon_reply.pngNov 27, 00:26, in reply to comment #1

I guess I got excited too quickly. MC-1553 is still a GUI-based method, it appears.

We really, really need a command line way to export and import data.

Or else a programmatic way. Please!!

'''jek wrote:'''
>

'''Guest user wrote:'''

So can you confirm that there is still no scriptable way to import/export
data?

It looks liks #MC-1553 partially implements this, true?

#3
user-offline.png  jek (jek)
icon_reply.pngAug 30, 09:05, in reply to comment #2

It would still be very simple and valuable to export/import from the command line...

History
Issue basics
  • Type of issue
    Feature request
  • Category
    Usability
  • Targeted for
    Not determined
  • Status
    Postponed
User pain
  • Type of bug
    Not triaged
  • Likelihood
    Not triaged
  • Effect
    Not triaged
Affected by this issue (3)
People involved
  • Posted by
    user-offline.png  jek (jek)
  • Owned by
    Not owned by anyone
  • Assigned to
    Not assigned to anyone
  • Subscribers
    2 subscriber(s)
    Click here to show the list of subscribers
Times and dates
  • Posted at
  • Last updated
Issue details
  • Resolution
    Not determined
  • Severity
    Normal
Attachments (0)
There is nothing attached to this issue
Commits (0)
There are no code checkins for this issue
Duplicate issues (0)
This issue does not have any duplicates