Objective = connect to mysql and pull selected data from database tables in real time.
• Ability to connect to mysql database from excel itself.
• Ability to set datbase connection values from excel and ability to connect remote mysql server settings.
• Ability to load the data from db.
• Ability to keep last row constant and update latest record on last row.
§ Example = if I select to pull last 100 rows of data then in excel row 100 will be fixed, and new data will be inserted on row 100 and row 1 record will be removed. So total data row always will be 100.
• Ability to select which symbol, time frame, # of records to pull from database.
• Ability to load multiple symbols data by more than 1 sheet.
§ [url removed, login to view] would have 3 sheets each with its own table from database.
• Ability to save settings in excel sheets.
• Ability to refresh all data when saved excel sheet is opened.
• Prefer to have excel add-on setup.
That’s all the functions we need in it.
Bu iş için 25 freelancer ortalamada $96 teklif veriyor
Already done excel to/from mysql as a part of a big project. Please see your PMB. Thanks.
Exceptional quality & Quick work. Please refer to Profile & Reviews for details of quality of work. Thanks FAZ
Hello I have done same time work in excel and sql server. can we discuss regarding this project. Thanks Biswajit
Hi I have over 3 years expertize in these [login to view URL] several such projects in time successfully.I can definitely deliver what you need [login to view URL]'s start.Thanks.
Hi, Greetings!!! Thank you very much for giving us an opportunity to bid this project. We have gone through your project requirements and would like to offer our candidature to take up this project. We are we Daha Fazla
I have over 6+ years of experience in the financial markets(US). I have experience in creating financial models. I was working for Hedge Fund. Please go through the link for more details [login to view URL] Daha Fazla
Previously I did this type of project. Please give me the project ASPS.
Hi, I have strong Excel and Excel VBA experience. Please check the PM. Thanks, Marius
Hi there, As a database developer and specialist in open source software I am adamend to deliver you the solution asap because I did a lot of type of this project in the past connecting mysql database to differebt thi Daha Fazla
Greetings! We are a team of IT professionals providing quality services. We have Web Developer working for 6 years in this field. we are interested in your project posted. please check mail box for more information. Th Daha Fazla