+ Reply to Thread
Results 1 to 2 of 2

Which functions and reports needed for this sort of report

  1. #1
    Registered User
    Join Date
    08-11-2022
    Location
    London
    MS-Off Ver
    chrome
    Posts
    1

    Which functions and reports needed for this sort of report

    Hi,

    What i want is
    a tab/tabs where i can enter the raw data
    a tab which gives me report

    the type of data is stocks OHLC prices with times, few indicators prices and few entries of data i will enter manually with respective time


    then i want to create a report tab where i can see the results of the parameters i set
    the parameters will be like

    when there is a down trend on daily, and the signal on H4 or H1 provided
    technically ( as far as i get) it is
    if the value of data set 1 is A/B/C, the value of data set 2 is a/b/c and the value of data set 3 is i/ ii/ iii
    for the required combination of data sets results, the time when the specific conditions are fulfilled.

    as you can see it is even hard for me to explain. What I do know is excel is powerful enough to handle this and give me a report

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Which functions and reports needed for this sort of report

    I would probably use pivot table to analyse the data.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Macro needed to sort out courier reports
    By Billio in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 2
    Last Post: 04-26-2020, 06:22 AM
  2. Several reports into 1 report with daily updates?
    By Vihral in forum Excel General
    Replies: 26
    Last Post: 05-19-2016, 09:58 AM
  3. Merge Profit & Loss Reports into one Report
    By KazzICC in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-19-2016, 12:20 AM
  4. [SOLVED] PowerPivot reports with consolidated report from two tables.
    By nsr1989 in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 12-18-2013, 06:42 PM
  5. Conducting audits by comparing 2 reports, best way to generate a third report
    By wuoshi1031 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-08-2013, 05:16 PM
  6. Make a Single report from Multiple reports.
    By devpp in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-25-2013, 05:56 AM
  7. pivot reports - limit report to last 20 dates
    By Pivot Help in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-01-2005, 06:06 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1