General Trading Chat
- Thread starter timepass
- Start date
- Tags idle thoughts trading talk only
Tracer,
What you are saying is excellent. This is what I do to certain extent. But this is what I would want to be precise... May be you can help me.
What i do.
Eg As shown in image
I have bought 8800 CE @ 70 50
8600 PE @ 29.25 100
Now through link to excel at any point of time in fourth row I can see the total worth of my 1:2 ratio straddle at present. Here buy -128.5 points or -6425. Current position = 128.95 points or 6447.95. I can always know my profit loss of any position Straddle,strangle, debit spread and so on uptodate.
Now I would want a graph of my combined position of 128.95 points which though here is closely tied to vix but also is influenced by theta and other factors. So a graph of my combined position would be very handy. It will help in adding positions and I would know a support value of my combined position below which it doesnt go which need not be lowest value of vix for the day....
Can this data be streamed from my excel and a graph be drawn in amibroker of a combined position
Thanks and regards
What you are saying is excellent. This is what I do to certain extent. But this is what I would want to be precise... May be you can help me.
What i do.
Eg As shown in image
I have bought 8800 CE @ 70 50
8600 PE @ 29.25 100
Now through link to excel at any point of time in fourth row I can see the total worth of my 1:2 ratio straddle at present. Here buy -128.5 points or -6425. Current position = 128.95 points or 6447.95. I can always know my profit loss of any position Straddle,strangle, debit spread and so on uptodate.
Now I would want a graph of my combined position of 128.95 points which though here is closely tied to vix but also is influenced by theta and other factors. So a graph of my combined position would be very handy. It will help in adding positions and I would know a support value of my combined position below which it doesnt go which need not be lowest value of vix for the day....
Can this data be streamed from my excel and a graph be drawn in amibroker of a combined position
Thanks and regards
Just track number of points made/lost per lot ( or any similar way to normalize) so that you always see same type of numbers irrespective of your position size. He had problems if he see more amount in rupee
Charts - Excel has charts itself, so i guess you can do something there but i dont know how to do it.
Amibroker wont have your position details, so it probably wont work without some sort of coding.
Just like in josh utility you just read the stock updated numbers in excel and display graph in amibroker. Can the combined number generated by excel forumlae just be drawn as graph in amibroker.... Just thought you might now since you ve done an RTD utility. I guess you are reading data from now/nest and feeding it to an amibroker database. The plus here is that amibroker has its own database and every min data will be stored and graph generated.
Other approach I can do is draw graph from excel or I can read data from mysql populate in array and then draw graph using. http://phpchart.org/
The main question is how do I take data from now/and store it in my excel or database at real time
Other approach I can do is draw graph from excel or I can read data from mysql populate in array and then draw graph using. http://phpchart.org/
The main question is how do I take data from now/and store it in my excel or database at real time
Last edited:
Similar threads
-
My Views on the General Elections 2024
- Started by Verde
- Replies: 21
-
-
What are some general and basic price-volume action pattern one should know?
- Started by shyttrader
- Replies: 1
-
-