How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask Pete Your Own Question
Pete, Computer Expert
Category: Microsoft Office
Satisfied Customers: 16878
Experience:  MS Office expert
Type Your Microsoft Office Question Here...
Pete is online now
A new question is answered every 9 seconds

Have futures data from Rithmic coming into Excel 2013 now.

Customer Question

Have futures data from Rithmic coming into Excel 2013 now. Need someone that can help me build a real time chart with open, high, low, and close bars. The horizontal grid lines must be colored coded as prices move up and down. (blue, yellow, red, green, blue, green, red, yellow, blue). Need to space verticle price scaleon 1/8th, 1/16th, 1/32nd, or 1/64th
increments in decimal points,
thanks for listening
Submitted: 1 year ago.
Category: Microsoft Office
Expert:  Pete replied 1 year ago.


Quite a bit of programming will be required for this - you'll need a macro that will copy the current state of the cell and append it into the first empty cell of a given column. Then you'll need to define a dynamic range that always grabs the last x cells of the column. This dynamic range must then be defined for your data series so that the chart can be shown. After that, you can add the color coding, scales, etc. Are you familiar with writing VBA code?

Alternatively, there are lots of free online share tracking tools that work in real time and you can use and customize them to display what you require -

Related Microsoft Office Questions