sell

<tbody> A B C D E F 1 Buy Product A 3 2 Buy Product A 3 3 3 4 Sell Product A 1 =(1 x 3) 5 Sell Product A 2 =(2 x 3) 6 Sell Product A 4 =(4 x 3) 7 8 Buy Product B 14 9 7 10 Sell Product B 5 =(5 x 7) 11 Sell Product B 6 =(6 x 7) 12...

The price of electricty fluxuates hourly over the course of a year. My goal is to buy electricy for storage from the grid for the asking price at the time and sell it back to the grid at a later time (for a greater price) in order to make a profit. The criteria however is that when selling it...

Hello Friends I am in little trouble hope you will help me. I have a excel sheet and into this sheet data is fetch from another Software (Live Data). <colgroup><col><col span="2"><col></colgroup><tbody> Company Name Value Reaching Value Status A 1000 2500 Sell B 5000 2500 C 4000 2500...

Hello there, I have an excel sheet which contains an inventory purchase & sell details of a stock. In first column I have date in ascending order In second column I have purchased stock quantity. In last column I have sold stock quantity. So what I want is that whenever there is a sell it...

Good Morning I am having a small issue with the following formula =SUMIFS('DVP Settlement Report'!P:P,'DVP Settlement Report'!E:E,"Sell",'DVP Settlement Report'!V:V,FALSE,'DVP Settlement Report'!R:R,C7) This formula returns a zero value (as it does not recognise the FALSE value) (I have tried...

Hi, i'm trying to create some subtract formula, but no idea how should i do it, the table below would show the result i desire: <tbody> A B C D E F 1 DATE STOCK ITEMS NAME COST PER STOCK (IN USD) QUANTITY OF STOCKS CUMULATIVE/ BALANCE OF STOCKS REMARK 2 1/1/2019 XYZ USD 1 1000 1000 BUY...

Hello everyone, This is my first time posting on here, and I'm very new to Excel VBA code, so I would appreciate some help. I have an Excel workbook with 7 sheets. The 1st one is a reference sheet titled Allocation, where I type in names of accounts into cells A3:A5. For the purpose of this...

Hello All, I am trying to build a template to calculate the selling price of an item given the various costs. Assuming I buy a product for $10.00, I expect to make a 10% profit Margin so technically I would need to sell it for $11.00 So far I can handle it, the issue is that the platform where...

Hi All! I am trying to come up with some code that will 'scrape' a couple of values from a website and save those values into a couple of Excel cells, and possibly autoupdate those cells whenever the website updates those values that were scraped. The site that I am trying to scrape from is...

I need assistance with a formula to place a "1" in a sell or yes if 3 other cells = no. Cells K2, L2, and M2,

I apologize in advance if this has been answered. I searched and couldn't find my exact issue. I am creating a quote tool that lists items with a column for cost, sell, and profit. Those columns are totaled. Then I have an area for lease info where the total in the "sell" column is...

Hi, I'm trying to write the below formula. Column E has the word "buy" or "sell" in it Column F particular date in it Column C has a dollar amount in it I want to write a formula that will sum up the dollar amounts in column C of all the instances where it shows the word "sell" in column E...

I'm trying to figure out a way to allocate a sell transaction to tax lots where the order might change over time. For example: Say you have a table with four columns and the number of units of stock stored in a row across the four columns. So A1 has the number 10 A2 has the number 4 A3 has the...

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, I am after formulas for 2 cells in a spreadsheet. Column A is a Cost price (derived from a report) Column B is for a Sell Price Column C is for the GP% I want to be able to enter an amount into Column B that will give Column C the GP%. Also the reverse so that I change the figure...

Hello guys, I was looking for FIFO profit and loss calculation and despite many FIFO subjects (mostly calculating stock value), I ended up starting from scratch, which I usually avoid.. two subjects helped to understand, but I coudln't have it work for my-self. This UDF couldn't work ...

Hello guys, I was looking for FIFO profit and loss calculation and despite many FIFO subjects (mostly calculating stock value), I ended up starting from scratch, which I usually avoid.. two subjects helped to understand, but I coudln't have it work for my-self. This UDF couldn't work ...

Hi. I've been debating on how to do this but so far couldn't find a way. I have 3 columns, A, B and C. Column A show my buy and sell orders. Column B show how many products I bought and sold Column C show the price at which I bought and sold My goal is to sort columns A, B and C and transfer...

I'm trying to find a formula to calculate the projected sell out date of our inventory, example if i have 1582 of one item in stock, and sell 181 a month, when will I sell out? Below is a list of our order, hence why ((D2+F2)/K2) was my first thought, but I am not sure how to make it project a...

Hi, Need some help if can do this in VBA or Pivot. Unable to figure out the way on this. I have the following Data: from Column A to K for Equity Option Trading: <tbody style="box-sizing: border-box;"> No Date/Time Strategy Method Qty Pos Effect Equity Expiry Date Strike Price Transaction Type...