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.
25 freelancer bu iş için ortalamada 96$ teklif veriyor
Hi I have over 3 years expertize in these technologies.Completed several such projects in time successfully.I can definitely deliver what you need here.Let's start.Thanks.