stocks

I have stock buy/sell transactions and want to calculate my position. Here is some sample data: I can calculate most things I need but I'm struggling with Average Cost. So XXX bought 100 at $1 then sold 50 at $2, so my average cost is $1. Then bought 100 at $2 and sold 100 at $3 so I have a...

HI, Imagine I want to create a formula that gives me the percentage change between to specific dates, and I want to do it within the powerpivot contexto (with DAX functions). For example:(just for the sake of the example, these numbers are false) A table with all the prices of Apple's stock...

Hello, I am trying to do a project that is based in the analysis of stock quotes over several years. However I have a few questions and I hope you can help me. The project I want to analyze how certain stocks behave between specific dates, i.e, what is the percentage growth or decay between...

Hi, I have an excel file with 1500 columns and each column has 4500 rows of data. Here is an example of what my spreadsheet looks like: https://imgur.com/a/n9mZ7 Here is what i'm looking to do. 1. I want excel to look at every 4th column starting from B. So the first column excel would...

Dear community, I would like to build a macro from directly obtaining Bloomberg Data (PX_LAST and OP_INT) for a large set of stock. Has anybody of you already tried to insert the BDH function into a Macro? How did you o it for multiple stocks? Could you create 1 table only? I am sorry fr this...

Hello Everyone, I know this one pretty easy for you guys but I hope you can help me. I have a list of inventory stocks. Everyday I need to fax a list of stocks that needs to be taken out from the warehouse and I cannot avoid having a mistake of writing the wrong number. So I was wondering if I...

Im working on a spreadsheet for B3 (Bovespa, brazilian stock market) opening auction. I use my trading platform to export all the trades and then i filter the opening and the first 1 hour of 143 stocks, will show an example of what i get in the end: https://imgur.com/a/ont9O I want to...

Hi I need help in solving the below issue. I have stock of product say "X" 100 units. I have 5 different orders for 80 MT. This stock should get adjusted to these orders with certain criteria say earliest ordered date. like this I have n number of products and there will be orders for these...

Hi Everyone, I have the monthly return data of 17 stocks. I need to calculate the cumulative returns. I see some have posted saying to use the PRODUCT function. However, I've been using it but it doesn't seem correct. If i check by dividing the ending price by the beginning price I get a...

Hi All, As a side project, I am working on creating a stock index comprised of 25 or so stocks and tracking their change. To set this up, I loaded the closing prices of the stocks for the past 6 months, and weighted each of the stocks a certain way (ex. .1, .015, .2 of the entire index) based...

Hey, I have a portfolio of 20 stocks over a time period of 15 years. I calculated the mean returns and the covariance matrix. Now I want to perform a Monte Carlo simulation based on a multivariate normal distribution with the same parameters. I downloaded the “real statistics resource pack”...

Hello, I want to pull some financial data from a website. Google Sheets has a fantastic function for grabbing data from tables. In my example, I want to pull the balance sheet for a specific company. Here is a link to the Google Sheets' example Is there an Excel equivalent? I tried getting...

I am trying to link two macro buttons titled " Retrieve Financial Information" and " Display 10 Year Stock History" to a table that is linked to 5 drop down lists " Preferred Risk", " Gives Dividend", " Price/Share", "TheStreet Rating", " Preferred Industry" so that depending on what I select in...

Hello Exel-sperts (yes i love bad puns), I have spent weeks reading forums and watching videos only to fail at creating the spreadsheet I set out to; I am hoping that someone on here might be able to help me. I need to create a spreadsheet which pulls multiple data points (from a few web...

So, what I am trying to do is enter in a random number "X" in a column, and from that day forward it will increase by one number by each day (if i input 13 in today, tomorrow i pull up the excell sheet and it will show 14). So I'm into investing and I have come across a study that keeps tracks...

I would like to produce an IF(AND formula that outputs three results? The three results would be "BUY", "HOLD", and "SELL". The obvious restraint if an IF(and statement only allows for a "TRUE" and / default "FALSE" result. Has anyone developed a work around for this situation? Thanks...

I have two sets of data: stocks for two different years, 2012 and 2013. If the stock's NAME exists in both years, I want a new column that shows the price difference (year 2013- year 2012). Since the rows of stock names do not always match, I am not sure what tool to use. Excel 2012 <tbody> A...

I have tried to utilize the following formula but it is returning zeros? =COUNTIF(CH3,(RANK(CH3,CH3:CH62,0)<3)) I just need to graph the two highest values in a column of stock prices to produce a resistance line. Thanks for your assistance, Michael

I am attempting to produce a candlestick chart of a stock and draw on the chart the support and resistance trend lines. I have found a couple of methods through online searches. I want to see if anyone on this board has any suggestions or prior experience with this challenge? Grateful for all...

I have two columns: The first is the volume for a stock and the second is that stocks price at that volume when it touched a support or resistance level. Volume Turning Point Price 9795000 520.03 9826700 0 12596300 0 22707400 0 19658600 0 12064000 0 13741600 531.91 11204400 0 19073700 0...