Import csv with stock tickers and format using R x64

I have an .csv that changes once per day, that I need to import into R. Filter on date, and lookup stock price and volume.

Further details are below

Version: R x64 3.4.3

Import .csv with 24 columns

Filter stocks by date showing the next 2 days

Lookup stock price and volume (from ONLY NASDAQ, NYSE or TSX, excluding others) for stocks above

Sort by day, with highest volume on top and bind specific columns

Exclude rows with volume lower than 100,000 per day

All numbers should have proper formatting for easy reading

Example of final output I am looking for;

Date Stock Price Market Volume Notes

2/3/2018 CC $5 NSDQ 2,000,000 Before

2/3/2018 AA $6 NYSE 100,000 After

2/4/2018 BB $15 TSX 650,000 After

Taidot: R-ohjelmointikieli

Näytä lisää: r write csv append, write.csv() r, r read csv column names, write multiple csv files in r, r write csv without header, r write csv without index, write.csv r documentation, read.csv r example, prestashop import csv stock, import csv file mysql database using codeigniter, import csv sql server 2000 using vb6, import csv stock oscommerce, import csv access using vbnet, import csv access visual using basic, import csv access using asp, oscommerce import csv format, import csv sql database using dts, import csv mysql using web form, import csv using entityspaces, import csv file sql 2005 using wizard

Tietoa työnantajasta:
( 11 arvostelua ) Duncan, Canada

Projektin tunnus: #16290697

1 freelanceri on tarjonnut keskimäärin 50 $ tähän työhön


Hi I am a very experienced statistician and academic writer. I have completed several PhD level thesis projects involving advanced statistical analysis of data. I have worked with data from several companies and have d Lisää

$50 CAD / tunti
(17 arvostelua)