Hello @cisola,

We strive to help, by guiding developers and developer community toward coding, owning and maintaining robust solutions.

The examples that we provide to the community are simple, well-documented, and widely applicable.

We do not code custom use cases to requirements, rather we are willing to help in advisory capacity for you take responsibility for coding and maintaining.

But whenever possible, we try to find a way to help.

Your use case is not simple, as you require:

1. To react to any change in price
2. Validate all inputs and create a valid REDI order
3. Submit order to REDI
4. Update the worksheet with the result of the latest submission request, whether valid or not

In my understanding, the use case is just complex enough, that there are several ways to approach it. I have coded, as an example, within the code you have included, a version of what I believe your require.

The cornerstones of my approach are:

• User Defined Function SENDORDERS that is in Module 6 and reacts to changes and submits orders.
• public variables changeFlag cellToChange and ValueToSet that signal the change out of UDF and allow Status cells to be updated with the results
• Sub Workbook_SheetCalculate on sheet itself, that updates the status on the sheet

It is very likely that this is not all that you require, or not exactly as you envision, or you would prefer a different approach.

In this case, I hope that the example that you will find attached, will help guide you toward fully implementing to your requirements, next.

-Zoya

Hi @cisola,

To confirm, does your sheet have a column/cell that says "Trade Now" or "True/False" or anything like that?

-Brian

Hi @cisola,

We'd like to suggest, defining a User Defined Function in Excel

that will verify all the required cells are populated, with the valid values, and trigger as you require.

Hi @cisola

Not sure if what I am about to answer is what you are looking for :)

But will try to answer straight-on.

Developer-> View Code
Insert->Module

Type something like:

Function ORDERCOND(Ready) 
  If Ready = "Yes" Then 
    'Copy code from our order example for example 
     Dim hOrder As New OPTIONORDER 
     hOrder.Side = "Buy" 
     hOrder.symbol = "SBUX" 
     hOrder.Type = "Call" 
     hOrder.Date = "Apr '16" 
     '.... 
     b = hOrder.Submit(myerr) 
  End If 
End Function

And save.

When you type "=ORDERCOND" into one of your cells, enter the location of "Trade now" cell, such as

=ORDERCOND(B9)

If you are looking to validate more parameters, before creating the order, just use the same approach, increase the number of parameters into ORDERCOND and run the checks.