[Solved] Importing CSV file from my Fidelity Account

Discuss the spreadsheet application

[Solved] Importing CSV file from my Fidelity Account

Postby realitybytez » Sat Apr 17, 2021 6:59 pm

Greetings all!

I have an account at Fidelity that allows me to download a CSV file of my portfolio. However the file shows dollar amounts in the format $xxx.xx and this makes the data unusable since Calc treats the data as a text string. Is there an easy way to convert the data to xxx.xx format (without the dollar sign) so I can actually do something with it? I have the same problem with the percentage entries, which already have a "%" tacked on the end.

Thank you in advance.
Last edited by Hagar Delest on Sat Apr 17, 2021 9:48 pm, edited 1 time in total.
Reason: tagged solved.
openoffice 4.1.6 on windows 8.1
realitybytez
 
Posts: 2
Joined: Sun Oct 11, 2020 12:59 am

Re: importing CSV file from my Fidelity Account

Postby RusselB » Sat Apr 17, 2021 7:10 pm

Welcome to the Forums.
When you import the csv file you'll get a text import dialog.
In that dialog there is a check box marked Detect Special Numbers.
This box, in OpenOffice, is unchecked by default. Simply check that box and your number concerns (both with the $ and the %) will be handled.
This is not a static change, so you'll have to do it each time you import the csv file.
In LibreOffice Calc this same box is checked by default.
OpenOffice 4.1.7, LibreOffice 7.0.1.2 on Windows 7 Pro, Ultimate & Windows 10 Home (2004)
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
User avatar
RusselB
Moderator
 
Posts: 6378
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON

Re: importing CSV file from my Fidelity Account

Postby Villeroy » Sat Apr 17, 2021 8:39 pm

RusselB wrote:This is not a static change, so you'll have to do it each time you import the csv file.

Luckily it is static, indeed.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
User avatar
Villeroy
Volunteer
 
Posts: 29570
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: importing CSV file from my Fidelity Account

Postby RusselB » Sat Apr 17, 2021 8:52 pm

If this setting is static, then the coding for it has changed since the last time I used it, though that is possible as the last time I used it was version 4.1.4
OpenOffice 4.1.7, LibreOffice 7.0.1.2 on Windows 7 Pro, Ultimate & Windows 10 Home (2004)
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
User avatar
RusselB
Moderator
 
Posts: 6378
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON

Re: importing CSV file from my Fidelity Account

Postby Villeroy » Sat Apr 17, 2021 9:17 pm

This is the entry in my registrymodifications.xcu which stores this option:
Code: Select all   Expand viewCollapse view
<item oor:path="/org.openoffice.Office.Calc/Dialogs/CSVImport">
<prop oor:name="DetectSpecialNumbers" oor:op="fuse">
<value>true</value>
</prop>
</item>
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
User avatar
Villeroy
Volunteer
 
Posts: 29570
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: importing CSV file from my Fidelity Account

Postby realitybytez » Sat Apr 17, 2021 9:19 pm

thank you for the quick reply. you've made my life a lot easier. :super:
openoffice 4.1.6 on windows 8.1
realitybytez
 
Posts: 2
Joined: Sun Oct 11, 2020 12:59 am

Re: [Solved] Importing CSV file from my Fidelity Account

Postby Villeroy » Sat Apr 17, 2021 10:03 pm

If you open the same file (or a similar one) again, is "Detect special numbers" checked or not?
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
User avatar
Villeroy
Volunteer
 
Posts: 29570
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: [Solved] Importing CSV file from my Fidelity Account

Postby peterj3527 » Sun Apr 18, 2021 12:04 pm

Hi
I am lloking for a template of the csv easy file 501 import file

Thanks
OpenOffice 3.1 on Windows Vista
peterj3527
 
Posts: 1
Joined: Sun Apr 18, 2021 11:59 am


Return to Calc

Who is online

Users browsing this forum: No registered users and 19 guests