Editing Data: Difference between revisions

Revision as of 13:48, 6 June 2024

In the Edit Data menu you can view and adjust data stored in your database.

To open the Edit Data menu:

Click the Edit Data button
Select a symbol and go to Edit → Edit Data
Right-click a symbol → Edit Data

Modifying Data Settings

You can switch between Level 1, Status Line and Level 2 tabs to display the corresponding type of stored data.

At the top of the window you can see the Data Range available in your database.
You can click the Use the Data Range for Start/End interval button to display and view it.

To display a specific time period, set Start and End dates manually.

Adding New Data

To add a new quote:

In the Edit Data window press the Add button to add a new quote. Each new quote will be added to the end of the quote list.

Note: The difference between the Add and Insert buttons is that by pressing the Add button a quote is added to the end of the quote list and by pressing the Insert button - at the beginning of the quote list.

Inserting New Data

To insert a new quote:

At the beginning of the quote list press the Insert button in the Edit Data window.

If the distance between the quotes is more than minimal increment for the given resolution type, it is possible to insert a new quote between these quotes.

Note: Only in this case, the Insert button becomes active.

Deleting Data

To delete a quote or several quotes:

In the Data section select the necessary quote or quotes and press the Delete button.

Finding Data

To find the necessary quote or quotes:

Press the Find… button and the Find and Goto window will appear.
Select the Find tab.
On the Find tab select from the 1st drop-down list according to what value the necessary quote or quotes should be found.
On the Find tab select from the 2nd drop-down list the necessary condition of the search.
Enter in the field (s) the necessary number (or percent) corresponding to the selected condition.
To find quote by quote, press the Find button. The Find button will change in the Find Next button, if you want to find more than one quote with the selected conditions.
To mark all the quotes corresponding to the selected conditions, press the Mark All button.
Press the Close button to close the Find and Goto window.

Going to Data

To go to the necessary quote:

Press the Find… button and the Find and Goto window will appear.
Select the GoTo tab.
On the GoTo tab select from the 1st drop-down list according to what value the necessary quote should be found.
On the GoTo tab in the 2nd field enter the necessary date or use the drop-down calendar.
On the GoTo tab enter the necessary time.
Note: The time field is available with the tick and minute resolutions only.
Press the GoTo button to go to the necessary quote.
Press the Close button to close the Find and Goto window.

Selecting All Quotes

Press the Select All button to mark all the quotes.

It is useful when all the quotes should be deleted.

Copying Data

Since MultiCharts 12 beta 1 Edit Data window contains the Copy button. Mark the necessary quotes and press the Copy button in order to copy the data to the clipboard.

@@ Line 7: / Line 7: @@
 == Modifying Data Settings ==
-To load the data from the data storage one should define the data settings in the '''Edit Data''' window.
-It is possible to select the desired resolution type, field and time zone.
+You can switch between Level 1, Status Line and Level 2 tabs to display the corresponding type of stored data.
+<div class="tip-no-title">See [[Level 1 vs Level 2 Market Data]].</div>
-One can also specify the start date/time and the end date/time for the loaded data.
+At the top of the window you can see the Data Range available in your database.<br>
+You can click the '''Use the Data Range for Start/End interval''' button to display and view it.
-When the data is loaded it is possible to change the data values.
+To display a specific time period, set '''Start''' and '''End''' dates manually.
-To modify data settings:
-# In the '''Data Settings''' section, select the necessary resolution type from the '''Resolution''' drop-down list.
-# In the '''Data Settings''' section, select the necessary field from the '''Field''' drop-down list.<br><div style="background-color: #E3FBE5;">Note: In the field section only those fields are displayed for which the data is collected. </div>
-# In the '''Data Settings''' section, select the necessary time zone from the '''Time Zone''' drop-down list. 3 time zones are available: Local, GMT and Exchange.
-# In the '''Data Range''' section, enter the necessary date in the '''Start''' field or use the drop-down calendar. Then enter the necessary time.<br><div style="background-color: #E3FBE5;">Note: The time field is available with the tick and minute resolutions only.</div>
-# In the '''Data Range''' section, enter the necessary date in the '''End''' field or use the drop-down calendar. Then enter the necessary time.<br><div style="background-color: #E3FBE5;">Note: The time field is available with the tick and minute resolutions only.</div>
-# Press the '''Load''' button and the loaded data will be displayed in the '''Data''' section.<br><div style="background-color: #E3FBE5;">Note: For the quotes with the tick resolution there will be displayed the Date, Time, Price and Volume values. </div>
-<br><div style="background-color: #E3FBE5;">Note: For the quotes with the minute resolution there will be displayed the Date, Time, Open, High, Low, Close, Up Volume, Down Volume, Unchanged Volume, Total Volume, Up Ticks, Down Ticks, Unchanged Ticks and Total Ticks values.</div>
-<br><div style="background-color: #E3FBE5;">Note: For the quotes with the day resolution there will be displayed the Date, Time, Open, High, Low, Close, Up Volume, Down Volume, Unchanged Volume, Total Volume, Up Ticks, Down Ticks, Unchanged Ticks, Total Ticks and Open Interest values.</div>
-<br>
 == Adding New Data ==
 To add a new quote: