NexusFi: Find Your Edge


Home Menu

 





How do I export entire database?


Discussion in MultiCharts

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




 
Search this Thread

How do I export entire database?

  #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?
How to apply profiles
Traders Hideout
What broker to use for trading palladium futures
Commodities
MC PL editor upgrade
MultiCharts
NT7 Indicator Script Troubleshooting - Camarilla Pivots
NinjaTrader
ZombieSqueeze
Platforms and Indicators
 
  #2 (permalink)
 
medias's Avatar
 medias 
Karlsruhe, Germany
 
Experience: Advanced
Platform: MultiCharts, AmiBroker
Broker: IB/IQFeed
Trading: Stocks, Emini ES
Posts: 60 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


© 2024 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 - Privacy Policy - Downloads - Top
no new posts