Forum Discussion
optimize data
Thanks for replying and giving me some input on what is required.
I'll upload three files that hopefully help. One will be the raw option data that has the variables I'm looking to optimize and when I say optimize I mean maximize the gains made by using the best of the variables I mentioned.
ZZZ_Underlying is the raw data we bought
The Fields Choice file shows which columns we need to keep
Manual_run is one of many samples we've run manually sorting through the raw data.
Hope this helps
Sorry, but this is still very broad.
Do you have a question about how to use a formula or how to arrive at a result?
If you can explain the logic, then we can help you make it work, but you can't just ask us to write a profit maximisation system. There are some very complex processes and algorithms involved and this is a major project.
Break it down into smaller units and tackle one issue at a time. Please post your question into the discussion here, so people can understand what you want without having to open several workbooks. Attach files with a few rows of data only to illustrate the principle, not to have us write the final solution.