Create Dashboards for stock market data using excel

$50-70 USD

Completed

Posted

5 months ago

$50-70 USD

Paid on delivery

I want 3 dashboards for stock market data using Excel. The file i have has those columns: symbol, name, trading_name, sectoer, date, open, high, low, close, change, perc_Change , volume_traded value_traded, no_trades . Dashboard 1: Historical Market Performance Dashboard: Objective: Understand how the market has performed over time. Components: Line Chart for Stock Prices: Plot the historical open, high, low, and close prices over time for selected symbols. This can give a quick overview of trends and volatility. Bar Chart for Volume Traded: Display the volume traded for each symbol over time. Use color-coded bars to represent different symbols and easily identify trading activity. Candlestick Chart: Display candlestick charts for a selected time period to visualize the daily price movements, including open, high, low, and close. This helps in identifying patterns and trends. Performance Metrics: Show key performance metrics like average change, average percentage change, and total value traded for selected symbols. Dashboard 2: Sector Analysis Dashboard: Objective: Analyze the performance of different sectors in the market. Components: Pie Chart for Sector Distribution: Display the distribution of symbols across different sectors. This helps in understanding the composition of the market. Bar Chart for Average Percentage Change: Compare the average percentage change for symbols within each sector. Identify sectors with the highest and lowest average performance. Heatmap for Correlation: Create a heatmap to visualize the correlation between symbols within each sector. This helps in understanding how stocks within the same sector move in relation to each other. Bubble Chart for Value Traded: Represent each sector with a bubble, where the size of the bubble corresponds to the total value traded in that sector. This provides insights into the economic importance of different sectors. The ideal candidate should have experience in working with stock market data and creating visually appealing and user-friendly dashboards. Skills and experience required: - Expertise in working with stock market data and Excel - Strong knowledge of data visualization techniques - Ability to design and create visually appealing dashboards - Experience in working with real-time data updates The dashboards need to be delivered in less than 20 hours from accepting the job.

Project ID: 37544473

About the project

21 proposals

Remote project

Active 5 mos ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@Akib2020

$0 USD in 3 days

4.9

(120 reviews)

7.0

21 freelancers are bidding on average $73 USD for this job

@arslanu2

Hi! We are a professional business solutions firm having seven years long experience serving clients across the globe. We provide high-level Management Consulting, Business Management, Business Development, Business Analytics, Business Consulting, Business Strategy, Business Requirement Documentation, Business Writing, Financial Analysis, Financial Modelling, and Accounting services. We serve businesses with core competencies in these areas while focussing on the latest business trends. Let's discuss the scope of your project to Move Further. Regards McKenzie Business Solutions Lahore, Pakistan

$70 USD in 7 days

4.8

(21 reviews)

5.4

@obadiakipkemoi

Hello there, I will help with project on Create Dashboards for stock market data using excel .I have read the instructions carefully and I clearly understand what is required of the project. I have handled several assignments on this field and I will be glad to offer my expertise and on this one too. With me, the quality and the deadline of your paper are my utmost priority. I have expertise needed to complete your project as i have skills in Data Processing, Excel, Statistical Analysis, Visual Basic and Business Analysis. Feel free to contact me for more details.

$55 USD in 2 days

4.9

(28 reviews)

5.4

@azizva

Hello, my name is Aziz and I'm a versatile professional with extensive experience in working with stock market data and creating visually appealing and user-friendly dashboards. As someone who excels at data visualization techniques, I am well equipped to create the right kind of dashboards for your project. Specifically, I have expertise in working with stock market data and Excel; strong knowledge of data visualization techniques; ability to design and create visually appealing dashboards; and experience in working with real-time data updates. I believe that my skillset makes me an ideal candidate for this project. With my background in business analysis, data processing, Excel statistics, machine learning (ML), digital marketing, and more, I am confident that I can provide comprehensive analytical solutions and strategic digital marketing approaches that will contribute significantly to your organization's growth and success.

$60 USD in 1 day

4.9

(68 reviews)

5.5

@Maherun75

"""Dear employer, I read your requirement to Create Dashboards for stock market data using excel "". I am an expert in this field. That's why I placed my bid on this project. I'm a professional data entry, web scraping, data analysis, excel VBA macro, and BI Developer and I can start your work immediately right now. I will be available for any query round the clock even if the project is completed. Please award me this project so that we can discuss it more. Hope I will get a chance to work with you. Thanks and Regards, Trusted Hand Service (Bring The World Nearst To You)"""

$60 USD in 1 day

4.6

(25 reviews)

4.6

@professorxwriter

Hello! My name is Muhammad and I am an experienced Business Analysis specialist. I understand from your description of the project that you are looking for three dashboards for stock market data using Excel that will provide historical market performance data, sector analysis data and performance metrics for sector analysis data. I believe I am the perfect person for this job due to my expertise in working with stock market data and creating visually appealing and user-friendly dashboards. My skillset includes strong knowledge of data visualization techniques which will be required to produce the desired dashboards quickly. Additionally, I am experienced in working with real-time data updates which is important for this project as you need them to be delivered within 20 hours from accepting the job.

$160 USD in 1 day

4.7

(11 reviews)

4.3

@saim2105

Hello there! Thank you for considering me for this project. I am confident that my skillset and experience make me the perfect fit for your project. I understand how important it is to deliver quality results quickly, so I will work hard to complete your project within 20 hours of accepting it. I have extensive experience in working with stock market data and creating visually appealing and user-friendly dashboards. My expertise lies in data visualization techniques such as line charts, bar charts, candlestick charts and more. This makes it easy for users to understand historical market performance over time as well as analyze sector performance. I am also experienced in delivering successful projects on time and within budget. If you would like me to discuss further please feel free to get in touch. Thank you again for considering me for this job!

$60 USD in 1 day

4.7

(5 reviews)

3.0

@farahgul2004

Hello, I am Farah and I am here to offer my services as the best fit for your project. With 6 years of experience operating as a high-end professional in the Design and Branding Industry, I have the skills necessary to help you create the perfect dashboards for your stock market data needs. Specifically, I have experience in working with stock market data and creating visually appealing and user-friendly dashboards. Additionally, I have experience in working with real-time data updates which makes it easy for me to deliver the dashboards within the given timeframe of less than 20 hours. Additionally, I offer a range of services through my expertise including (but not limited to): ? Copywriting ? Translation ? Data Processing ? Data Entry ? Excel ? Powerpoint ? Editing ? PDF ? Typing ? English Translation

$60 USD in 1 day

5.0

(1 review)

2.3

@Itsolution00

Hello, I hope this message finds you well. Our team brings a diverse skill set to enhance your project's success. **Services Offered:** 1. **Excel Expertise:** Advanced proficiency for data manipulation, analysis, and reporting. 2. **VBA (Visual Basic for Applications):** Streamlining Excel processes through automation. 3. **PDF Management:** Expertise in extraction, conversion, and formatting. 4. **Data Entry Accuracy:** Precise and efficient data entry services. 5. **Data Analysis:** Uncovering trends, patterns, and insights beyond Excel. 6. **Dashboard Creation:** Transforming raw data into visually appealing, interactive dashboards. 7. **Microsoft Access and Word Proficiency:** Database management and professional document creation. We are eager to contribute to your project's success. For further discussion or specific requirements, please feel free to reach out. Thank you for considering our proposal. We look forward to the possibility of working together. Best regards, IT SOLUTION TEAM

$70 USD in 1 day

5.0

(1 review)

2.0

@iqraahmad22

Hi there! My name is Iqra and I am a data processing, Excel specialist. I understand that you are looking for someone to create three dashboards using Excel that display market performance over time, sector analysis information, and performance metrics for selected symbols. I believe that I have the skills required to complete this project efficiently and successfully. My experience in data management and entry makes me an ideal candidate for this job as I have a strong work ethic and meticulous attention to detail. Additionally, I have pursued a Master's degree in Information and Technology with specializations in WordPress, PHP, CSS3, HTML5, C++ Programming XAMPP MySQL Database Javascript HTML DSA Bootstrap. I am available now to discuss how we can complete this project together. Please don't hesitate to contact me if you have any questions or would like more information about me or my skillset. Best Regards, Iqra Ahmad.

$50 USD in 1 day

4.2

(8 reviews)

2.4

@mcuaconline

Hello Client, I am writing to bid on your project to create three dynamic dashboards for stock market data using Excel. Leveraging my proficiency in data analysis and visualization, I will transform your provided dataset with columns including symbol, name, trading_name, sector, date, open, high, low, close, change, perc_Change, volume_traded, value_traded, and no_trades into insightful visual representations. My experience in designing Excel dashboards, coupled with a keen understanding of stock market metrics, ensures that the dashboards will be both informative and user-friendly. I am eager to bring your stock market data to life visually and provide you with valuable insights. I just completed a similar project for a client, with 4 dashboards, I will be glad to share the sample of the work with you on the chat. Looking forward to working with you in making this project true. Kind regards, Kenneth

$60 USD in 2 days

5.0

(2 reviews)

1.5

@somakdarina83

I am extensive experience in creating user-centric applications and solutions. Visual Basic, Business Analysis, Excel, Data Processing and Statistical Analysis - Proficiency in front-end technologies such as HTML, CSS, and JavaScript - Strong knowledge of back-end technologies including Java, Ruby, and Python - Experience with popular frameworks like React, AngularJS, and Node.js - Familiarity with database technologies such as MongoDB, Oracle, and MySQL. Successfully designed and delivered numerous web applications, ensuring optimal functionality, quality, and reliability. Collaborated closely with cross-functional teams to develop and implement full-stack solutions . Ability to adapt to new technologies and stay updated with the latest developments in web application technology. Experience working in agile development environments, ensuring efficient project management and timely delivery. I am confident that my technical knowledge, problem-solving abilities, and dedication to delivering high-quality solutions make me a strong fit for the Full Stack Developer role at your company. I look forward to the opportunity to discuss how my qualifications align with your requirements in more detail.

$155 USD in 2 days

0.0

(0 reviews)

0.0

@alirafay700

Hi there! My name is Rafay and I am a graphic designer specializing in data processing and Excel. I have extensive experience in creating visually appealing dashboards that are user-friendly and maintain accurate real-time data updates. I am confident that my skillset makes me the ideal candidate for this project. I understand how important it is to create accurate market performance dashboards that provide insights into sector performance and economic importance. This is why I would be willing to work hard to deliver the desired result within the given timeframe - less than 20 hours from accepting the job.

$60 USD in 3 days

0.0

(0 reviews)

0.0

@alinaverstuk1

Dear, Osama A. I have rich experiences with skills including Visual Basic, Excel, Statistical Analysis, Data Processing and Business Analysis, specially I've worked with other client in similar project and I can work on your time zone. I'd like you to discuss the requirements in more detail through chat and start right now. Regards, Alina.

$90 USD in 2 days

0.0

(0 reviews)

0.0

@sairusk

Create Dashboards for stock market data using excel Hi Osama A. I am Sairus Khalil, an accomplished Python expert with a wealth of experience in a variety of Python-related domains, including data scraping, chatbot development, and more. I am eager to seize the opportunity to collaborate on your project and deliver top-tier Python development services tailored to your precise requirements. What I Offer: 1. Data Scraping Expertise: I possess advanced skills in web scraping and data extraction using Python. Whether you need data from websites, APIs, or other sources, I can efficiently gather and organize it to meet your data-driven needs. 2. Chatbot Development: If you require chatbot functionality, I can design and implement conversational interfaces using Python, enhancing user engagement and automating customer interactions. 3. Robust and Efficient Code: I specialize in crafting reliable, high-performance Python code that aligns with your project's objectives, ensuring that your software functions smoothly and efficiently. 4. Rapid Development: My proficiency in Python enables me to work swiftly without compromising code quality, guaranteeing timely project delivery. 5. Custom Solutions: Your project's unique requirements are at the forefront of my approach. I will tailor solutions to precisely meet your specifications, ensuring seamless alignment with your goals. 6. Collaboration and Adaptability: I am open to collaboration, eager to integrate your feedback, and adaptable to changes, guaranteeing that the final product surpasses your expectations. Whether you need data scraping, chatbot development, web applications, automation solutions, or any other Python-related service, I am dedicated to delivering results that not only meet but exceed your expectations. Let's embark on a discussion to explore how I can help you achieve your objectives through Python-powered solutions. Excel, Statistical Analysis, Business Analysis, Data Processing and Visual Basic

$50 USD in 7 days

0.0

(0 reviews)

0.0

@SvenVolger0903

❤️Hi Dear ⭐⭐⭐======I can provide the sample!=====⭐⭐⭐ I am excited to submit my proposal for your project. I have developed a strong set of skills that make me confident in my ability to deliver high-quality work to your project. My approach to any project is to first gain a deep understanding of the client's needs and requirements. I will work closely with you to ensure that I understand your project goals and objectives, and that I am able to deliver results that meet or exceed your expectations. In terms of technical skills, I have extensive experience. I'm able to work independently, be detail-oriented, have strong problem-solving ability and excellent communication skills. Overall, I am confident that I can provide the best result beyond your requirements, and help you achieve your project goals. Looking forward to working with you. Thank you.

$70 USD in 1 day

0.0

(0 reviews)

0.0

@SudhaS4

Im very good at preparing dashboard using excel. Please refer my Profile Pic so that you will get the item of the dashboard which i have prepared. It is very useful and reduce the time in data analysis. I will be the perfect choose for your project. If given a chance i can prove in this platform and i will get more orders Thanks

$70 USD in 6 days

0.0

(0 reviews)

0.0

@MohamedAli131093

Hello there! I am Mohamed and I am excited to tell you about my skills and experience. As a data analyst and data entry experienced in sales data, inventory data and HR data, I can help you create the 3 dashboards you are looking for. I have extensive experience working with stock market data and Excel. My expertise includes data visualization techniques such as line charts, bar charts and candlestick charts which can be used to create an effective dashboard. Additionally I have experience in working with real-time data updates which would be required for delivering the dashboards within the deadline. I believe that my skillset makes me the perfect fit for this project. If you give me the chance to work on this project please let me know as soon as possible so we can get started on this exciting project!

$50 USD in 1 day

0.0

(0 reviews)

0.0

@leelabolgan

Hi I have gone through your requirement. I am well experienced in creating visually appealing dashboards in the excel sheets. Also worked on creating presentations on the insights derived from the dashboards. I have good knowledge on stock market data and I had worked on stock market data to predict the stock movement using forecasting techniques. I feel with good experience in excel dashboards combined with stock market working knowledge will make me right fit for this opportunity. Looking forward to hear from you soon! Thanks

$60 USD in 1 day