data to excel converter program data to excel converter program

data to excel converter program A. Data changer 1. To produce an excel masterfile (excel 2010) by coverting data from Metastock files in a metastock folder so that the worksheet accurately represents all the OHLCV values of all securities values in the metastock folder. Detailed format of OHLCV data will be provided. 2. All securities in the metastock folder will be automatically assigned new securities names as column header in Excel. 3. When the metastock file data is updated, the worksheet will be updated at the same time (whether the sheet is opened or not) 4. The Metastock folder may add or delete securities over time, and the Excel master file will update automatically. B. Small data set generator A control interface can select the columns from the Master file and generate new subsidiary dataset files. The output will be new dataset files (excel 2003 or .csv file) with customized file names (assigned by the user) The newly generated excel files will be updated (or overwritten) simultaneously when the master file changes. the update is performed at the background, even when the file is closed or opened (access right will belong to the program when updating). *The Master file column structure may change over time, that is, some securities may be deleted or added into the metastock folder, but such changes will not affect the udpating of the subsidiary files, even the sequence of the columns in the Master file may change. Please feel free to suggest any another more efficient and reliable way to achieve the final aim.