Search results for query: *

We have thousands of rows, each containing all the prices of a financial futures index prices during each trading day. In this way: say row 1231 contains all prices (every second or in smaller intervals) for 23/12/2009. We want to test a small change in our proprietary trading system (a separate...

Hi everyone In cell A2 I will key each time a different number representing the row with the data I would like to check. In my sheet, from row 5 to 1000 I have data already entered (each row contains data from column B to column CZ). I would like to have in cell A3 the formula...

Thanks lionelhill for the great help. Is there a way in your formula solution not to populate the whole range with zeros, but instead with blanks? The reason for the question is that as I am going to plot the range with data as they occur, having zeros all the way down the range will make my...

Hope the logic is now OK. '[new value] value in A1 '[prev value 1] last recorded value in column B '[prev value 2] next to last recorded value in column B '[current direction] current direction recorded in C1 : +1 direction Up ; -1 direction Down 'Initial recording: until [prev value 1] and...

Hi Skip, Sorry. Only now I am starting to study VBA and I am very unsure about how to write a code, but you are right. It was what I meant when I wrote B2 > B1, meaning [prev value 1] greater than [prev value 2]. [prev value 1] cannot be equal to [prev value 2] (see contribution above by PHV...

Thanks Skip, '[new value] value in A1 '[prev value 1] last recorded value in column B '[prev value 2] next to last recorded value in column B '[current direction] current direction recorded in C1 : +1 direction Up ; -1 direction Down 'Initial recording record [new value] in B 1 record [new...

Hi everyone, Skip's VBA solution works just fine. Excellent. And with a contribution by PHV(MIS), no more repeated numbers as well. But, to make things more challenging, as I expect the numbers of different numbers appearing on A1 to increase substantially, besides not recording repeated...

Hi PHV, It works just fine. No more repeating numbers. Excellent. But, to make things more challenging, as I expect the numbers of different numbers appearing on A1 to increase substantially, besides not recording repeated numbers anymore, I would like to record only numbers which shows turning...

Skip, I've just tested the VBA code and it works just fine. Everytime there is a change in A1, the number is recorded down in column B. Perfect! 2 points of difference to the spreadsheet solution: a) the VBA solution records every single change in A1, even zeros. Good. b) it records in column B...

Hi guys, The spreadsheet solution (lionelhill's) works just fine. I've just tested it and every time a new number apppears in A1, a new cell shows a permanent value down column B. Brilliant solution!!! I would like to confirm with you lionelhill, why the need for copying the whole of column B...

As this is the first time I am using a code (I am still learning VBA), is this the way I should do? 1) Open my workbook 2) Click Developer, then VBA 3) Select my Sheet 4) From the Insert Menu, click Module 5) Copy the code you wrote 6) Click Run 7) Give the macro a name Is that OK? Thanks

I was just wondering if there is a way in the IF function to return a value if logic is true and not to change that value any longer. Thus, I receive online in Cell A1, 20 different prices everyday and I would like to have all them recorded starting from cell B1 to B20. When I write in every one...

I was just wondering if there is a way in the IF function to return a value if logic is true and not to change that value any longer. Thus, I receive online in cell A1, 20 different prices every day and I would like to have all them recorded starting from cell B1 to B20. When a write in every...

Thanks ettienne for your comments. I really appreciate your help. The point is everybody in the markets use the same statistical tools and the same technical analysis. And that is the major reason why 99% of the players lose all their money playing futures. There is no way to predict the future...

I am using a Line Chart and it is plotted with Select Data Source referring to the range ($B$3:$B$10000) and as a new price occurs, a new point is automatically plotted on my chart (on a separate workbook). The problem is that plotting all the prices restrict the ability to see the real picture...

Thanks SkipVought. I was able to plot my data, but my point is the amount of prices to plot (let's call it "noise") is enormous. That is why I thought of eliminating the "noise" and only plot prices which show a minimum of 3-points correction. But how to filter it? I tried examining all the...

Thanks PHV, Sorry. I have no knowledge of VBA. I don't know how to write codes. All my experience is with building formulas using Excel functions. But, never with macros. Mark

Thanks for the comments. So, let's go to each one of them. 1) N1GHTEYES: I use a IRESS platform with Real Time Display. My spreadsheet is populated live with prices as they happen. The market has varied a lot but the maximum number of contracts traded everyday can reach up to 50,000 but as the...

Hi everyone, I have no knowledge of VBA and I will need great help to solve this problem. Everyday, as they occur, every single price of a contract traded on the Sydney Futures Exchange is downloaded to my Excel 2007, starting from row 2 up to row 10,000 (+/-). I would like to filter all these...

Hi Skip. Thank you very much for all your help. By the end, I could not do the test on the prices as there are more than 5 years of prices which were entered manually. I tried to create a new spreadsheet, copy and paste the code and then copy all the data but it did not work. Also, the code...