Excel Busn Math 44: Series Trade Discounts

I have a question but I don't know if this is possible. I have two series on a scatter plot:

Code:

X        Y1     Y2
5:15     3       2
5:16     4       6
5:17     8       2
5:18     1       1
5:19     3       7

Is it possible to have Excel -- perhaps deep within VBA -- to perform an operation on the two series to create a third series in which Y1 + Y2 = Y3 and Y3 (5, 10, 10, 2, 10) placed as a new series on the chart? I am wondering if this is possible to do without actually performing the math in a separate column in the worksheet and then charting that new column.

Thanks for any thoughts,

Greetings! Hope someone can help.

Formula or VBA welcome.

See attachment.

I want to calculate the P/L (profit and loss) of each trade. This can easily be accomplished by calculating the difference of the "NET Amt". But each trade has it's own "Trade #"; this serves to 'group' the trade together.

Each of the trades can have multiple B(uys) and S(ells). In addition besides Long(L) trades there are Short(T) trades.

Ideally, the P/L amount should appear at the most bottom row?

Your very welcome to make suggestions as to the overall of the worksheet.
I want to maintain the "row" type appearance.


Sample data:
TRADE # L/T B/S Ticker Shares Price Gross Amt SEC COMM SETL NETAmt P/L 110324NEWCA1 L B NCT 1,000 6.00000 -6,000.00 0.00 10.00 -6,010.00
110324NEWCA1 L B NCT 5,000 6.00000 -30,000.00 0.00 10.00 -30,010.00
110324NEWCA1 L S NCT 6,000 6.04000 36,240.00 0.70 30.00 10.00 36,200.00
110324HYPER1 L B HDY 5,100 6.28560 -32,056.56 25.50 10.00 -32,092.06
110324HYPER1 L S HDY 5,100 6.34570 32,363.07 0.62 25.50 10.00 32,326.95
110324GULFP1 T S GPOR 3,000 32.61900 97,857.00 1.88 15.00 10.00 97,830.12
110324GULFP1 T B GPOR 3,000 32.59520 -97,785.60 15.00 10.00 -97,810.60

NOTE: EACH NEW TRADE GETS THE SAME "TRADE #" FOR EACH B AND S OF THAT TICKER
THE NUMBER OF B AND S CAN BE UNLIMITED
THERE ARE LONG AND SHORT POSITIONS

LEGEND:
L=long position
T=short position
B=Buy
S=Sell

For weeks i am trying to define the last thing in my automated trading system.
I use sierra chart and my trading system is based on excel.
my strategy is based on market tensity and is trying to predict market corrections.
there is a rule that if the price came 0.25 - 0.5 points from a pivot point, didnt touched the pivot and a market correction at the size of 2 points or more occured i will not go into position using this specific pivot point. but if after the correction - the price got 5 points away from the pivot and 15 minutes have passed since the correction took place i can use the pivot again.
how can i define something like this? :\
can macro help me? how?
thank you very much in advance

Hello Everyone, I use Trade Station 8.4 to trade both stocks and options. I use staged orders and wait until it is time to enter them into the market. I have hundreds of staged orders that have be every time consuming to build and quality control. When I change the price to enter the markets, quantity to purchase, etc. it is very time consuming. I would like to know if someone has developed a program in excel that would allow me to build the OSO OCO orders in excel an export them into the staged orders workspace in Trade Station.
This would allow me to build my staged orders with OSO in excel and do it very quickly and accurately. I do not know the structor or format of the orders that need to be built. This may be a problem. I need this solution a quickly as possibly.

Hi Folks:
New here but have a question.

1. I have an Excel sheet that plots real-time trade data - 1 value is supplied in real-time, the last traded value of a commodity
2. I want to plot this against TIME
3. So, I do a compare of NOW() against the X-axis (TIME) labels which go as 5pm, 6pm, 7pm etc.
4. All is good, but when the hour switches from let us say 5pm to 6pm, I want to freeze/store the last trade value for 6pm and assign it to 6pm bar

How do you do this? Via VBA?

Also, does anyone know if NOW() is configurable in terms of how often Excel updates the current timestamp?

Thanks for your help!!!

Hi I'm very new to this & hoping you can help ? I have supplier price lists which have 1310 rows of stocklines & 4 columns. Column A is Part numbers, Column B is part description, & column C is list price exclusive of gst & column D is price including gst.
How do we add a prefix to to each part no. in each cell from A1 thru to A1310 eg. pool0001,pool0002,pool0003.
How do I in column c apply a trade discount to each cell individually eg -62% for c1 thru to c1310 to the end results is my net cost per part no.
thanks hope you can help me.
Mark

I have created a graphed curve in excel based on data I have entered. I now want to take the formula for the graph, and use it as an excel computation where I can plug in X and get Y, or plug in Y to get X. However, when i try to enter in variations of these equations, I end up with just the wrong answers (based on the data that went into the graph to begin with.

The formulas excel gives me are these:

y = -1.1288x 3 + 23.209x 2 - 166.76x + 430.07 (preferred), or alternately


y = 579.38e -0.574x


So how can I enter this formula so that I can have it pull x from a cell and spit out the answer for y (and the reverse)?

I "inhereted" a graph with both LINE and BAR series.

I want to add another LINE series.

How?

I can add a BAR. I try to change to a LINE but no go...

Hello, Im new to the board, and like many Im sure that come across here I am in need of some help. Im not the most accelerated excel user, so I will do my best to describe what I am attempting to accomplish.

I started a spreadsheet that is a list of figures for a miniature game. There are tabs for each faction, and all of the "stats" for each figure in that faction are listed. Then there is a "compiled" tab where all of that information form all of the faction tabs are accumulated, so that the information can be sorted by faction, figure number, series number, so on.

Next I made a tab to keep track of extra figures I trade to people. I then made a "traderinfo" tab where I can enter in the mailing address and so forth for peple I would be trading with, and that info would corrospond to a trader number. I could then go to the trade list and assign a certain trader number to a certain figure, along with a quantity of that figure to be traded.

So where I got stuck was, I would like all of the figures selected to be traded to be listed in that traders corrosponding box in the traderinfo tab.

I hope I have done a good job of explaining. And I know it would be easier to understand if you had the spreadsheet I am talking about. I can e-mail the spreadsheet to anyone that would be so kind as to lend a hand.

malform@peoplepc.com

Thank you!