trades

Hi guys, need some help to finish my code to execute FIFO (First In First Out) in stock of data. So basically I have a big stock of trades (Equity Swaps by the away) and I receive in a daily basis a few number of new trades that can be: a Unwind, meaning, a partial or a full liquidation of an...

Hi all! There is something I'd like to do, but unfortunately am not able to do so myself... I have several sheets with entries of trades (in the example it is the "Trades" sheet). A trade is opened at date X, time Y and it closes at date Z and time Q. On another sheet ("Exposure" sheet in the...

Hi, I am adding to my sheet a trading simulator. Out of 100 trades, the Win Rate, for example, is 60% (60 trades will Win out of 100). On the spreadsheet, I want the R-Multiple colum to reflect this by showing 60 (3.00) and 40 (-1.00). Each Win is represented by a ‘3’ and each loss by ‘-1.00'. I...

Hello Dears, As in image above : i am trying to make a formula for column J and K: - As in column "J" i need the Pips In Lose to be calculated in case i type "L" in column "I" - As in column "K" i need the Pips in Profit to be calculated in case i type "P" in column "I" - In column "I" when i...

Good evening everyone, I'm trying to pull a list of trade data from our Trade History and get the Date, # Shares and Price for all trades matching the stock ticker. I've found a series of nested functions to pull the information out but I'm having a peculiar problem. I'm pulling all the data...

Hi Team, Below is my vlookup. this code is for single worksheet it works. I want to run this code for sheets {1,2,4,6} only and in column B1. if vlook up result give exact match it should display the result :=> For match "Old trades", else "New trades". Colomn for vlookup is fix. (b:b). plz...

Hey, Say I have 2 sheets, one with accounts containing user account number and name and I wish to find the total sum of profit/loss made by all users. the second sheet contains the account number I use for the lookup and the profit which can be negative and positive. how would I find the actual...