? ?
?
1)? ? ? ? ? Combine 3 comma delimited text files.
2)? ? ? ? ? Combine 2 comma delimited text files. ?
3)? ? ? ? ? Write a small program that will close [login to view URL] or End Process.
?
I plan to run these with Microsoft’s Scheduled Tasks, which runs every day.? I want the programs to not run if it is Saturday or Sunday.
## Deliverables
1) There will be csv file in Excel file:
? ? ? ? C:\Documents and Settings\John Stephens\My Documents\StockFinder\John
? ? ? ? Stephens\Export\[login to view URL] with the following columns:
? ? ? ? Symbol, Date, Time, MovAvg, then 10 columns of TRUE or FALSE.
?
There will be a comma delimited text file:
? ? ? ? C:\Program Files\Telecharts\Export\Close [login to view URL] with the following information:
? ? ? ? Symbol, Close Price, Company Name, Industry Group
?
You are to put together the two files in one text file plus take the previous D1 through D4 of the old C:\Program Files\Telecharts\Export\[login to view URL] make them D2 to D5 and put into a new C:\Program Files\Telecharts\Export\[login to view URL] with the following columns:
? ? ? ? Symbol, AvgVol, Date, Company Name, Industry Group, D1 (which is the total number of TRUE of 10 TRUE/FALSE COLUMNS), D2 which is the previous days D1, D3 previous day D2, D3, D4, D5,
?
If for some reason the Company Name or Industry Group do not exist be sure to put in commas for them to reserve a space in the text file.
?
With Scheduled Tasks, my automatic downloads and this program will run every day.? The data from Saturday and Sunday will be almost identical to Friday’s data.? I want this program to skip or not run on Saturdays and Sundays.? I don’t want D values for Saturday and Sunday.
?
2) There will be an Excel file:
? ? ? ? C:\Documents and Settings\John Stephens\My Documents\StockFinder\John
? ? ? ? Stephens\Export\[login to view URL] with the following columns:
? ? ? ? Symbol, Date, Time, Price Hist, Price Hist, Price Hist, Price Hist,
Actually they are:
? ? ? ? Symbol, Date, Time, Open, High, Low, Close
Take the close from this file and replace the Close Price in
? ? ? ? C:\Program Files\Telecharts\Export\Close [login to view URL]
? Symbol, Close Price, Company Name, Industry Group
?
Same as above, skip running on Saturday and Sunday.
?
3)? Write a small program that will close [login to view URL] or End Process.