trade

Hello, Excel noob when it comes to Index Match and first time posting. TIA! I am creating a spreadsheet to model portfolio trades based off of target trade amounts. I'm trying to prioritize the allocation of certain "Stock Types". I'm wondering how I could retrieve a specific figure based...

I am trying to find the largest number based on the date, then quantity on trade for each day of the month. I currently do it manually each day but am looking for a formula to do it for me without using the ctrl+shift+enter function. Looking for the formula in largest trade column <tbody> Date...

Hi all, kindly advice me for a VBA code so that, to run through col. “H” and where find the descriptions “Trade union 1” and “Trade union 2” should insert rows below and also should divide its amounts in col. “J” by 2 and place them in the inserted rows. Descriptions in new rows should be “Trade...

Hi all, i would like to turn duplicate rows into unique using VBA. Therefore the data start from "A2" and the code should run through col. "A" and where the rows are duplicates, should place a number (serial number) on left of description. below i present the original data and the expected...

Hello I need a help manipulating data on a spreadsheet. The spreadsheets columns are buy or sell, ticker, price, trade date, execution time. The rows are filled in with varying trade information, with either a buy or sell. I'm trying to identify all trades that took place on the same day and...

Hi all, kindly advice me for a VBA code so that to run through col. “A” and place the codes in adjacent cells to description, col. “B” but for the last 2 rows. The codes are follow: <tbody> TRADE UNION 5012505 SOCIAL INSURANCE 5012508 MEDICAL FUND...

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 folks, looking for a little help again. I am trying to do a small ‘drawdown’ sheet for my trading account. I use a 3 to 1 risk ratio. I am willing to risk ‘1’ (2% of my account) to make ’3’ (6% gain). Each time I lose a trade, I lose 2% of my account, so 4 consecutive losing trade, means I...

I’m trying to calculate the number of winning trade on my table. The header of my table is ‘Win / Loss’. Each trade is a ‘Win’ or ‘Loss’. Out of the 3 trades made, all 3 were ‘win’, but win rate is shown at 38%, instead of 100% This is the formula I’m using: =COUNTIF(Table2[Win /...

Modification to the attached excel sheet that uses Microsoft Power Query as follows. Keep all functionality working with these modifications. Employee Schedule Sheet- Option to sort by trade I would like the option to sort by trade then jobsite then alphabetical… Also dates should remain in...

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, I am looking for vba syntax here to count visible cells after filtering data Status column should be unmatched, below are Criteria. 1) Count trade age less than <2 , Result Sheet2.range("b5") 2) Count Greater than >2 & <=3 , sheet2.range("b6") 3) Count Greater than >3 ...

Hi Team, I am looking for excel formula in C2/VBA here My task is count the trade processed yesterday, and reallocate between reviewer in such a way that he should not get same trade already worked. if the count is odd its ok if we allocate the trade extra to someone. This is my daily task...

<tbody> Date High Low Close 1/1/17 106 101 103 2/1/17 110 103 107 3/1/17 103 95 101 4/1/17 105 92 100 5/1/17 100 88 95 6/1/17 98 86 92 7/1/17 100 80 90 </tbody> So I am trying to put a formula/spreadsheet together that does the following. % return...

Hi Folks, I'm struggling to manipulate a data set I have and am hoping someone can help with a solution either in VBA/Pivot table/formula. I have a list of trades which are executed, then this trade is split down among a group of clients. For example, we buy 1,000 MSFT US @ $10 per share. These...

Hi, I want to convert the below Sheet 1 excel data to to Sheet 2 Excel Data. Could you please help. Whether in simple code or any macros. In Sheet 2 Year(Dropdown values(2014,2015,2016), if user selects 2014, then 2014 data only should display. So based on the year the records should...