Build a database to produce reports

$30-250 USD

进行中

已发布

大约 6 年前

$30-250 USD

货到付款

I receive a CSV file every day that contains data for large trades in the United States financial market. I would like to take this daily file and place it in a database. From there, I would like to have a tool that identifies whether each trade (every line in the file) was bought or sold. The overall goal is to have a tool that sorts through over 30,000 lines of data, identifies the biggest trades, and then aggregates that data. I am hoping to generate a daily summary of trading activity broken down by stock ticker symbol. Additionally, it would be great if I could easily pull adhoc reports showing trading activity for a certain stock within a specific time frame. I am open to ideas of how to complete this whether it's using mySQL and Access, or something entirely different. The solution must consist of using free or low-cost tools/applications. I will provide criteria as far as classifying whether a trade was bought or sold and how to aggregate the data.

Database Programming

MySQL

PHP

Software Architecture

SQL

项目 ID: 16313503

关于此项目

42提案

远程项目

活跃6 年前

想赚点钱吗？

电子邮箱地址

在Freelancer上竞价的好处

设定您的预算和时间范围

为您的工作获得报酬

简要概述您的提案

免费注册和竞标工作

颁发给：

@Jupiter33

I am an expert programmer with several years of experience in the realization of web and DB applications. I am interested in your project. I think it could be realized in proper way through a web php application connected to a Mysql DB. The hosting web space and DB could be easily achieved from a free host provider such as 00webhost.com. If you want to discuss the project details, you can contact me for a chat conversation on Freelancer.com portal. If I am not online, you can send me a message to fix a meeting.

$155 USD 在10天之内

5.0

(30条评论)

5.4

42威客以平均价$175 USD来参与此工作竞价

@mituld

Hi let me help you for Build a database to produce reports i have skill ,Database Programming,MySQL,PHP,Software Architecture,SQL which is very suitable to your project So send me Private message at PMB so we can discuss more about it Thanks

$155 USD 在6天之内

4.8

(472条评论)

8.3

@extreamcode

HI There, I can assist you with Build a database to produce reports. I am very passionate about quality of my work, You will be pleased working with me. Let's have a quick chat to discuss it further. You can check my sample work at: https://www.freelancer.com/u/extreamcode.html

$155 USD 在3天之内

5.0

(104条评论)

7.9

@gutibs

Hello, i can do what you need in a couple of days. And for a second version you might like to take a look at highcharts,com for example, and draw some charts with your parameters (is just an example)

$250 USD 在3天之内

4.9

(164条评论)

7.6

@claudiu07

Hi, I have extensive experience working on custom CMS/web applications in PHP/MySQL. I'll be happy to help you out. Cheers.

$222 USD 在3天之内

5.0

(63条评论)

7.4

@paris2785

Hi. My name's Paris. I'm an experienced Access database and Excel developer. Although you mention databases as the primary tool to implement what you describe in your brief I would go for another approach. Excel manipulates csv files more efficiently than Access in terms of analyzing trends, This is due to having powerful tools like Pivot Tables and Charts as well as macros that can automate repetitive tasks, like the ones you describe. My take is to go for a macro-enabled Excel Workbook that will import the csv file regularly. I'm looking forward to hearing from you. Paris

$150 USD 在5天之内

4.9

(179条评论)

7.6

@WebcoderSaurabh

A proposal has not yet been provided

$155 USD 在3天之内

4.8

(58条评论)

6.5

@VBAautomation

Hi, After having a look at your requirements my suggestion would be to create an MS Access database. An Access database can store upto 2gb of data and give you smoother performance Process: forms would have buttons to fulfill your requirements. Click on import button and select the file. It will import your all data into a table with import date. Using query make your output result and export into excel. I have excellent command here. Give me the opportunity to make you one of my happy clients. If you need I can create more functionalities here. also I will be always available for your any future task.

$122 USD 在2天之内

4.9

(28条评论)

5.7

@kahilH

Hello i suggest to build a MySql db to be more secured and i can implement a simple GUI program where you can upload the new csv file to add it besides it will have more functionalies to cover the specifications mentionned maybe graphs and generating automatic PDF reports would be also an alternative for you Thank you in advance

$230 USD 在3天之内

4.8

(35条评论)

5.5

@solucionesnet

Hi,I have a lot of expericence building windows applications to read and process csv/excel files. I can develop an application to upload the data to mysql or sql express database (free databases) and then with your help do the operations that you need, please share me a sample csv file. Check my portfolio, a lot of windows applications, my success rate is 100% projects finished.

$250 USD 在10天之内

4.7

(25条评论)

5.3

@axpsol

Dear Sir, Hope you are doing well, I have read your job description, I am willing to work with you. I have already done similar job and win 5 star rating with wonderful review. Key Responsibilities are : - I ll complete all of your requirements - I ll do more tweaks for you as well Sir i ensure you that i am best suit for this post. Please open chat with me so we can discuss more in details Looking forward to hear from you. Best Regards,

$200 USD 在10天之内

5.0

(66条评论)

5.1

@blister47

Hello, I would like to thank you for the detailed project description. I would propose this project to be done by importing the csv data into a MySQL database and using a PHP based online application to do the reporting module. We can have more discussions on the reporting system if you could please provide a sample of the csv file. I am looking forward to hear from you. Thanks.

$122 USD 在7天之内

4.9

(24条评论)

5.1

@jagdishbhatt38

I am having more than 8 years of experience in IT industry.I have worked on .net(c#.net,vb.net,asp,asp.net,mvc) with sql server 2005/2008/2012/2014/2016 and oracle(pl/sql). I can provide you better solution by utilizing my knowledge and skills.

$250 USD 在8天之内

4.9

(37条评论)

5.4

@nitin247

A proposal has not yet been provided

$161 USD 在9天之内

4.9

(29条评论)

5.1

@mandalpu

Hi, I can get this done. I have similar setups where I collate data from various sources at EOD and summarize it for further use.

$222 USD 在10天之内

4.9

(5条评论)

5.3

@ddash

Hello, I think we can do it automated by cronjob. From source we will pull the data daily and insert the data to database and generate the report as per your requirement. As we have data in database in formatted manner we can generate the report the way you need. Thanks, Devi

$166 USD 在4天之内

5.0

(11条评论)

4.8

@mayankinnovative

A proposal has not yet been provided

$150 USD 在3天之内

4.5

(187条评论)

4.8

@houssmann

Hello,I'm an experienced Software Developer, I can develop a tool that corresponds to your needs using Java or C# easily and in no time.

$100 USD 在3天之内

5.0

(5条评论)

3.6

@ankitshow9

A proposal has not yet been provided

$100 USD 在5天之内

4.9

(2条评论)

3.3

@carlton16

Hi, The steps to complete this project are as below:- 1) creat form to upload csv file. 2) read the csv file in php and sort the data as per required. 3) store data in database. 4) Do R&D to find plugin to pull adhoc reports. Or we can use API calls. Let us discuss in details. Thanks!

$160 USD 在5天之内