- This topic has 6 replies, 3 voices, and was last updated 1 year ago by .
Viewing 7 posts - 1 through 7 (of 7 total)
Viewing 7 posts - 1 through 7 (of 7 total)
- You must be logged in to reply to this topic.
Optuma Forums › Optuma General Discussion › Imported CSV data does not display correctly in charts
Tagged: csv import
Hi,
I have a .csv file of the monthly Shiller CAPE Ratio data doing back to 1905. I can import the file, but when I create the chart, it displays yearly instead of the monthly data. Selecting a monthly time frame on the chart does not display the data correctly – it still defaults to yearly. I have included the Excel csv file that I imported.
Can Optuma read this monthly data and display it on a chart, or do I need to format the data differently?
Thanks – Paul
One last questions – is there a limit to the historical data that can be imported into Optuma? Thanks again – Paul
Hi Paul,
Looking at the CSV file the dates aren’t using the same format for all rows (Excel tends to remove extra zeros from dates when the file is first opened). You need to adjust the date format to be the same across all rows to mm/dd/yyyy.
Once that is done save the csv file and import / open it into Optuma. When asked to setup the Text File Properties use the following:
When i did this on my system the file imported correctly and i was able to display the chart using a 1 month time frame:
For more information on how to format and import CSV files please refer to the following article: https://help.optuma.com/kb/faq.php?id=672
With regards to your second query, there’s no limit on the amount of historical data you can import, however please note that dates before 01-01-1900 in Excel aren’t always picked up as valid dates, so formatting can be tricky.
As always thanks for your quick response and you help – Paul
Hello sirs
I have file that I setting up with this article format
https://help.optuma.com/kb/faq.php?id=672
I don’t know why didn’t work
Hi,
There are several entries at the end of the CSV file which are missing a Date / Time value, that is why the CSV is not displaying correctly when imported into Optuma.
You will need to delete these rows or fill in the missing Date / Time information.
thank you Matthew
Cookie | Duration | Description |
---|---|---|
cname | 14 days | This cookie is set by Optuma. The cookies is used to store the users campaign selection for selecting the correct version of Optuma to trial and is "Necessary". |
cookielawinfo-checbox-analytics | 11 months | This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Analytics". |
cookielawinfo-checbox-functional | 11 months | The cookie is set by GDPR cookie consent to record the user consent for the cookies in the category "Functional". |
cookielawinfo-checbox-others | 11 months | This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Other. |
cookielawinfo-checkbox-necessary | 11 months | This cookie is set by GDPR Cookie Consent plugin. The cookies is used to store the user consent for the cookies in the category "Necessary". |
cookielawinfo-checkbox-performance | 11 months | This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Performance". |
viewed_cookie_policy | 11 months | The cookie is set by the GDPR Cookie Consent plugin and is used to store whether or not user has consented to the use of cookies. It does not store any personal data. |