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
I will try to explain the best I can, please ask questions if you don't understand so I can clarify...
I have a invoice that I send. We have them generated in bulk and they're made into one file. I don't know why but it's the way it is. So, this is what I need to do:
Split this 1 file into individual files by invoice number.
The Invoice No. on the top right of the page will need to be changed according to the invoice the particular file is created for.
All other invoice numbers present for the given invoice will need to be deleted.
The total must still be summed at the bottom of the "Amount" column.
This will then need to be saved in Excel format AND saved as a PDF with the same file name (by means of save as... PDF). Document names are to be saved as "inv 10xx" (.xlsx and .pdf).
I've attached a sample invoice so you can see what I'm referring to.
1st file is what I initially get. (sample invoice)
2nd file is an example of what it needs to become. (inv 1001)
I'm wondering if a VBA could be made for this to automate/streamline this process.
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
Is there an Excel invoice template that automatically adds current info into
a year-to-date summary worksheet? What I'm looking for is an invoice that
will automatically add the invoice total to another file listing weekly
invoice amounts to create a year-to-date summary.
Could someone give me the exercise to be followed to create auto numbering in invoices in Excel as same urgently required. thanks.
Hi there,
I am trying to create a sequential invoice number in excel. So that each time I have a new invoice the invoice number is automatically generated?? I've tried the following macro but it did not work: Private Sub Workbook_Open() Range ("a1").Value = Range ("a1").Value + 1 End Sub Can you suggest an alternative way?
Many thanks
C
I need help with creating invoices (excel file) that have my individual
customers information from another excel file. To be more clear, I have a
standard invoice (excel file) with name, address, and balance missing. I
need to incorporate information from another excel file that have names in A,
address in B, and balance in C. I need it to print out many invoices with
each one containing one costumer info. Please help me.. Thank you
