Search results

i want an excel sheet lying on my desktop name abc to open daily at 9:00 am automatically. regards anup

Dear all I've a vba which is inspired by the solution given by Hui for my other problem earlier discussed in this forum. Function Find_Target(Target, Data, tRange, Optional bRange = 0) As Variant Dim c As Range If bRange = 0 Then bRange = tRange For Each c In Data If c.Value <= Target -...

Dear All link to download excel spreadsheet is http://vll.co.in/wp-content/uploads/2013/03/data-series.xlsx Here column a contains date and column b contains price of a share (in rs.)on that date. I need to see how many times the share price has moved from a certain price by a certain...

Hi Narayank, the link to download excel spreadsheet is http://vll.co.in/wp-content/uploads/2013/03/data-series.xlsx here you would see the price chart, in this chart we you'll see the price is moving from 90, 100, 110, 120, 130, 140 again 130 then 140 150 and so on. here the no. of...

Dear all I've got a series of numbers lets say(90, 92, 86, 99, 100, 101, 102, 104, 109, 110, 111, 104, 107 ......120, 125, 130, 140 .......100, 95, 90, 85, 84, ......70) and these numbers are written in excel sheet in column b (the numbers are written in order b1, b2, b3 ...and so on).For...

I've got a black scholes option pricing model in Excel which tells the value of all the Greeks related to the options pricing. If someone knows about options pricing must be knowing about delta, vega, theta gamma etc. This sheet tells me about them. If you just Google it , you'll find lots of...

sir it should be from 5912.60 till 5919 sir in this example the data changes from 5912.60 to 5,925.00 i.e. one then from 5922.60 to 5933 and then from 5932.60 to 5918.35. here the movement occured 3 times., just to make it more clear. when we reached 5925 it means we have crossed 5922.60 etc...

Hi everybody i have got a series of data which is captured live from exchange. the format of the data is as follows: Open high low close 5,912.60 5,912.60 5,907.25 5,911.65 5,911.95 5,920.80 5,911.95 5,920.70 5,920.80 5,925.00 5,920.80...

Hi hui I've tried scenario manager and i've seen its working, but the problem is its very much time taking, I've to add 100's of scenario to back test the results. Is there a shortcut way in scenario manager where for every 1 day rise in cell c271 we get scenarios and get results for cell...

Hi Hui, I was just thinking if my problem can be solved by using some macros, in which for all the different values in c271 we will copy and paste the results of cell U285 and make a table out of that. Regards Anup

hui please give me your email id i'll send u my file, i don't know why when i'm uploading it some formulae are getting changed. Regards Anup

Hui now i've shared it, i think now you can see it

sorry hui ok i repeat my question. I'm trying to develop a financial model in which your post has helped me a lot. Now, again I'm uploading a file : https://docs.google.com/spreadsheet/ccc?key=0AsicBmCuaAIDdEV4UDVocW1UUVhDRGxBTm54ZjVPSmc&hl=en_US#gid=0 Here I've used Data table and could...

hi Hui, if you find time please go through this query. Regards Anup

HI HUI, Sorry to disturb you, but this was urgent, did you see my query under topic MULTIVARIATE REGRESSION ANALYSIS VBA Regards Anup

Hi Hui I'm trying to develop a financial model in which your post has helped me a lot. Now, again I'm uploading a file : https://docs.google.com/spreadsheet/ccc?key=0AsicBmCuaAIDdEV4UDVocW1UUVhDRGxBTm54ZjVPSmc&hl=en_US#gid=0 Here I've used Data table and could make what i wanted to make...

Thank you hui Regards Anup

Hey hui can u tell me how did you prepare the table in the excel spreadsheet anup.47 I'm using it and have no difficulty but when i'm trying to construct the table, i'm unable to do it. Please explain me how can i make the table (below m2 and m1) Regards anup

hi luke thanks for he tip, i have worked on it and added some more logic and now its working for me. i'm just writting the vba here. Dim LastRow As Integer LastRow = ActiveCell.Offset(0, -1).End(xlDown).Row - ActiveCell.Row ActiveCell.FormulaR1C1 = "=MAX(RC[-1]:R[ & LastRow & ]C[-1])"...

thank you for your reply I would make my question a little simpler. I've tried a macro ActiveCell.FormulaR1C1 = "=MAX(RC[-1]:R[10]C[-1])" here i just want that R[10] should be R[LAST CELL BEFORE THE EMPTY CELL], It can be R[5] If 5th row contains the last data, i.e. 6th is empty. Please...

Hi Everybody I'm looking for a macro which can sum all the data in a range till a blank cell arrives. For example my data set starts from b2 to b11, and then b15 to b20, now i need to sum at c2 sum(b2:b11) and so on. I need a macro, when i select c2 and press the macro shortcut should...

Thank you very much, its really working smoothly. with regards Anup

Dear all I need to know how to copy certain data from an excel spreadsheet, lets say from a1:b10 and paste it on other excel spreadsheet. If i need to paste the same data on other sheet of same spreadsheet i.e. from sheet 1 to sheet 2 then i can do it through a macro but i can't do it for...

Thank you very much, thats awesome. It's really working. regards Anup

Thank you for your reply. when i use this linest function as an array, i get my Beta1, Beta2, alpha (i.e coefficients of x1 x2 etc) in horizontal format. Now i have Y1 to Y500 columns against 2 columns x1 and x2. I want that beta 2 , beta 1 and alpha along with r2 all should come below...