finance

Any help would be greatly appreciated. I have figured out everything, but there is a slight curveball now. Here is the situation: If the DEAL GROSS is a positive number and FINANCE is a positive, then the max finance Commission that can be awarded 5% of Finance, not to exceed 100...

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 am new, looking for stock quote download excel formulation, Vb or anything else to replace mine, I used NUMBERVALUe and webquery in the until yahoo finance changed and not supporting my script , please chk thespreadsheetguru.com for that method not working now because changed yahoo finance...

I have a set of data with Departments, Names, Dates of Expense, and Expense Amount. Currently the data is set with the Department and Name in Columns A and B // Jan - Dec as the heading // Expense Amounts in each cross section: Department // Name // Jan // Feb // Mar Accounting // Bob // 5...

Hi all, My title covers the reasonably well. I'm working on an end-to-end index, my first real attempt to do this myself - I've frankensteined in an excellent little bit of code which stores the values that my index outputs at each time interval. Trouble is, it only likes to run the process when...

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...

Hi all, I have an excel document that is a column of names and then a column for each month of the year. In the month columns, I have set up drop down lists to select who the customer was billed to (i.e. ABC, XYZ). Each month then had a separate tab with a pivot table set up to pull in only...

Hi, I want to create a formula that brings up a certain value only if this is there, if not, jump to next cell. Basically like this: A shows the return values for a customer Formula shows only the returns for this customer. (assume it is in another workbook) <tbody> A FORMULA 1 -5.5 -5.5...

Hi guys, I'm trying to do a vlookup that looks at different letter ratings (AAA,+AA,AA,AA-,A+,A,A-,etc.) and give that letter rating a numeric value from 0 to 100 that is in an array in another worksheet. But for some reason, my vlookup doesnt seem to recognize the letter rating either in the...

Hi guys, I'm working with pivot tables in excel and historical monthly returns for different mutual funds. I'm trying to calculate the historical monthly returns of each fund net of all management fees. So I have a series called 'MonthlyReturn' and one with the annual cost of each fund called...

Hi, I am trying to build binomial option model in excel. right now I have a macro in place that values American put model & also construct a binomial tree upto 200 nodes. I am trying to make it more dynamic by making it value american call as well as europian options. I have formulas but I am...

Hi All, I'm looking for some help writing a macro to create a new workbook from an existing workbook w/ some unique requirements. Copy data from Workbook1 Create new workbook with predefined column headings and copy data from workbook1 (where column H = "Y") to the respective column in the new...

I have hundreds of rows of data. Each row is a project and cost with start date and end date. Some projects are old and complete, others have started and are ongoing and some have not even started. Using the full range of dates, I want to show the cost of each project by month. I've added the...

Hi all! I have always used the search function of this website to find solutions to my problems but for this one I cannot find the solution so I would require some help. The problem is such (purely fictional ;)) Person X plans to retire at 60 and would like to take out £30,000 a year for 20...

I work in a university study abroad office and have been left with the wreckage of my predecessor, so I'm trying to establish new procedures and methods for processing scholarship applications to make them as objective as possible. I have no idea how to begin with this problem, though I think...

Hello all, Forgive my ignorance here, as I am an extreme amateur in the Excel game. I have been searching Google in an attempt to find an example of a macro to accomplish what I want, but since I have little knowledge, it is difficult to know what exactly to search for. This being said, if...

Hello! I have a program (well, excel program) for my work. The simple formula for this is Job amount x rate (rate is found by a formula in another tab with the state and monthly rate). For example, Arkansas at 12 months is .08699. On the first page I have Job amount (enter manually)...

Hi All; I want to download google finance data from this url :- http://www.google.com/finance/getpri...=1266701290218 where q= stock symbol on Google finance x= exchange symbol i= interval (here 60 means 60 sec (1 minute interval)) p= no of period(here 5d denotes 5 days of data) f= parameters...

Hello fellow forum users! Very recently I have started learning how to properly program in VBA. Could you please help me writing a code for doing the following: 1. (Query running in the background) Stock market data is fetched from the website every minute 2. (Every time the value of a field...

Hi, I'm looking to calculate the CAGR of funds. The base sheet has multiple funds and I need an output which gives the CAGR of all invidually as well as cumulatively.Base File <colgroup><col><col><col><col><col><col><col></colgroup><tbody> Date FundName Number of Units NAV Total Investment...