• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Dash Board -Where to Start

AGYANI

Member
Chandoo & Friends of Forum-Thankyou
Thanks for a excellent in depth excel VBA coding and also techniques.

I am newbie to this forum and been working on some excel techniques using real-time data collection and analysis of the stock information and have created a elaborate worksheets and graphs which are updated realtime and helps in making quick decisions, now that the logic,codes,formulas and all the details of decision analysis is pretty stable.

My next challenge are as :
1. Separating the worksheets in to three (two) categories and arranging them Raw Data Acquisition.
2. Separating the "Given Data" as a User Input Data.
3. Keeping the critical metrics separate
4. Combine all the "Graphs/Charts" in to one "Executive Decision making Dashboard"
5. Increase the performance of the RTD (Previous DDE) connections.
<b>Data Metrics</b>

Average max data rows collected during the trading day is around 22680, currently there are 3 worksheets

I need some guidance on how to approach this. TIA
 
Back
Top