private void cDataGridView1_ButtonSelectClick(CDataGridView cdgv, int rowindex, int columnindex)
{
string linetabletypename = ""; //表结构名称
string linetablename = ""; //表名称
if (((DataTable)cdgv.DataSource).TableName.ToString() == "IM")
{
linetabletypename = ((DataTable)cdgv.DataSource).Namespace.ToString() + "T" + "." + ((DataTable)cdgv.DataSource).Rows[rowindex]["Code"].ToString();
}
else
{
linetabletypename = ((DataTable)cdgv.DataSource).Namespace.ToString() + "." + ((DataTable)cdgv.DataSource).Columns[columnindex].ColumnName.ToString();
}
linetablename = linetabletypename + "[R" + (rowindex + 1).ToString() + ",C" + (columnindex + 1).ToString() + "]";
if (!ds.Tables.Contains(linetablename))
{
//不存在则创建
DataTable dt = new DataTable();
dt = ds.Tables[linetabletypename].Clone();
dt.Namespace = linetabletypename;
dt.TableName = linetablename;
ds.Tables.Add(dt);
}
FullTable a = new FullTable();
a.Text = linetablename;
a.ds = ds;
a.dt = ds.Tables[linetablename];
a.ShowDialog();
cdgv.Rows[rowindex].Cells[columnindex].Value = "点击赋值:" + a.lines.ToString() + "行";
}
private void toolStripMenuItem4_Click(object sender, EventArgs e)
{
try
{
FullTable a = new FullTable();
a.dt = this.DataSource as DataTable;
a.Show();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public async Task PrepareData()
{
// Prepare data only if needed
if (Config.Reload || !File.Exists(Config.FullDataFile))
{
// Data
DataContainer dataContainer = new DataContainer();
// Data list
DataSource[] dataSources = new DataSource[] {
new Products(Config.Reload),
new HistoricalPrices(Config.Reload),
new Weather(Config.Reload),
new Forex(Config.Reload),
new Google(Config.Reload),
new WikiTrends(Config.Reload),
new Futures(Config.Reload),
new Fundamentals(Config.Reload)
};
// Go to data folder
Directory.SetCurrentDirectory(Config.DataDirectory);
// Prepare all data
foreach (DataSource ds in dataSources)
{
await ds.Prepare(dataContainer);
}
// Create datatable
FullTable fullTable = new FullTable();
fullTable.CreateFullTable(dataContainer);
// Export data
Directory.CreateDirectory(Config.TradingDataFolder);
Exporter.ExportCSV(fullTable.DataTable, true, Config.FullDataFile, "Exporting full data");
Console.WriteLine();
}
// Create RNN data
if (Config.Reload ||
!File.Exists(Config.RnnTrainXFile) ||
!File.Exists(Config.RnnTrainYFile) ||
!File.Exists(Config.RnnValidXFile) ||
!File.Exists(Config.RnnValidYFile) ||
!File.Exists(Config.RnnTestXFile) ||
!File.Exists(Config.RnnTestYFile))
{
// Create datatable
RnnTable rnnTable = new RnnTable();
rnnTable.CreateRnnTable();
// Export data
Exporter.ExportRnnConfig(rnnTable.RnnConfig, Config.RnnConfigFile);
Exporter.ExportCSV(rnnTable.TrainX, Config.RnnTrainXFile);
Exporter.ExportCSV(rnnTable.TrainY, Config.RnnTrainYFile);
Exporter.ExportCSV(rnnTable.ValidX, Config.RnnValidXFile);
Exporter.ExportCSV(rnnTable.ValidY, Config.RnnValidYFile);
Exporter.ExportCSV(rnnTable.TestX, Config.RnnTestXFile);
Exporter.ExportCSV(rnnTable.TestY, Config.RnnTestYFile);
Console.WriteLine();
}
}
