XM Instructions
Procedure
Step 1) Go to Páginas - Precios en contratos por tipo de mercado (xm.com.co)
IMPORTANT! ALL IMAGES ARE EXAMPLES AND THE REAL DATA SHOULD BE DIFFERENT FROM BELOW
Step 2) In Fecha (or "Date" in english version), input the date ("DD/MM/YYYY") that the collection is being taken in the right box and in the left box, input the date ("01/MM/YYYY") of the first day of the sixth month prior to the collection date*
*for example, if the collection is been taken in 28/07/2021, the first day of the sixth month prior to would be 01/01/2021.
Step 3) Click on "Diaria" button.
Step 4) Click on the chart to permanently enable the Chart Options:
Step 5) Click on the tree dots button ("...") and on the Exportar datos ("Export data" in english version) and then click on Exportar
Step 6) Open the downloaded file (the file name must be 'data') and copy the data of the first 4 columns
Step 8) Paste at the red Cell: