NexusFi: Find Your Edge


Home Menu

 





How do I export entire database?


Discussion in MultiCharts

Updated
    1. trending_up 2,945 views
    2. thumb_up 1 thanks given
    3. group 3 followers
    1. forum 2 posts
    2. attach_file 0 attachments




 
Search this Thread
  #1 (permalink)
 Crow 
Las Vegas, Nevada
 
Experience: None
Platform: MultiCharts
Posts: 52 since Apr 2010
Thanks Given: 20
Thanks Received: 19

I want to export tick data that I have collected in MultiCharts stored in the quote manager database. Is there a way to do that besides manually exporting one symbol at a time into ASCII?


Started this thread Reply With Quote

Can you help answer these questions
from other members on NexusFi?
$4.5M Floods Russia Nuclear Contract in 24 Hours -- Krem …
Prediction Markets & Event Contracts
Iran Talks Final Stages -- Two VLCCs Exit Hormuz, Record …
Traders Hideout
Penalties in Budapest, Peace Deadline in Tehran: Arsenal …
Prediction Markets & Event Contracts
April Jobs Beat Flips Fed Hike Odds Past 52% for First T …
Traders Hideout
Bookmap Global Plus Lifetime + Lifetime Addons For Sale
Platforms and Indicators
 
Best Threads (Most Thanked)
in the last 7 days on NexusFi
NexusFi site changelog and issues/problem reporting
16 thanks
Darmok and Jalad at Tanagra
3 thanks
Big Mike in Ecuador
2 thanks
CME Expands 24/7 Trading to WTI Crude Oil and Gold -- We …
1 thanks
30 Sessions
1 thanks
  #2 (permalink)
 
medias's Avatar
 medias 
Karlsruhe, Germany
 
Experience: Advanced
Platform: MultiCharts, AmiBroker
Broker: IB/IQFeed
Trading: Stocks, Emini ES
Posts: 59 since Jul 2009
Thanks Given: 30
Thanks Received: 49

Bulk exporting is unfortunately possible only to MultiCharts file format (.qmd). When exporting to ASCII, you have to do it manually for each single symbol.
See QuoteManager > File > Export...


Reply With Quote
  #3 (permalink)
clonardo
New York, NY USA
 
Posts: 6 since Oct 2013
Thanks Given: 0
Thanks Received: 5


I can only speak for MC.NET, but the somewhat hack-y way that I'd do it is as follows:

1) Create MySQL database with the schema needed to hold your data, whether locally (ideally in Memory/heap) or on another machine
2) Build a function to connect to the database. Grab the variables that you care about, and add them to a handy INSERT INTO query (you would likely need to do this within the CalcBar() method, unless you wrote into an array first and then inserted the array)
3) Run your portfolio (this will also work in Portfolio Backtester).
4) Enjoy your new, MySQL-based freedom.

Happy to PM you some code if it would help you out. I use a ton of custom data with MultiCharts.


Reply With Quote
Thanked by:




Last Updated on October 11, 2013


© 2026 NexusFi®, s.a., All Rights Reserved.
Av Ricardo J. Alfaro, Century Tower, Panama City, Panama, Ph: +507 833-9432 (Panama and Intl), +1 888-312-3001 (USA and Canada)
All information is for educational use only and is not investment advice. There is a substantial risk of loss in trading commodity futures, stocks, options and foreign exchange products. Past performance is not indicative of future results.
About Us - Contact Us - Site Rules, Acceptable Use, and Terms and Conditions - Downloads - Top
no new posts