Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Mark2Aus

    INDIRECT FUNCTION

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

    INDIRECT FUNCTION

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

    IF function

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

    IF function to fix values

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

    IF function to fix values

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

    IF function to fix values

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

    IF function

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

    IF function to fix values

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

    IF function to fix values

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

    IF function

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

    IF function to fix values

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

    IF function to fix values

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

    IF function

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

    Filter thousands of daily data

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

    Filter thousands of daily data

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

    Filter thousands of daily data

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

    Filter thousands of daily data

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

    Filter thousands of daily data

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

    Filter thousands of daily data

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

    Excel Code

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

Part and Inventory Search

Back
Top