Editing Data: Difference between revisions

Latest revision as of 14:46, 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

Selecting Data to Display

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.

On the Level 1 tab you can also choose the resolution (tick, minute, day) and quote field (Ask, Bid, Trade) to display.
The available options here will depend on types of data that you have in your database.

Adding New Data

Available for Level 1 data only

Click Add to add a new quote.
New quotes will be added to the end of the quote list.

Add adds a quote at the end of the quote list.
Insert – after the selected quote line.

Inserting New Data

Available for Level 1 data only

To insert a new quote:

Select a line after which you'd like to place a new one.
Click Insert.

Deleting Data

To delete quotes, select the necessary quote or quotes and click Delete.

Finding Data

To find the necessary quote or quotes:

Click Find… to open the Find and Goto window.
Go to the Find tab.
On the Find tab set
- Parameter to base the search on (Price, Volume)
- Condition of the search (between, equals to, less/greater than, etc.)
- Values to search for
To search quote by quote, click Find. The Find will change into Find Next.
To mark all the quotes corresponding to the selected conditions, press the Mark All button.
Click Close to close the Find and Goto window.

Going to Data

To go to the necessary quote:

Click Find… to open the Find and Goto window.
Go to the GoTo tab.
On the GoTo tab
- Set Line or DateTime to go to
- Enter the Line number or date and time
Click GoTo to go to the necessary quote.
Click Close to close the Find and Goto window.

Selecting All Quotes

Click Select All to select all the quotes.
It is a useful option when all the quotes should be deleted.

Copying Data

Select the necessary quotes and click Copy to copy the data to the clipboard.

@@ Line 1: / Line 1: @@
-This tool is necessary to review and edit data. It helps quickly find and correct the bad ticks as well as add or delete new data.
+In the '''Edit Data''' menu you can view and adjust data stored in your database.
-== Operating with Data ==
+To open the '''Edit Data''' menu:
-It is possible to modify data settings, add, insert, delete and find the necessary data. All these arrangements are performed in the '''Edit Data''' window.
+* Click the '''Edit Data''' button  <img src="https://www.multicharts.com/trading-software/images/9/94/Edit_Data.png" width="24">
+* Select a symbol and go to '''Edit → Edit Data'''
+* Right-click a symbol → Edit Data
-<br>
+== Selecting Data to Display ==
-== Accessing Edit Data Window ==
-There are 3 ways to access the '''Edit Data''' window:
-# In the '''Edit''' menu click '''Edit Data…'''
+You can switch between Level 1, Status Line and Level 2 tabs to display the corresponding type of stored data.
-# Right-click on the selected symbol and select '''Edit Data…'''
+<div class="tip-no-title">See [[Level 1 vs Level 2 Market Data]].</div>
-# Use the '''Ctrl+R''' combination of hotkeys.
-<br>
+At the top of the window you can see the Data Range available in your database.<br>
-== Modifying Data Settings ==
+You can click the '''Use the Data Range for Start/End interval''' button to display and view it.
-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.
+To display a specific time period, set '''Start''' and '''End''' dates manually.
-One can also specify the start date/time and the end date/time for the loaded data.
+On the Level 1 tab you can also choose the '''resolution''' (tick, minute, day) and '''quote field''' (Ask, Bid, Trade) to display.<br>
+The available options here will depend on types of data that you have in your database.
-When the data is loaded it is possible to change the data values.
-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:
+<div class="important-no-title">Available for Level 1 data only</div>
-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.
+Click '''Add''' to add a new quote.<br>
-<br><div style="background-color: #E3FBE5;">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.</div>
+New quotes will be added to the end of the quote list.
+<div class="note">'''Add''' adds a quote at the end of the quote list.<br>'''Insert''' – after the selected quote line.</div>
-<br>
 == Inserting New Data ==
+<div class="important-no-title">Available for Level 1 data only</div>
 To insert a new quote:
+# Select a line after which you'd like to place a new one.
+# Click '''Insert'''.
-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.
-<div style="background-color: #E3FBE5;">Note: Only in this case, the '''Insert''' button becomes active.</div>
-<br>
 == Deleting Data ==
-To delete a quote or several quotes:
+To delete quotes, select the necessary quote or quotes and click '''Delete'''.
-In the '''Data''' section select the necessary quote or quotes and press the '''Delete''' button.
-<br>
 == Finding Data ==
 To find the necessary quote or quotes:
-# Press the '''Find…''' button and the '''Find and Goto''' window will appear.
+# Click '''Find…''' to open the '''Find and Goto''' window.
-# Select the '''Find''' tab.
+# Go to 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 set
-# On the '''Find''' tab select from the 2nd drop-down list the necessary condition of the search.
+#* Parameter to base the search on (Price, Volume)
-# Enter in the field (s) the necessary number (or percent) corresponding to the selected condition.
+#* Condition of the search (between, equals to, less/greater than, etc.)
-# 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.
+#* Values to search for
+# To search quote by quote, click '''Find'''. The '''Find''' will change into '''Find Next'''.
 # 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.
+# Click '''Close''' to close the '''Find and Goto''' window.
-<br>
 == Going to Data ==
 To go to the necessary quote:
-# Press the '''Find…''' button and the '''Find and Goto''' window will appear.
+# Click '''Find…''' to open the '''Find and Goto''' window.
-# Select the '''GoTo''' tab.
+# Go to 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
-# On the '''GoTo''' tab in the 2nd field enter the necessary date or use the drop-down calendar.
+#* Set '''Line''' or '''DateTime''' to go to
-# On the '''GoTo''' tab enter the necessary time.<br><div style="background-color: #E3FBE5;">Note: The time field is available with the tick and minute resolutions only.</div>
+#* Enter the Line number or date and time
-# Press the '''GoTo''' button to go to the necessary quote.
+# Click '''GoTo''' to go to the necessary quote.
-# Press the '''Close''' button to close the '''Find and Goto''' window.
+# Click '''Close''' to close the '''Find and Goto''' window.
-<br>
 == Selecting All Quotes ==
-Press the '''Select All''' button to mark all the quotes.
+Click '''Select All''' to select all the quotes.<br>
+It is a useful option when all the quotes should be deleted.
-It is useful when all the quotes should be deleted.
-<br>
+== Copying Data ==
+Select the necessary quotes and click '''Copy''' to copy the data to the clipboard.
 [[Category: Managing Data]]