stock analysis

Hi all, I am trying to figure out how to calculate the Exponential moving average of a stock. The sheet shows the steps involved. I tried using the scan function but I couldn't figure it out. I hope someone smarter than me can help with the formula or point me in the right direction. I know I...

Hello, I want to download the Stock list in one go with a loop when I refresh the page. I want it to download every stock in the stock list to the "combine sheet". ----Combine sheet 1st share "C3", 2. Share "C163" ... I want to download as in the example. ----In the same way, I should...

Hello, guys I'm having a hard time finding a more intelligent (and less repeatable) way of solving a problem I have at work. I think that the only way of solving it is with VBA, but I'm totally open to suggestions Basically, I have a database of stock by SKU and another database of requests by...

NOTE* Please skip until the next line highlighted in bold if you're not interested in seeing how my setup functions. Thank you! Hello everybody, I am currently managing a minor inventory consisting of 101 unique goods. Currently my excel sheet looks like this: To briefly explain the sheet...

Hello everybody, I am currently currently managing a stock overview in Excel (manually), where I have a set quantity. I want to create two columns next to my quantity column where I can enter numbers that should be substracted and added to the quantity, so it looks like this: Now obviously I...

Hi - I am trying to work out how I can get an average dwell time for product which comes in intermittently and gets despatched intermittently. a screenshot of the file is attached. As you can see, some products come in and then get despatched piece-meal whereby some will come in and hang...

Hi there, I am looking for a wizard to help me out on this one. I've created a rather advanced Excel workbook that tracks stocks (analyses, gives alerts, atc). The only thing missing is real time stock prices. I have tried many many things to get real time stockprices in my spreadsheet (power...

Hello, I need help in creating a custom function that will calculate variance of a stock using its raw prices. This means that the returns calculation will take place within the function. I have written the code, but its not giving the right answer, could anyone please guide me? Thanks in...

Hi friends, New here and really hope someone can help. This is for a work challenge so is super important to me. I have never created a macro in excel, though I'm almost positive this is the only way to get excel to perform the task. In my workbook I have price data for a stock by day (I am...

I have been having a heck of a time finding specific stock information and bringing it into Excel. I am aware of the formulas that allow you to bring in certain Yahoo Finance information. That is helpful for some of the variables I am working with, but I still have a few pices of info I can't...

Hi! Please help me with my thesis research. I have downloaded huge data set to analyse. I heard it can be managed via Power pivot tool. But I do not have intensive knowledge on this. For the first step, I want to transform the data. I want dates to be in the rows, and company names to be in...

Hey guys, I've been looking around for this for a while now, and I can't really seem to find exactly what I am looking for. I am trying to return stock prices from 4-weeks ago from the current date, the ending of last quarter, and the ending of last year. The problem is when any of those dates...

I am attempting to pass historical price data for 5 stocks into a 3D array and then do calculations there (and keep in dimension 3). My array is called "matrix" in the workbook attached, and the 3 dimensions are: 1-number of periods (in this case, days), 2-number of stocks and 3-price data and...

Hi, I need to calculate the INTERCEPT and SLOPE of following daily stock prices, but 60 days before the announcement days.Could you guys help me out here ? Its for my dissertation and Its the first time i have to work with that much data. My data is organized like this <colgroup><col><col...

I have three columns. The first is detecting and flagging if the price is coming from a Resistance Turning Point (1) or a Support Turning Point (2). A blank cell indicates that the price for the day did not occur at a turning point. The result of this exercise is designed to return/display a...

Column has dates in first cell, only when conditions in other cells are met. I want to produce a condensed Column of this data, in a new Column that eliminates all rows of data without the dates, with no blank spaces, meaning that the cells where the conditions were not met are eliminated from...

Im just getting to grips with macros and VBA in excel im trying to find an automated way to see if there are any correlations between 2 (or more stock) prices ie. Stock A's price moves -> Stock B's price tends to do this Im at a bit of a loss as to were to start with this, could someone...

Dear all (especially the Maths wizzs out there) I am trying to analyse why my shops stock turn is likely to grow over the next few years. The drivers impacting stock turn are: 1) Sales are increasing therefore Cost of Sales (COS) is increasing 2) I am implementing 3 stock reduction plans A, B...