# Formatting FinancialData\[ \] output?

**URL:** <https://community.wolfram.com/t/formatting-financialdata-output/18790>\
**Category:** Questions\
**Tags:** finance, curated-data\
**Created:** [September 2, 2021, 9:43pm UTC](https://community.wolfram.com/t/formatting-financialdata-output/18790 "2021-09-02T21:43:50Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![raymondlow](https://avatars.discourse-cdn.com/v4/letter/r/67e7ee/32.png) [@raymondlow](https://community.wolfram.com/u/raymondlow)\
**Post date:** [September 2, 2021, 9:43pm UTC](https://community.wolfram.com/t/formatting-financialdata-output/18790/1 "2021-09-02T21:43:50Z")

</div>

Having problems with “Parts” seems to work differently with FinancialData

```
In[291]:= Flatten@FinancialData["aapl", {2021, 8, 20}][[2]] // Normal

Out[291]= {Quantity[148.19000244140625`, "USDollars"], 
 Quantity[149.7100067138672, "USDollars"], 
 Quantity[149.6199951171875, "USDollars"], 
 Quantity[148.36000061035156`, "USDollars"], 
 Quantity[147.5399932861328, "USDollars"], 
 Quantity[148.60000610351562`, "USDollars"], 
 Quantity[153.1199951171875, "USDollars"], 
 Quantity[151.8300018310547, "USDollars"], 
 Quantity[152.50999450683594`, "USDollars"], 
 TemporalData`UniformTimeSpecification[{3838406400, 3838665600, 
   3838752000, 3838838400, 3838924800, 3839011200, 3839270400, 
   3839356800, 3839443200}], 1, "Continuous", 1, "Discrete", 1, 1, 
 ValueDimensions -> 1, DateFunction -> Automatic, 
 ResamplingMethod -> {"Interpolation", InterpolationOrder -> 1}, 
 TemporalRegularity -> True} 

```

How do I get rid of the stuff at the end of the list??  
and if possible how to get rid of the Quantity US Dollars??

I tried Method-\>“Legacy” , but ended up with worst results.

Thanks for any help..

---

<div class="post-metadata">

**Author:** ![rohitnamjoshi](https://avatars.discourse-cdn.com/v4/letter/r/f1d935/32.png) [@rohitnamjoshi](https://community.wolfram.com/u/rohitnamjoshi)\
**Post date:** [September 2, 2021, 10:14pm UTC](https://community.wolfram.com/t/formatting-financialdata-output/18790/2 "2021-09-02T22:14:57Z")

</div>

Hi Raymond,

Something like this?

```
data = FinancialData["AAPL", {2021, 8, 20}];

(* Using Pattern replacement *)
data["DatePath"] /. {d_, p_} :> {d, QuantityMagnitude@p}

(* Using MapAt *)
data["DatePath"] // MapAt[QuantityMagnitude, #, {All, 2}] &

```

or

```
data["Values"] // QuantityMagnitude

```

---

<div class="post-metadata">

**Author:** ![raymondlow](https://avatars.discourse-cdn.com/v4/letter/r/67e7ee/32.png) [@raymondlow](https://community.wolfram.com/u/raymondlow)\
**Post date:** [September 2, 2021, 11:39pm UTC](https://community.wolfram.com/t/formatting-financialdata-output/18790/3 "2021-09-02T23:39:51Z")

</div>

Thanks Rohit – yes, that worked very well.