Find Jobs
Hire Freelancers

Operational Data Analysis in Excel

$30-250 AUD

Completed
Posted 5 months ago

$30-250 AUD

Paid on delivery
Changes to existing spreadsheet for Market Data analysis. More work available. Full brief as attached. Hourly High Lows: Calculated from the ‘NY Open’ price utilising the times set out in the ‘Trading Hours’ sheet ie. 8-9am etc… Negative numbers should be rounded to zero or blank. Conditional formatting should be applied if number is above or below the ‘Upper or Lower Bracket’. Daylight Savings Offset: Tines are set out in the sheet ‘Trading_Hours’, I need a way for the ‘Data’ sheet to automatically adjust times to allow for day light saving times in various time zones. As the data contracts span multiple time zone adjustments ie. FDXM Dec 23 contract runs 15/9 – 15/12 and has a time change for Europe on 29/10 and another for NY on 12/11. This mainly impacts the ‘NY Filtering: The ‘Main’ sheet is used for filtering the ‘Data’ sheet. I need a way to input variables for various columns to filter. The filtered output can be placed into the main sheet or simply filtered on the data sheet.
Project ID: 37573973

About the project

35 proposals
Remote project
Active 5 mos ago

Looking to make some money?

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:
User Avatar
Hi there! I've been working with Excel and Power BI for a long time. For the past ten years, I've been at a Financial Institution, creating complicated reports in Excel. I think my experience aligns well with what you need. Additionally, I have other methods to handle this kind of data, and I can talk about them when we discuss further.
$140 AUD in 7 days
5.0 (2 reviews)
2.9
2.9
User Avatar
$0 AUD in 2 days
5.0 (645 reviews)
8.6
8.6
35 freelancers are bidding on average $141 AUD for this job
User Avatar
Hi, Excel expert here. I can perfectly assist you with this and can start on an immediate basis. I am an experienced Excel professional with years of experience in all the tools of Excel including Visual Basic, Automation, Data Analysis, Complex Formulas, Calculations, Analysis, Financial Modeling etc. To make your hiring decision easier, I can share the limited version quickly before you hire and then you can decide if this fulfills your needs or not. Lets discuss more in detail about my previous similar experience and how I am highly suitable for this project.
$40 AUD in 1 day
4.8 (245 reviews)
7.3
7.3
User Avatar
Hello, I'm interested in your project. Your task is clear to me and I am ready to solve it. I have extensive and successful practical experience in processing and analyzing data in Excel, including using formulas and macros.
$175 AUD in 3 days
4.9 (133 reviews)
6.7
6.7
User Avatar
Hi There, Ready right now I'm ready to Changes to existing spreadsheet for Market Data analysis. I will show you sample for your satisfaction and project accuracy then we will go to start, so please contact me and share more details thanks. Check My Profile: https://www.freelancer.pk/u/WelcomeClient I would like to work on this project and can complete with 100% accuracy within the time frame. https://www.freelancer.pk/projects/excel/business-profit-loss-reporting-excel/reviews https://www.freelancer.pk/projects/data-entry/copy-listings-from-website-another/reviews Thanks, Umer
$80 AUD in 1 day
4.8 (164 reviews)
6.3
6.3
User Avatar
Hi Hope you are doing good, I can perfectly help you with that in quick turnaround. I am a professional Excel expert holding 7 years of experience in utilizing advance level tools, creating dynamic dashboards and Excel (including VBA and Macro) to perform Data Analysis, Data Visualization, Automation and complex calculations. I will be happy to discuss in detail how I am highly suitable for this project. Kind Regards Arun
$100 AUD in 1 day
5.0 (52 reviews)
5.8
5.8
User Avatar
Excel expert. I can do it. As 9+ years experiences in these field. I can give good quality work. I have read the guidelines of your work.I believe that i can provide you the best quality works you are anticipating from this platform give me a chance to show you the best i can do at your service.
$180 AUD in 2 days
4.8 (148 reviews)
5.8
5.8
User Avatar
Hello, I am an experienced spreadsheet analyst and am eager to assist with the requested changes to your existing market data analysis spreadsheet. After reviewing the detailed brief attached, I am confident in my ability to implement the necessary modifications efficiently. Specifically, I will calculate hourly high-lows, incorporate daylight savings offsets based on the provided trading hours, and enable dynamic filtering options for enhanced analysis. My proficiency in spreadsheet manipulation, attention to detail, and commitment to delivering high-quality work make me an ideal candidate for this task. I look forward to discussing any additional details and requirements to ensure the successful completion of this project, with the possibility of undertaking further work as needed. Regards, Zafar
$30 AUD in 1 day
4.9 (75 reviews)
5.2
5.2
User Avatar
I understand you are looking for someone to help you with an existing spreadsheet for market data analysis and changes to the spreadsheet required. With my skills in data processing, Excel and other relevant technologies such as Python, R, SQL and SAS, I can provide the necessary solutions to enhance your data analysis capabilities and build customized solutions precisely tailored to your needs. I have extensive experience in data visualization tools such as Tableau and Power BI which can be used to create stunning visuals from your data. Plus, my skillset includes data cleaning and preprocessing tools such as Pandas and NumPy which can be used to make sure your data is error-free before plotting it on the canvas. Finally, I am well-versed in machine learning frameworks such as Scikit-learn which can be used for data analysis and statistics as well as for data extraction and web scraping. This will allow me to automatically adjust times for your data so that it takes into account day light saving times in various time zones without any manual intervention required from you.
$140 AUD in 7 days
5.0 (2 reviews)
3.1
3.1
User Avatar
I understand that you are looking for someone to help you analyze the market data in Excel and make necessary changes to existing spreadsheet. I am qualified for python, web scraping, bot development and machine learning. I have experience at data science and machine learning. Additionally, i have my own website where you can find some of my projects. I would be delighted to work on this project with you. I have the skills necessary to carry out your needs in an efficient and timely manner. My expertise includes data processing, Excel which will be necessary for making the necessary changes to your existing spreadsheet. Also, as part of the project i would like to include filtering functionality so that the filtered output can be placed into the main sheet or simply filtered on the data sheet as needed. I look forward to hearing from you soon! Please feel free to contact me if you have any questions or would like additional information about me or my skillset.
$150 AUD in 7 days
5.0 (1 review)
3.0
3.0
User Avatar
G'day Solution: I am experienced in data analysis and Excel, and I am confident that I can provide an effective solution for this project. I can make changes to the existing spreadsheet, including adding new fields and formulas that would allow for market data analysis. Additionally, I would be able to calculate hourly high and low pricing, based on the ‘ny open’ price and the set times in the ‘trading hours’ sheet. I can ensure that any negative numbers are rounded to zero or excluded from the analysis. Furthermore, I am available to provide ongoing hourly work for this project, should that be necessary. I look forward to discussing the details of this project further. Best regards, Giáp Văn Hưng
$126 AUD in 7 days
4.4 (2 reviews)
1.7
1.7
User Avatar
As a highly skilled Excel VBA/Macro developer, I can help you perfectly. I am very confident with my skills and I'd like to help your business by doing my best. My clients have never been frustrated with my work and I hope to make you one of them. Please confirm that I am one of the best fits for you and drop me a message for further discussion. Thanks and Best Regards.
$250 AUD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, my name is Ricky Chen and I am a dedicated and results-driven professional with 4 years of experience in the field of sales and marketing. I have a strong background in data processing and excel at designing comprehensive marketing campaigns that effectively communicate the value proposition of products or services. I have the necessary expertise to help you with your project of operational data analysis in Excel. Specifically, I understand how changes to existing spreadsheets can sometimes be necessary for Market Data analysis, especially when working across multiple time zones with large contracts spanning across weekdays. I am confident that my skillset of data processing, end-to-end sales cycle management, data analysis & analytics as well as digital marketing will be a great asset to your team for this project. Please let me know if you would like me to discuss further or answer any additional questions you may have!
$140 AUD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi there! My name is Ramachandran and I am a Full-Stack web developer with over 10 years of experience. I specialize in creating dynamic and interactive websites and web applications. From designing captivating user interfaces to implementing robust back-end functionalities, I'm confident that I have the necessary skills to help you with your project. I understand that you are looking for someone to analyze changes to an existing spreadsheet for Market Data analysis. More work available. With my experience in Excel and other related tools such as SQL, I am able to provide the necessary tools needed to undertake this project effectively. I would be delighted to discuss this project further with you and look forward to embarking on this exciting journey together!
$140 AUD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I will do my best to get all the requirements done within 7 days. I am new to freelancer so I am willing to offer my service for less than others.
$80 AUD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hola soy nuevo en la plataforma, sin embargo puedo ayudarte ya que cuento con amplios conocimientos de Excel avanzado y análisis de datos
$140 AUD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Dear client. I understand you are looking for someone to help you with your project of Operational Data Analysis in Excel. With my experience in Data Processing and Excel, I am confident that I can provide the best solution for your needs. As part of the project, I would like to install conditional formatting on any number above or below a certain threshold so that it can be easily viewed. Additionally, I can utilize time zone changes to adjust the times on the data sheet so that it can accommodate for day light saving times in various time zones. This will ensure accurate and timely analysis of market data no matter where you are located. If you choose me for this project, you can rest assured that you will get top quality service at all times.
$111 AUD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Boasting over a decade of hands-on experience, I am adept in Microsoft Office tools, guaranteeing streamlined workflows, optimal presentations, and enhanced organizational efficiency.
$100 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I have been working in field of data processing for last 2 years and i also have experience in data mining and data analysis and spreadsheet. I am excited to working with you and i guess i will be one of the best candidate for this job.
$50 AUD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Skills data operator data processing network marketing digital marketing Facebook marketing YouTube video editor photo lab a mod App java script SEO
$140 AUD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, Excel expert here. I can perfectly assist you with this and can start on an immediate basis. I am an experienced Excel professional with years of experience in all the tools of Excel including Visual Basic, Automation, Data Analysis, Complex Formulas, Calculations, Analysis, Financial Modeling etc. To make your hiring decision easier, I can share the limited version quickly before you hire and then you can decide if this fulfills your needs or not. Lets discuss more in detail about my previous similar experience and how I am highly suitable for this project.
$140 AUD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Having with 9 years of experience i will be proved best candidate for your organisation to complete your task with accuracy and fast delivery. Thanks
$59 AUD in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of AUSTRALIA
Australia
0.0
0
Payment method verified
Member since May 28, 2015

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.