Ask Experts Questions for FREE Help !
Ask
    vks64's Avatar
    vks64 Posts: 53, Reputation: 1
    Junior Member
     
    #1

    Nov 20, 2012, 10:43 AM
    modulation of data in excel spread sheets
    Dear members,
    I have attached an excel sheet named “Ask me model table” for reference:
    1) In the attached table, I have presented the trade data of 10 specific shares for a day, as on 19.11.2012.
    2) The table has four sheets.
    3) In sheet no.1 named basic data, based on the HIGH, LOW values of ten shares for the day (available in columns C & D) certain study levels are worked out (which are also called fibanacci levels), for analytical purposes and presented in columns “Y to DC”.
    4) Now a new column is inserted as column G in sheet no.2 (titled as step1)
    5) In sheet no.3 (titled as step2) the column is filled manually with fibanacci levels( column headings) (available in columns “Y to DC” ) which are very near, close and lower in value to the “Last traded price available in column F”.

    Now the question presented before our elite and qualified members is

    A) Whether the levels for column G (as explained above) shall be filled automatically by introducing any excel formulas or macros or some other utilities?

    B) Whether the trade values in sheet no.1 (columns-B to K in sheet “titled as basic data” ) shall also be updated automatically for the next day with the help of data available in “sheet Update” for the day 20.11.2012 and repeatedly for all the subsequent days and the column G also updated in the process.

    Thanking You

    Vks64
    Attached Files
  1. File Type: zip ASK ME MODELTABLE.zip (73.7 KB, 27 views)
  2. File Type: zip ask me help question-20.11.2012.zip (12.4 KB, 23 views)

Check out some similar questions!

How to link multiple excel sheets to one main source excel sheet [ 7 Answers ]

I have a master price list and multiple ( individule ) sheets for customers.. I would like to , when input data in the price list to link and update to all other sheets... ( I do not want to have a source sheet with tabs) Thanks

Compare related data stored in two or more excel sheets [ 18 Answers ]

How to compare related data stored in two or more different excel sheets? For example, annual sales figure of a number of companies relating to two OR more years available in different excel sheets? Either by grouping (pooling) the data into a single excel sheet or otherwise?

Compare 2 Tables or 2 Spread sheets [ 9 Answers ]

Excel 2007: I want to be able to compare TWO (2) Columns or two spread sheet. For Example I have a Column of students and corresponding records; Then I have another column similar to the first one but essentially more/less students. I want to be able to compare both columns and get rows...


View more questions Search
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.