Apprentice wrote:Can you share excel / code.
Oh, it is just a simple macro created using "Microsoft Mouse and Keyboard Centre" using just keystrokes to automate inputting the data and the indicator on the chart. It works like this if anyone is using the same app
- Code: Select all
<?xml version="1.0" encoding="UTF-8"?><Macro>
<KeyBoardEvent Down="true">29</KeyBoardEvent>
<DelayEvent>110</DelayEvent>
<KeyBoardEvent Down="true">46</KeyBoardEvent>
<DelayEvent>110</DelayEvent>
<KeyBoardEvent Down="false">46</KeyBoardEvent>
<DelayEvent>110</DelayEvent>
<KeyBoardEvent Down="false">29</KeyBoardEvent>
<DelayEvent>110</DelayEvent>
<KeyBoardEvent Down="true">56</KeyBoardEvent>
<DelayEvent>110</DelayEvent>
<KeyBoardEvent Down="true">15</KeyBoardEvent>
<DelayEvent>110</DelayEvent>
<KeyBoardEvent Down="false">15</KeyBoardEvent>
<DelayEvent>110</DelayEvent>
<KeyBoardEvent Down="false">56</KeyBoardEvent>
<DelayEvent>110</DelayEvent>
<KeyBoardEvent Down="true">23</KeyBoardEvent>
<DelayEvent>110</DelayEvent>
<KeyBoardEvent Down="false">23</KeyBoardEvent>
<DelayEvent>110</DelayEvent>
<KeyBoardEvent Down="true">28</KeyBoardEvent>
<DelayEvent>110</DelayEvent>
<KeyBoardEvent Down="false">28</KeyBoardEvent>
<DelayEvent>110</DelayEvent>
<KeyBoardEvent Down="true">15</KeyBoardEvent>
<DelayEvent>110</DelayEvent>
<KeyBoardEvent Down="false">15</KeyBoardEvent>
<DelayEvent>110</DelayEvent>
<KeyBoardEvent Down="true">29</KeyBoardEvent>
<DelayEvent>110</DelayEvent>
<KeyBoardEvent Down="true">47</KeyBoardEvent>
<DelayEvent>110</DelayEvent>
<KeyBoardEvent Down="false">47</KeyBoardEvent>
<DelayEvent>110</DelayEvent>
<KeyBoardEvent Down="false">29</KeyBoardEvent>
<DelayEvent>110</DelayEvent>
<KeyBoardEvent Down="true">28</KeyBoardEvent>
<DelayEvent>110</DelayEvent>
<KeyBoardEvent Down="false">28</KeyBoardEvent>
<DelayEvent>110</DelayEvent>
<KeyBoardEvent Down="true">57424</KeyBoardEvent>
<DelayEvent>110</DelayEvent>
<KeyBoardEvent Down="false">57424</KeyBoardEvent>
<DelayEvent>110</DelayEvent>
<KeyBoardEvent Down="true">56</KeyBoardEvent>
<DelayEvent>110</DelayEvent>
<KeyBoardEvent Down="true">15</KeyBoardEvent>
<DelayEvent>110</DelayEvent>
<KeyBoardEvent Down="false">15</KeyBoardEvent>
<DelayEvent>110</DelayEvent>
<KeyBoardEvent Down="false">56</KeyBoardEvent>
<DelayEvent>110</DelayEvent>
<KeyBoardEvent Down="true">57415</KeyBoardEvent>
<DelayEvent>110</DelayEvent>
<KeyBoardEvent Down="false">57415</KeyBoardEvent>
<DelayEvent>110</DelayEvent>
<KeyBoardEvent Down="true">29</KeyBoardEvent>
<DelayEvent>110</DelayEvent>
<KeyBoardEvent Down="true">46</KeyBoardEvent>
<DelayEvent>110</DelayEvent>
<KeyBoardEvent Down="false">46</KeyBoardEvent>
<DelayEvent>110</DelayEvent>
<KeyBoardEvent Down="false">29</KeyBoardEvent>
<DelayEvent>110</DelayEvent>
<KeyBoardEvent Down="true">56</KeyBoardEvent>
<DelayEvent>110</DelayEvent>
<KeyBoardEvent Down="true">15</KeyBoardEvent>
<DelayEvent>110</DelayEvent>
<KeyBoardEvent Down="false">15</KeyBoardEvent>
<DelayEvent>110</DelayEvent>
<KeyBoardEvent Down="false">56</KeyBoardEvent>
<DelayEvent>110</DelayEvent>
<KeyBoardEvent Down="true">29</KeyBoardEvent>
<DelayEvent>110</DelayEvent>
<KeyBoardEvent Down="true">47</KeyBoardEvent>
<DelayEvent>110</DelayEvent>
<KeyBoardEvent Down="false">47</KeyBoardEvent>
<DelayEvent>110</DelayEvent>
<KeyBoardEvent Down="false">29</KeyBoardEvent>
<DelayEvent>110</DelayEvent>
<KeyBoardEvent Down="true">28</KeyBoardEvent>
<DelayEvent>110</DelayEvent>
<KeyBoardEvent Down="false">28</KeyBoardEvent>
<DelayEvent>110</DelayEvent>
<KeyBoardEvent Down="true">57424</KeyBoardEvent>
<DelayEvent>110</DelayEvent>
<KeyBoardEvent Down="false">57424</KeyBoardEvent>
<DelayEvent>110</DelayEvent>
<KeyBoardEvent Down="true">57424</KeyBoardEvent>
<DelayEvent>110</DelayEvent>
<KeyBoardEvent Down="false">57424</KeyBoardEvent>
<DelayEvent>110</DelayEvent>
<KeyBoardEvent Down="true">56</KeyBoardEvent>
<DelayEvent>110</DelayEvent>
<KeyBoardEvent Down="true">15</KeyBoardEvent>
<DelayEvent>110</DelayEvent>
<KeyBoardEvent Down="false">15</KeyBoardEvent>
<DelayEvent>110</DelayEvent>
<KeyBoardEvent Down="false">56</KeyBoardEvent>
<DelayEvent>110</DelayEvent>
<KeyBoardEvent Down="true">57416</KeyBoardEvent>
<DelayEvent>110</DelayEvent>
<KeyBoardEvent Down="false">57416</KeyBoardEvent>
<DelayEvent>110</DelayEvent>
<KeyBoardEvent Down="true">57423</KeyBoardEvent>
<DelayEvent>110</DelayEvent>
<KeyBoardEvent Down="false">57423</KeyBoardEvent>
<DelayEvent>110</DelayEvent>
<KeyBoardEvent Down="true">57421</KeyBoardEvent>
<DelayEvent>110</DelayEvent>
<KeyBoardEvent Down="false">57421</KeyBoardEvent>
<DelayEvent>110</DelayEvent>
<KeyBoardEvent Down="true">57419</KeyBoardEvent>
<DelayEvent>110</DelayEvent>
<KeyBoardEvent Down="false">57419</KeyBoardEvent>
<DelayEvent>110</DelayEvent>
<KeyBoardEvent Down="true">29</KeyBoardEvent>
<DelayEvent>110</DelayEvent>
<KeyBoardEvent Down="true">46</KeyBoardEvent>
<DelayEvent>110</DelayEvent>
<KeyBoardEvent Down="false">46</KeyBoardEvent>
<DelayEvent>110</DelayEvent>
<KeyBoardEvent Down="false">29</KeyBoardEvent>
<DelayEvent>110</DelayEvent>
<KeyBoardEvent Down="true">56</KeyBoardEvent>
<DelayEvent>110</DelayEvent>
<KeyBoardEvent Down="true">15</KeyBoardEvent>
<DelayEvent>110</DelayEvent>
<KeyBoardEvent Down="false">15</KeyBoardEvent>
<DelayEvent>110</DelayEvent>
<KeyBoardEvent Down="false">56</KeyBoardEvent>
<DelayEvent>110</DelayEvent>
<KeyBoardEvent Down="true">29</KeyBoardEvent>
<DelayEvent>110</DelayEvent>
<KeyBoardEvent Down="true">47</KeyBoardEvent>
<DelayEvent>110</DelayEvent>
<KeyBoardEvent Down="false">47</KeyBoardEvent>
<DelayEvent>110</DelayEvent>
<KeyBoardEvent Down="false">29</KeyBoardEvent>
<DelayEvent>110</DelayEvent>
<KeyBoardEvent Down="true">28</KeyBoardEvent>
<DelayEvent>110</DelayEvent>
<KeyBoardEvent Down="false">28</KeyBoardEvent>
<DelayEvent>110</DelayEvent>
<KeyBoardEvent Down="true">57424</KeyBoardEvent>
<DelayEvent>110</DelayEvent>
<KeyBoardEvent Down="false">57424</KeyBoardEvent>
<DelayEvent>110</DelayEvent>
<KeyBoardEvent Down="true">56</KeyBoardEvent>
<DelayEvent>110</DelayEvent>
<KeyBoardEvent Down="true">15</KeyBoardEvent>
<DelayEvent>110</DelayEvent>
<KeyBoardEvent Down="false">15</KeyBoardEvent>
<DelayEvent>110</DelayEvent>
<KeyBoardEvent Down="false">56</KeyBoardEvent>
<DelayEvent>110</DelayEvent>
<KeyBoardEvent Down="true">57415</KeyBoardEvent>
<DelayEvent>110</DelayEvent>
<KeyBoardEvent Down="false">57415</KeyBoardEvent>
<DelayEvent>110</DelayEvent>
<KeyBoardEvent Down="true">29</KeyBoardEvent>
<DelayEvent>110</DelayEvent>
<KeyBoardEvent Down="true">46</KeyBoardEvent>
<DelayEvent>110</DelayEvent>
<KeyBoardEvent Down="false">46</KeyBoardEvent>
<DelayEvent>110</DelayEvent>
<KeyBoardEvent Down="false">29</KeyBoardEvent>
<DelayEvent>110</DelayEvent>
<KeyBoardEvent Down="true">56</KeyBoardEvent>
<DelayEvent>110</DelayEvent>
<KeyBoardEvent Down="true">15</KeyBoardEvent>
<DelayEvent>110</DelayEvent>
<KeyBoardEvent Down="false">15</KeyBoardEvent>
<DelayEvent>110</DelayEvent>
<KeyBoardEvent Down="false">56</KeyBoardEvent>
<DelayEvent>110</DelayEvent>
<KeyBoardEvent Down="true">29</KeyBoardEvent>
<DelayEvent>110</DelayEvent>
<KeyBoardEvent Down="true">47</KeyBoardEvent>
<DelayEvent>110</DelayEvent>
<KeyBoardEvent Down="false">47</KeyBoardEvent>
<DelayEvent>110</DelayEvent>
<KeyBoardEvent Down="false">29</KeyBoardEvent>
<DelayEvent>110</DelayEvent>
<KeyBoardEvent Down="true">28</KeyBoardEvent>
<DelayEvent>110</DelayEvent>
<KeyBoardEvent Down="false">28</KeyBoardEvent>
<DelayEvent>110</DelayEvent>
<KeyBoardEvent Down="true">15</KeyBoardEvent>
<DelayEvent>110</DelayEvent>
<KeyBoardEvent Down="false">15</KeyBoardEvent>
<DelayEvent>110</DelayEvent>
<KeyBoardEvent Down="true">15</KeyBoardEvent>
<DelayEvent>110</DelayEvent>
<KeyBoardEvent Down="false">15</KeyBoardEvent>
<DelayEvent>110</DelayEvent>
<KeyBoardEvent Down="true">15</KeyBoardEvent>
<DelayEvent>110</DelayEvent>
<KeyBoardEvent Down="false">15</KeyBoardEvent>
<DelayEvent>110</DelayEvent>
<KeyBoardEvent Down="true">15</KeyBoardEvent>
<DelayEvent>110</DelayEvent>
<KeyBoardEvent Down="false">15</KeyBoardEvent>
<DelayEvent>110</DelayEvent>
<KeyBoardEvent Down="true">28</KeyBoardEvent>
<DelayEvent>110</DelayEvent>
<KeyBoardEvent Down="false">28</KeyBoardEvent>
<DelayEvent>110</DelayEvent>
<KeyBoardEvent Down="true">56</KeyBoardEvent>
<DelayEvent>110</DelayEvent>
<KeyBoardEvent Down="true">15</KeyBoardEvent>
<DelayEvent>110</DelayEvent>
<KeyBoardEvent Down="false">15</KeyBoardEvent>
<DelayEvent>110</DelayEvent>
<KeyBoardEvent Down="false">56</KeyBoardEvent>
<DelayEvent>110</DelayEvent>
<KeyBoardEvent Down="true">57416</KeyBoardEvent>
<DelayEvent>110</DelayEvent>
<KeyBoardEvent Down="false">57416</KeyBoardEvent>
<DelayEvent>110</DelayEvent>
<KeyBoardEvent Down="true">57423</KeyBoardEvent>
<DelayEvent>110</DelayEvent>
<KeyBoardEvent Down="false">57423</KeyBoardEvent>
<DelayEvent>110</DelayEvent>
<KeyBoardEvent Down="true">57421</KeyBoardEvent>
<DelayEvent>110</DelayEvent>
<KeyBoardEvent Down="false">57421</KeyBoardEvent>
<DelayEvent>110</DelayEvent>
<KeyBoardEvent Down="true">57419</KeyBoardEvent>
<DelayEvent>110</DelayEvent>
<KeyBoardEvent Down="false">57419</KeyBoardEvent>
</Macro>
First, have a spreadsheet with O,H,L,C data window opened
Then a marketscope chart window opened
This macro will copy the last row, alt+tab , insert indicator (most recent), add the time, then alt+tab, copy date, alt+tab to insert date... etc.
However this is still slow with a lot of lines to add, and doesn't address the issue I described (in case data isn't visible on chart because it's older than what's availalbe to see, for example, the first point is in year 2012).
I think the normal "line" objects that can be added to the chart by pressing L don't have this issue as this indicator. But it is impossible to "paste" data into the "position" tab into their parameters, only type it or choose from calendar dates. So my macro wouldn't work. I just want a way to draw the lines on two points I need (date/time). I have requested for this in this topic. viewtopic.php?f=27&t=64066