convert my excel file into Ninjatrader window with IBKR datas IB TWS API

Hi

I need to put my excel file into a new ninjtrader file.

Excel file as is now is quite simple.

Some are manual cell, some are with calculations already IN

Underlined are manual

A

Simbol

B

Date of opening trade

C

Premium

D

Number of contract

E

Strike price

F

Margin

G

Principal

H

Days till expiration at opening date

I

CE formula

J

Return on margin

K

Return on principal

L to Q

100p to 50p

R

Close date of trade

S

Days in trade

T

Close price

U

Full gain

V

Return on margin at close

W

Return on principal at close

X

Profit

Y-Z

Panel of 100p to 50p

Z12

Full gain summ

Z14

Averange of Return of principal at close (W)

--

I need to put all these, into ninjtrader window.

On top, we will put the Y-Z, panel of 100p to 50p

Togheter with IBKR account datas “dashboard”, like “cash” (very important)

The panel will have same functions like excel, with some changes if possible.

Each line can be “selected”, if selected, they will be calculated into 100p and 50p part.

This because before open a position, I normally enter datas to see which one is better , related to ROP or CE formula.

Into first cells, we can include a selector of option, some IBKR,

so system will automatically calculate “days till expiration” cell H, compared to B, date of opening trade.

About “closing” infos, cells.

I wish to include extra row, in case I open 2 positions and I close just 1 in one day, and second position in another day.

We can delete colum X

Into dashboard, just one setting is needed, “date format” , select if DD-MM-YYYY or american MM-DD-YYYY

---

please note: later I need this as ninjtrader8 add-on,

that can be enabled using a code, one per machine.

like I give it to my own clients

C＃プログラミング ソフトウェアアーキテクチャ

プロジェクトID: #29052670

プロジェクトについて