Wealth-Lab Wiki

API ChartStyles Community Components Community Indicators IndexDefinitions Knowledge Base Misc Optimizers Pending Deletion PosSizers Providers Standard Indicators TASC Traders Tips TASCIndicators Tutorial Videos Visualizers
RSS

Navigation


Quick Search
»
Advanced Search »


Data | Exporting data out of WL6 to ASCII and binary files

RSS
Note:
Version 1.2.5 of the ASCII data provider contains an architectural change that brings serious performance improvements. From now on, it makes possible to work with ASCII files at the speed of binary files! If you used to export ASCII data to binary formats to speed up processing, there's no more need to do so.

Exporting to ASCII comma-separated files (CSV)

With WL6 you can export data effortlessly when required. The example below dumps security data of each symbol in the DataSet to ASCII comma-separated (CSV) files. (Modified routine 2/18/2014 to use simply use File.WriteAllLines instead of StreamWriter.)

Configure target directory:

using System;
using System.Collections.Generic;
using System.Text;
using WealthLab;
using System.IO;

public class Export2ASCII : WealthScript { protected override void Execute() { const string sep = ","; const string fmt = "0.00########"; string dtefmt = "yyyyMMdd"; if( Bars.BarInterval > 0 ) dtefmt = "yyyyMMdd HHmm"; string path = @"C:\Data\ASCII\"; if (!Directory.Exists(path)) throw new Exception("You must create the directory " + path); PrintStatusBar("Exporting: " + Bars.Symbol); string file = path + Bars.Symbol + ".csv"; List<string> datalist = new List<string>(); for(int bar = 0; bar < Bars.Count; bar++) { string csv = Date[bar].ToString(dtefmt) + sep + Open[bar].ToString(fmt) + sep + High[bar].ToString(fmt) + sep + Low[bar].ToString(fmt) + sep + Close[bar].ToString(fmt) + sep + Volume[bar].ToString("0"); datalist.Add(csv); } File.WriteAllLines(file, datalist); RestoreContext(); PrintStatusBar("Complete!"); } }

Getting dates formatted in a custom way

To create the Date/Time in one of the standard formats (or in a custom one), modify the code as shown below:

As you see, instead of using the .ToShortDateString that takes the format specified in Windows Control Panel's Regional settings applet, we're getting the desired output by using .ToString() and passing a format string:


...
csv.WriteLine( Date[bar].ToString("yyyyMMdd") +
...

This instructs the program to output the date formatted as yyyymmdd. More format examples can be found on Microsoft's site:


Standard DateTime Format Strings
Custom DateTime Format Strings


Exporting as WLD 3/4 native binaries (*.WL)

WL3/4 support has ended. Protected content.

Important Disclaimer: The information provided by Wealth-Lab is strictly for informational purposes and is not to be construed as advice or solicitation to buy or sell any security.  The owner of Wealth-Lab.com assumes no liability resulting from the use of the material contained herein for investment purposes. By using this web site, you agree to the terms of this disclaimer and our Terms of Use.

Used under license from FMR Corp. Copyright 2008 FMR Corp. All rights reserved.


ScrewTurn Wiki. Some of the icons created by FamFamFam.