Help with intermediate vba project. stock date and prices.

I'm working on an intermediate project, but I'm a novice at VBA. I've been given stock date and prices and need to accomplish (1) i've to make a file that publishes the data with the date and stock price, (2) make a file with stock averages and (3) make a file with dates when the stock price was a certain price. I'm not allowed to use any Excel-related objects or functions or make references to cells, Ranges, Worksheets, worksheet functions, etc. cannot copy/paste data into worksheets.I've been given a csv file, but don't really know where to begin. Appreciate any help or guidance.

Does the project require that you use VBA and manually perform all calculations? If not, I feel that Pivot Tables may be able to better organize the data after importing it into Excel using the Data Import from Text feature to create the spreadsheet from a CSV.

However, if this requires VBA without any of Excel's higher functions then this certainly can get somewhat complicated. When you say you have to make a file that publishes the data for each of your 3 requirements, does this mean create three separate spreadsheet files (.xlsx) or back to a new (.csv)? Either way, I suggest looking into examples of reading from and writing to .csv or .txt files.

Yea suppose to perform all calculations manually and then publish them as 3 csv files. Any place online that i might be able to find a code template that i might be able to work with?