Reply To: Importing Excel data into Optuma charts?

Optuma Forums Optuma General Discussion Importing Excel data into Optuma charts? Reply To: Importing Excel data into Optuma charts?

#60097
AvatarFrancesco
  • Topics: 1
  • Replies: 3
  • Posts: 4

Hi Francesco,

I’ve not done it, but the approach I’d take is to create a CSV file with five columns, the first with the date, then in each row the P/L figure for that day in the four columns for that date’s row, so the data set in csv format would look like:

21-09-2020, 1051,1051,1051,1051
22-9-2020,1065,1065,1065,1065
23-9-2020,750,750,750,750
24-9-2020, 820,820,820,820
25-9-2020, 83,835,835,835

Bad day on the 23rd☹

If you import that data into Optuma it can be charted as a line chart (or candles or bars, but then they’ll end up as an “unconnected” stepped line).

The columns are essentially in the form Date, Open, High, Low, Close which is acceptable to Optuma, so then you can apply any of Optuma’s tools to the resulting chart.

Cheers

Trevor

Thanks, Trevor!

It makes perfect sense…

🙂

Pin It on Pinterest

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

Close