buy

A (Stock) Facebook Amazon Netflix Google Facebook Google B (Action) Buy Sell Sell Buy Sell Sell C (Quantity) 100 50 75 100 100 50 D (Price) 150 1000 150 1000 175 800 What's a formula if I wanted to see how much I spent on buying just google? (Google + Buy -> Quantity * Price) Thank you!

Hi Peoples; - I'm sure there is a simple way around this - please help me find it! A block of data cells (B4:BC27) contain either "FALSE" or "TRUE", and the individual column headers (B3:BC3) may be labelled "Buy" or "Sell"... Req. is to highlight all "Buy & TRUE" in one colour and all...

Hi All. My maths has never been great :-( Just wondering if somone can help me out here, Just looking for a simple calculator that can return % gain/loss, and value in £'s Here's an example of layout of what the calculator would look like. =============== Item xyz Values Buy Price 0.07 Sell...

Hi Folks, I am wondering if there a pre-existing excel formula to subtract multiple percentages for a certain value. For example, imagine you are offering a product which has several discounts depending on the quantity purchased. So, if you buy 100 of them, you will have an additional...

Hello, Happy Holidays. I would like to better analyze data for my work. I don't know how to do this but I would like to know if it is possible and if anyone doesn't mind I would appreciate help with a function that can do this. My data set is 300 columns, and 18000 rows. For this example below...

I am trying to find out how many shares of stock I can purchase based off the following: A) Total money available to spend on stocks is $100. B) I want to buy two stocks. C) Stock #1 price is $10. D) Stock #2 price is $20. The question is this... How many shares can I buy if I can only...

I was hoping to get assistance with a formula that will look at a numeric value in one cell, and then apply a formula that will take that number and apply itself to another cell with custom text and make increments of +1 on an entirely different number (starting at 1). For example: <tbody> 5...

I am a small investor in Shares/ Stocks in Indian Share Market. I have used excel to create stock portfolio. I have bought a few quantity of stocks of Company XYZ at various dates, at various prices and in various quantities. For profit calculation for tax purpose, I am required to use “First...

I would appreciate any thoughts regarding a user defined report generator. Would prefer to buy, or get one free. tia Jack

Hi, Below is my code, is there anyone who can help optimize this? Sub filtering() ' ' filtering Macro ' Dim Rng1 As Range, Rng2 As Range Dim ws1 As Worksheet, ws2 As Worksheet, ws3 As Worksheet Dim src As Range Set ws1 = ThisWorkbook.Sheets("eodcpos") Set ws2 =...

Hello Everyone, I'm a rather new user to Excel but I have been learning alot through self study. I found this forum today an I am hoping someone can explain how I would develop a formula to help with analyzing stock dividend information. I have copied and pasted stock data into the excel...

I have the following on my worksheet (I excluded columns that don't matter for this problem). I want to make to unique hardcoded lists to the right of the main list (bolded). <tbody> C T U W X Y AA AB AC 1 Name Action Value Name Action Value Name Action Value 2 A Buy...

I have a spreadsheet that lists a number of items, the second columns says if it will be Sold or Purchased and then the third column has a value. I would like to create a list that takes all the "Sell" from the list above and lists them with the value in the column next to the name. I am...

I have a dataset that looks like this for 1400 rows: <tbody> Buy 273 Buy 263 Sell_short 340 Sell_long 209 Buy 271 </tbody> When the left column is buy, the right column gets added to the account. When the left column is sell_short or sell_long, the right column gets detracted from...

hello all, i need a formula to help me getting the remaning avarage of the below Buy 100 X 1500 = 150000 i need here avrg of the buying 100 buy 152 X 1505 = 228760 i need here the avrg of buying 252 sell 200 X 1510 = 302000 i need here the profit of the selling according to the...

Hey my fellow celly nerds, I'm wondering if you can help out. I need 4 simple, but related formulas. I uploaded a screenshot of the first page of my data here for you to quickly glance at first, if you would. http://we.tl/1n6sJdBRot It's just a wetransfer.com link, since there's no "browse"...

Hey guys, I am currently backtesting a volatility strategy in Excel 2007 and have stumbled upon some problems automating things. Seems hard to post a snapshot so I'm just gonna describe my sheet and problem... Column 1: 20 day moving average of volatility Column 2: 50 day moving average of...