TAKING HOURLY DATA FROM A CELL RECEIVING REAL TIME ACTUALIZATION

%3CLINGO-SUB%20id%3D%22lingo-sub-1259930%22%20slang%3D%22en-US%22%3ETAKING%20HOURLY%20DATA%20FROM%20A%20CELL%20RECEIVING%20REAL%20TIME%20ACTUALIZATION%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1259930%22%20slang%3D%22en-US%22%3E%3CP%3EIn%20my%20pages%20I%20have%20cells%20receiving%20real%20time%20new%20info%20(equities%20quotations%20from%20the%20exchanges).%20I%20want%20to%20take%20such%20info%20in%20different%20cells%20according%20to%20different%20time%20spans.%20For%20example%2C%20I%20have%20a%20cell%20receiving%20the%20higher%20quotation%20for%20a%20stock%20during%20the%20day.%20I%20want%20to%20take%20such%20data%20at%20different%20time%20spans%2C%20a)%209%3A30%20to%2010%3A30%2C%2010%3A30%20to%2011%3A30%2C%20and%20more.%20I%20do%20not%20want%20the%20cell%20to%20be%20modified%20after%20the%20time%20span%20have%20concluded.%20How%20to%20do%20it%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1259930%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Visitor

In my pages I have cells receiving real time new info (equities quotations from the exchanges). I want to take such info in different cells according to different time spans. For example, I have a cell receiving the higher quotation for a stock during the day. I want to take such data at different time spans, a) 9:30 to 10:30, 10:30 to 11:30, and more. I do not want the cell to be modified after the time span have concluded. How to do it?

0 Replies