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.
6 freelance font une offre moyenne de ₹23442 pour ce travail
Hi, We are quite comfortable to work on your Project with our excellent team of Programmers & Designers. Please see PMB for our company Work & Experience. Thanks
Hi - I am an IT Professional with experience in web technologies for past 7 years. i can help you in writing a java utility, which can be scheduled to run in the background, to get the data from metastock files, and up Plus
Dear Sir, We are organization of Helping Customer Relationship Handlers. We have teams of variation of experts, like art society, business society and engineering society and more other. According to the jobs we ha Plus
Dear sir. I understand your point A-3 as: you would like to open the generated/converted file within Excel and like to see a value changing, as soon as the value within Metastock actually changes. I see an issue Plus