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?
Iran and Israel Stand Down: What $9M in Peace Contracts …
Prediction Markets & Event Contracts
The Backwardation Signal: How the CL Futures Curve Tells …
Commodities
Sundays Verdict: Lebanon Locked at 99.85% as Iran June 7 …
Prediction Markets & Event Contracts
ATFX Suspends Prop Trading Unit ATFunded -- Full Review …
Funded Trading Evaluation Firms
Khamenei Vetoes Uranium Transfer as Peace Odds Surge to …
Prediction Markets & Event Contracts
 
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