Find Jobs
Hire Freelancers

Operational Data Analysis in Excel

$30-250 AUD

Terminado
Publicado hace 5 meses

$30-250 AUD

Pagado a la entrega
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.
ID del proyecto: 37573973

Información sobre el proyecto

35 propuestas
Proyecto remoto
Activo hace 5 meses

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
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 en 7 días
5,0 (2 comentarios)
2,9
2,9
Avatar del usuario
$0 AUD en 2 días
5,0 (645 comentarios)
8,6
8,6
35 freelancers están ofertando un promedio de $141 AUD por este trabajo
Avatar del usuario
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 en 1 día
4,8 (245 comentarios)
7,3
7,3
Avatar del usuario
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 en 3 días
4,9 (133 comentarios)
6,7
6,7
Avatar del usuario
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 en 1 día
4,8 (164 comentarios)
6,3
6,3
Avatar del usuario
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 en 1 día
5,0 (52 comentarios)
5,8
5,8
Avatar del usuario
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 en 2 días
4,8 (148 comentarios)
5,8
5,8
Avatar del usuario
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 en 1 día
4,9 (75 comentarios)
5,2
5,2
Avatar del usuario
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 en 7 días
5,0 (2 comentarios)
3,1
3,1
Avatar del usuario
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 en 7 días
5,0 (1 comentario)
3,0
3,0
Avatar del usuario
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 en 7 días
4,4 (2 comentarios)
1,7
1,7
Avatar del usuario
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 en 7 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 7 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 7 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 7 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 7 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 2 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 7 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Skills data operator data processing network marketing digital marketing Facebook marketing YouTube video editor photo lab a mod App java script SEO
$140 AUD en 5 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 7 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 3 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de AUSTRALIA
Australia
0,0
0
Forma de pago verificada
Miembro desde may 28, 2015

Verificación del cliente

Otros trabajos de este cliente

Zencart export Customers to .csv
$10-30 AUD
¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.