Question

Write a C++ program that will input data from a Comma-separated values (.csv) file and output some information about it. This program uses a csv file from Yahoo Finance

(.csv) filename : SBUX.csv

1. Output the name of the ticker to the console screen (without the “.csv”)

2. Output the start date and end date that was found in the file

3. Output how many trading day(s) existed in the file

4. Prompt the use to input a number of records

5. Input the number of records from the console screen

6. Output the following heading to the console screen: Date Open A.Close Percent Change

8. Output the top x records for that ticker within the provided date range. Here x is the number of records that the user inputted previously. The top record is the record (row) that had the greatest percent change when comparing the open price to the adjusted close price (from the same day). The top records are the set of records that had the greatest percent changes amongst all records. The percent change is defined as follows: (adjusted close price – open price) / open price * 100 These records need to be displayed from highest percent change to lowest percent change. The program only needs to display the following information from that row: date, open price, adjusted close prices, and the percent change (for that 1 day).

9.The program will let the user know if they entered a number of records that is too large. It will continue to ask the user to input a number of records until they enter a number that is less than or equal to the number of trading day(s).

SBUX.csv sample information:

Date	Open	High	Low	Close	Adj Close	Volume
1/1/2009	null	null	null	null	null	null
2/1/2009	4.63	5.385	4.45	4.575	3.668556	487465600
3/1/2009	4.49	6.215	4.06	5.555	4.454388	574769000
4/1/2009	5.495	7.72	5.405	7.23	5.797522	656683400
5/1/2009	7.21	7.25	6.26	7.195	5.769456	555559800
6/1/2009	7.285	7.7	6.77	6.945	5.568988	521311000
7/1/2009	6.99	8.95	6.38	8.85	7.096554	673380800
8/1/2009	8.99	9.925	8.835	9.495	7.61376	493708000
9/1/2009	9.49	10.47	9.105	10.325	8.279309	498955800
10/1/2009	10.27	10.555	9.345	9.49	7.609747	424346200
11/1/2009	9.49	11.05	9.425	10.95	8.780479	436812000
12/1/2009	10.975	11.975	10.475	11.53	9.245566	394275400

Sample Run2 This program will analyze MSFT from 2018-11-08 to 2019-02-07 61 trading day (s) exist in the file. How many increase records do you want to find? 5 Date 2018-12-26 2018-12-06 2018-11-28 2019-02-04 2018-12-10 Press any key to continue . . . Open A.Close Percent Change 95.14 100.56 5.69687 1Θ5 . 82 109.19 3.18466 107.89 111.12 2.99379 102.87 105.74 2.78992 104.8 107.59 2.66221 Sample Run 3 This program will analyze A from 1999-11-18 to 2019-02-11 4837 trading day(s) exist in the file How many increase records do you want to find? 10 Date 2000-03-06 2016-02-17 2000-02-17 2018-12-26 2018-12-27 2018-03-07 2018-11-07 2019-01-30 2019-01-04 2018-11-28 Open A.Close Percent Change 80.8298 98.9023 22.3588 35.22 36.7841 4.44096 57.9399 60.3366 4.13656 62.93 65.3783 3.89054 64.5 67.36 69.0599 2.52357 66.51 68.0916 2.37801 73.74 75.44 2.3054 64.09 65.46 2.13762 69.82 71.3037 2.12499 66.316 2.81551

Answer 1

//Program in cpp

//program for getting first, last and trading days from existing file

#include<stdio.h>
#include<stdlib.h>
#include<vector>
#include<iostream>
#include <bits/stdc++.h>
#include <sstream>
#include <string>
#include <cstring>
#include <bits/stdc++.h>
using namespace std;

int main(){
ifstream infile("SBUX.csv");
ifstream countfile("SBUX.csv");
string line;
char *Lastday;
int startfl=0,edflag=0,nulllinecount=0,linecount,paracount=7,count=0;
while (getline(countfile, line))//getting total record from file
{
   count++;
}

countfile.close();

while (getline(infile, line))
{
//cout<<line<<"\n";
int n = line.length();
// declaring character array
char char_array[n + 1];
//convert string to char array
strcpy(char_array, line.c_str());

linecount++;
if(strstr(char_array, "null") != NULL) {// if line consist null then increase nullcount by 1
    nulllinecount++;
    continue;
}
//divide line it by , comma
char *token = strtok(char_array, ",");
int i=0;
while (token != NULL)//till end of file
    {
      
        if(i==0 && startfl==0){// condition for start trading day
        printf("Start Trading Day is %s\n", token);
      
       startfl=1;  
       }
  
       else if((count-1)==linecount && i==0){// condition for start trading day
  
       printf("Last Trading Day is %s\n", token);
       }
        i++;
        token = strtok(NULL, ",");
      
   }

}
printf(" Trading Days are %d ",linecount-nulllinecount+1);
infile.close();
}

/*

output

CAUsers\Harsh\Desktop\a.exe Start Trading Day is 2/1/2009 Last Trading Day is 12/1/20e9 Trading Days are 11 Process exited after 3.057 seconds with return value e Press any key to continue . .

input file in SBUX.csv (open it in excel)

SEX Microsoft Excet Praduct Activation Faied File Home Insert Page Layout Formulas Dta Review View ぬCut Calibri Copy seyFormat Painter Paste Blu- o- Formatting as Tabl Clipboard Font Alignment Number Styles A1 | 01-01-2009 null null null null 1 01-01-2009 null 2 02-01-2009 4.63.3854.454.575 3.668556 4.87E+08 null 03-01-2009 4.49 6.215 4.065.555 4.454388 5.75E+08 4 04-01-2009 5.495 7.72.47.23 .797522 6.57E+08 5 05-01-2009 7.195 5.769456 5.56E+08 7.76.945 5.568988 5.21E+08 6 06-01-2009 7.285 7 07-01-2009 98.95 6.38 8.85 7.096554 6.73E+08 8 08-01-2009 9 09-01-2009 9.49 10.47 9.105 10.325 8.279309 4.99E+08 10 10-01-2009 10.2710.555 9.3459.49 7.609747 4.24E+08 11 11-01-2009 9.4911.05 9.425 10.95 8.780479 4.37E+08 12 12-01-2009 10.975 11.975 10.475 11.53 9.245566 3.94E+08 12 8.999.9258.835 9.495 7.61376 4.94E+08

*/

//Program for accepting data from user and add it into input.csv file and getting first, last and trading days from accepted data

Program in c++

#include<stdio.h>
#include<stdlib.h>
#include<vector>
#include<iostream>
#include <bits/stdc++.h>
#include <sstream>
#include <string>
#include <cstring>
#include <bits/stdc++.h>
using namespace std;
//program for getting first, last and trading days from existing file
int main(){
ifstream infile("input.csv");
ofstream outfile("input.csv");
int nn,j;
cout<<" \n ENter the number of record for file";
cin>>nn;
string data;
int open,high,low,close, adjclose,volum;
//accept data from file
for(j=0;j<nn;j++){
   cout<<"\n Enter Date,open,high,low,close, adjclose,volum for record"<<j<<"\n";
   cin>>data>>open>>high>>low>>close>>adjclose>>volum;
   outfile<<data<<","<<open<<","<<high<<","<<low<<","<<close<<","<<adjclose<<","<<volum<<"\n";
  
}
outfile.close();
string line;
char *Lastday;
int startfl=0,edflag=0,nulllinecount=0,linecount,paracount=7,count=0;
while (getline(infile, line))
{
//cout<<line<<"\n";
int n = line.length();
// declaring character array
char char_array[n + 1];
//convert string to char array
strcpy(char_array, line.c_str());

linecount++;
if(strstr(char_array, "null") != NULL) {// if line consist null then increase nullcount by 1
    nulllinecount++;
    continue;
}
//divide line it by , comma
char *token = strtok(char_array, ",");
int i=0;
while (token != NULL)//till end of file
    {
        //cout<<"\n"<<(nn-1)<<"---"<<linecount<<"-"<<i;
        if(i==0 && startfl==0){// condition for start trading day
        printf("Start Trading Day is %s\n", token);
      
       startfl=1;  
       }
  
       else if((nn-1)==linecount && i==0){// condition for start trading day
  
       printf("Last Trading Day is %s\n", token);
       }
        i++;
        token = strtok(NULL, ",");
      
   }

}
printf(" Trading Days are %d ",linecount-nulllinecount+1);
infile.close();
}

/*

output

ClUsers\ Harsh1Desktopla.exe ENter the number of record for file 2 Enter Date,open,high,low, close, adjclose, volum for recorde 06/04/1990 89 90 88 85 85 98546 Enter Date,open,high,low,close, adjclose, volum for record1 07/04/1990 95 98 54 95 84 45214 Start Trading Day is 06/e4/1990 Last Trading Day is 07/04/1990 Trading Days are 2 Process exited after 65.41 seconds with return value e Press any key to continue . . . 1鮮

input.csv

File Home Insert Page Layout Formulas Review View Cut Calibri Wrap Text Date Copy 朢 Paste Blu h▼▲7 를 E 幽Merge & Center ▼ -. Font Format Painter Clipboard Alignment A1 06-04-1990 85 98546 1 06-04-1990 2 07-04-1990 89 90 85 95 98 54 95 84 45214 4 6

*/