Excel Expert Needed - Mass data analysis and visualization
$1500-3000 CAD
着払い
I will provide Historic Trading Data from quotemedia, which I have a subscription for. They can only export 1,000 rows of trade data at once. If you can find a workaround to export all data at once this will save me a lot of time, but is not the focus. This can be a separate project actually.
The project is for post data acquisition.
On average, there will be anywhere between 15,000 to 50,000 rows of trade data (sometimes more). These rows will include: Time & Date Stamp, Buy amount, Sell amount, VWAP, Buyer, Seller, Exchange and Price. I need macros built that can build reports for each buyer and each seller independently. I will follow up with what metrics I'll need included. As well, I'll need a dynamic dashboard created that can filter and adjust the data based on time stamps , buyer, seller and exchange. I have attempted building a spreadsheet to simply calculate cumulative positions of each buyer/seller, but even that one piece crashes excel.
Any advice/strategy on how to best streamline this project as well would be completely taken into consideration.
The attached image is a snapshot of the data from columns A to I. All columns from J to LL basically (253 different buyers/sellers) are simply my way of getting their cumulative positions. This obviously needs to be done more efficiently.
Ideally this would be a fixed price project. $1,500 is my price at the moment for a good base product. If I like the first project there will be HUGE space for additional add-ons to build in as I have a large number of things I'd like to build into this data eventually.
EDIT: Because of the overwhelming amount of high quality proposals, I will be proposing the full idealistic vision of my project. This has been a work in progress on my end for a long time and will require someone who will like to help problem solve with me and data-scraping and database management skills may be needed. Cost is obviously flexible. I will not choose the cheapest or most expensive. I'll be looking for value and someone who understands my vision from the get go. I'll be creating the full proposal in the coming days and would prefer to bill on an hourly rate. Please stay tuned and I appreciate the patience.
プロジェクトID: #16675774
プロジェクトについて
23人のフリーランサーが、平均$1655 で、この仕事に入札しています。
Hello, I have the good knowledge of Excel Expert Needed - Mass data analysis and visualization . I have more than 5 years of experience in Excel. We have worked on several similar projects before! We have worked o もっと
HI, I am good at Excel advanced formulas and VBA. Looking forward to work on the project. I have reviewed the detailed description provided. Please share the file. Looking forward to discuss further about the pr もっと
Hello, I’m an Excel/VBA expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.
Hi, I understand the project requirements and willing to start as soon as possible. Kindly share the details and I will deliver with high quality. Looking forward to work with you. Thanks & Regards Khushi India
Hi: I have read the project description and here are my suggestions: 1) We should keep the data file and dashboard file separate, i.e. There will be a separate macro-based dashboard file which will have the option to i もっと
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. Best regards
Hi, Just went through the details you provided. I can work out on analysis and creating dashboard which will be user friendly enough that you can analyse data upon clicks. I am expert in excel and VBA programming and もっと
Dear I am an excel professional having hands on expertise in developing spreadsheet for analytical purpose I will do your project as per your requirements by applying advanced excel formulas with conditional formatti もっと
I finished a similar project using MS Access. Easy to deploy and easy to use. Very simple to link to excel fines and export to excel files too. We could made a Proof of concept if you want. Please, contact me and we wi もっと
We are an established Certified Public Accountants firm since 2008 based in India. We are a team of two CPA's & six Chartered Accountants. We currently offer services to overseas clients based in USA, Australia, Cana もっと
Hi, I've worked with Excel and VBA for 20 years for various different clients so I'm sure I can help you. I would normally look to have a written specification we can agree on before any code is written. It does not m もっと
Hey There! I have earned a preferred Freelancer badge and I can do your job since I have gone through your project requirements in details, I have 7+ years Experience in Data Entry, Excel, Responsive Website Desig もっと
