Recent content by Mark2Aus

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