Code a semivariance formula in VBA and record an asset return simulation macro, or code it in VBA. Also include a "simulation" button in the interface to make the simulation happen, and make it interactive with a chart.
Hi There, I need a VBA written that will build a relationship table based on string searches. The search will have names in the format Smith J, if it matches with Smith JR i will need the relationship made and a flag highlighted. There will be wildcards used within the lookup. Each tab can have 1 or 1000+ names to search. There is a main
Objective: We are looking to get an Excel Macro built that will take our shopify export file and clean the data up where we can work with the data into other product catalogs. Scope of Work: We need this to be coded in VBA for Excel 2016 and when we open the workbook it will do the following: 1. Browse for the CSV or workbook to transform 2. Run
Hi guys, I have attached one excel file includes two tabs. About the first tab -> these tables represents two different items. Sales price (A2) is the first item sales price we sell. Then in the first table, it shows the vendors that we can source the first item. Same story for the second table. I want it to create me all the combinations of the
Hi, I need an Excel VBA guru to take the following columns as inputs and conduct web data scraping. Inputs in Excel: - Company Name - Location (e.g. NSW) VBA Process & Outputs in Excel: Google Search: 1. Google Search the Company Name 2. Extract information from First Search result (Header, URL, Description) 3. Copy Each into a separate
Currently my bot don't have good UI Chart function. So I am going to add the Chart features. Of course, I will provide the open source. You have to customize it a little. I think if you are a BTC expert, then you can finish this project within 1 day. Please bid only EXPERT. Others will be reject. Thanks and regards
Hi freelancers, in the attached file I want a VBA code to do the following: Check all cells from W37 to the "last row" in the sheet. If any cell in that range contain date less than 1-1-2018 , the next two cells in the same row must be protected. For example cell W40 in the attachment has the date 22-Sep-2017, then cells Y40 and AA40 must has the format
A visualisation chart has to be created with the tibco spotfire
Retrieve Market Capitalization and Volume values from Total Market Capitalization chart, that can be found here: [url removed, login to view] Data must be spaced out by five minute intervals. (as it is from 1 day charts) Deliver data in XLS format. "Date", "Time", "Market cap" and "Volume" must be organized separated columns. Period to
Hi I have a wind chart on my site using chartsJS, the problem is its not responsive. I purchased the licence for highcharts and want the data moved over to that.
Refer to attached zip file. The [url removed, login to view] file links to 2 Excel files, 1 Access file and 1 SQL Server database. The SQL database can be restored from the [url removed, login to view] file, then linked using ODBC, DSN name = 'Calendar' The [url removed, login to view] file has a local table (called 'Connection') which can be used to determine the pat...
Two coding scripts 1) rearranged 2) put together the two scripts are already written and are giving out graphs they should be together and give out one graph detailing things nicely. that is giving out something much more creative like a graph with good lables . the two codes are Euler and runga kutta method they are separate from one another but all solve the same function Euler's method...
see the files that i upload and follow it to do