Per the file attached with excel formulas, write the same mysql query that compare 3 consecutive records:
if price of record before lower than price of current record and if price of record after lower than price of current record,
then insert "high" in a separate field
if price of record before higher than price of current record and if price of record after higher than price of current record,
then insert "low" in a separate field
I can do exactly what you need. I'm a computer science professional with a PhD degree and extensive experience in excel formulas and mysql. I've done a lot of similar work. Please see reviews on my profile. It would be my pleasure to complete your project.
Just FYI, I own a small engineering consulting business registered in the state of Illinois. You could pay me as an individual freelancer or as a business, whichever suits you better.
Please have a look at some Excel projects I've done:
https://www.freelancer.com.au/projects/Excel/Calculate-the-semi-deviation-each/
https://www.freelancer.com.au/projects/Excel/Recreate-online-calculator-using-Excel/
https://www.freelancer.com/projects/Excel/Build-Excel-reports-dashboard/
https://www.freelancer.com/jobs/php/Need-excel-plugin-convert-USD/
https://www.freelancer.com/jobs/Excel/Need-covert-very-large-dat/
$25 USD en 0 día
4,8 (165 comentarios)
6,9
6,9
20 freelancers están ofertando un promedio de $28 USD por este trabajo
It will be completed ASAP. Is there any webpage that will be used to perform this operation? Kindly clarify and I will start it right away. I have understood the formula in excel perfectly and I have no question just need clarification for above question.
Hi,
I know how to write a query for this project. It will compare the current price with price of before and after rows and insert "high" or "low" in a separate field.
Regards,
Khanh Doan
Greetings!
My name is Aditya.
I just went through your project. I see that you want to convert an excel formula into a mysql query and use it update the record.
We can discuss more details about the project once you drop me a message.
Waiting for your positive feedback.
Best Regards,
Aditya
Hello, I have experience in writing custom MySQL scripts. Let me know if you have any questions. You can also visit my profile to see my ratings and comments from previous works. Thanks!
I have done similar projects & confident to assist you on this project. Job will be completed accurately within the time limit. You can trust my work and award to start from now. Thanks