# How to Use the Valuations Screen

The **Valuations** screen in Molecule provides a way to create and save customized views for portfolio reporting, allowing users to tailor their data views of their positions and P\&L. This data can be transformed into a customized view through selection, grouping, pivoting, sorting, filtering, and aggregation. You can create and save multiple views, complete with a full selection of preferences available every time you visit our app.

This article focuses on creating, filtering, exporting and management of custom views.

<mark style="background-color:yellow;">The</mark> <mark style="background-color:yellow;"></mark><mark style="background-color:yellow;">**VALUATIONS**</mark> <mark style="background-color:yellow;"></mark><mark style="background-color:yellow;">screen is Molecule's in-app reporting tool powered by Molecule's REST API, documented</mark> [<mark style="background-color:yellow;">here</mark>](https://developer.molecule.io/password?redirect=/reference/valuations-1)<mark style="background-color:yellow;">.</mark>

#### Creating a View

First, go to the **VALUATIONS** screen on the left-hand side menu.

<div align="center"><figure><img src="https://files.helpdocs.io/56bu62syz9/articles/fmizawl4bp/1689265017411/file-r-t-625-p-6-h-4-a.png" alt="" width="375"><figcaption></figcaption></figure></div>

Then, click the **+** button to the right of any existing view tabs. Enter a name for the view in the text box, then press enter or the check mark.&#x20;

<div align="center"><figure><img src="https://files.helpdocs.io/56bu62syz9/articles/fmizawl4bp/1689265017705/file-qhf-tj-tc-7-xi.png" alt="" width="375"><figcaption></figcaption></figure></div>

<div align="center"><figure><img src="https://files.helpdocs.io/56bu62syz9/articles/fmizawl4bp/1689265017912/file-js-22-wg-iat-9.png" alt=""><figcaption></figcaption></figure></div>

Next, choose the columns your like to include by clicking the purple **COLUMNS** bar on the right side of the screen to expand the column options. You can choose the columns you'd like to include in your view by scrolling or using our search feature.

<div align="center"><figure><img src="https://files.helpdocs.io/56bu62syz9/articles/fmizawl4bp/1689265018197/file-c-ady-4-tq-ehw.png" alt="" width="375"><figcaption></figcaption></figure></div>

Your selections will save automatically. As you create multiple views, they are displayed in tabs on the page.

#### Refreshing a View

To refresh a view, press the refresh button towards the top of the **VALUATIONS** screen.

<div align="center"><figure><img src="https://files.helpdocs.io/56bu62syz9/articles/fmizawl4bp/1689265018430/file-uw-jflsf-2-nl.png" alt="" width="375"><figcaption></figcaption></figure></div>

Or, you can press on the date at the top right of the screen and update the reporting date.

<div align="center"><figure><img src="https://files.helpdocs.io/56bu62syz9/articles/fmizawl4bp/1689265018666/file-cwod-xnmb-7-x.png" alt="" width="375"><figcaption></figcaption></figure></div>

#### Cloning a View&#x20;

To clone a view, hover over active view and press the copy icon next to the pencil, as shown below:&#x20;

<figure><img src="https://files.helpdocs.io/56bu62syz9/articles/fmizawl4bp/1689265018936/file-4-av-2-n-4-xw-pd.png" alt=""><figcaption></figcaption></figure>

#### Renaming a View

To rename a view, hover over the active view and press the pencil icon next to the clone icon, as shown below. Type in the new name of your view, then press enter or the green check mark.&#x20;

<figure><img src="https://files.helpdocs.io/56bu62syz9/articles/fmizawl4bp/1689265019216/file-w-8-eyo-ms-0-sf.png" alt=""><figcaption></figcaption></figure>

#### Deleting a View

To delete a view before it's been saved, press the omit icon next to the check mark. To delete a view once it's been saved, hover on the active view box and press the **x.**

<figure><img src="https://files.helpdocs.io/56bu62syz9/articles/fmizawl4bp/1689265019461/file-m-4-q-1-jh-j-4-r-3.png" alt=""><figcaption></figcaption></figure>

<figure><img src="https://files.helpdocs.io/56bu62syz9/articles/fmizawl4bp/1689265019695/file-iobg-uv-gsu-u.png" alt=""><figcaption></figcaption></figure>

#### Exporting View Rows

**Select Rows -** You can export selected rows by checking the boxes of the rows you'd like to export on the far left of the table. Once you've selected the rows you'd like to export, press the **EXPORT SELECTED ROWS** in the top right-hand corner.

<figure><img src="https://files.helpdocs.io/56bu62syz9/articles/fmizawl4bp/1689265019931/file-h-y-2-ya-hxr-vu.png" alt=""><figcaption></figcaption></figure>

<figure><img src="https://files.helpdocs.io/56bu62syz9/articles/fmizawl4bp/1689265020195/file-me-ozp-mq-arf.png" alt=""><figcaption></figcaption></figure>

**All Rows:** To export all rows, you can check the box next to the **M.ID** column and then select **EXPORT SELECTED ROWS**, as shown above. Or, you don't have to check any boxes and can just select **EXPORT ALL ROWS** in the top right of the screen.

<figure><img src="https://files.helpdocs.io/56bu62syz9/articles/fmizawl4bp/1689265020405/file-a-j-1-w-9-lx-63-q.png" alt=""><figcaption></figcaption></figure>

<figure><img src="https://files.helpdocs.io/56bu62syz9/articles/fmizawl4bp/1689265020689/file-icpj-byxe-fv.png" alt=""><figcaption></figcaption></figure>

Rows will be exported in an Excel spreadsheet.

That's it! We hope this will save you some time. If you have any questions, please let us know at <support@molecule.io>.

See related: [How to Pivot and Group on the Valuations Screen](https://help.molecule.io/core-functionality/core-features/specialized-features/trades/valuations-screen/how-to-pivot-and-group-on-the-valuations-screen)
