Python Forum
How would I process this data?
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
How would I process this data?
#1
I have some trading data that I would like to process from a csv file.

What I am trying to do is find trading zones that move 1% or more in price. So if the price moves more than 1% to find the peak (or trough) which the next movement must be a 1% or more reversal in the opposite direction.

For example: the data would start processing and find a 1.5% upward movement. This would be the first trading zone with the final price being the peak. After that it finds a 1.2% downward movement which would be the next trading zone with the final price being the trough.

Even though it is very easy to find price movements over 1% but it's harder to find the peak of that movement because of the 1% or greater reversal stipulation. Let's say the price moves up 1.2% but then goes down 0.5% before moving back up to 1.5% This is proving much harder for me because the peak is 1.5% not 1.2%

How would I approach such a task?
Reply
#2
You might find what you're looking for in this (pricey) book.
O'Reilly -- Python for Finance, 2nd Edition

Also here are some links to packages that might be useful:
Reply
#3
Thanks for those resources, I'm sure they will be helpful in the future.

However, this problem can be solved without any form of financial understanding. Last night I was thinking I could process the data for cumulative moves and then remove all the cumulative moves that aren't 1% or above?
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  How should I process this data? SuchUmami 2 397 Jan-13-2024, 05:30 PM
Last Post: RockBlok
  Reading data from excel file –> process it >>then write to another excel output file Jennifer_Jone 0 1,116 Mar-14-2023, 07:59 PM
Last Post: Jennifer_Jone
  Process Data from one csv file and write to another CSV file specific column ajin9581 1 2,010 Jun-17-2020, 06:00 PM
Last Post: buran
  How to sharing object between multiple process from main process using Pipe Subrata 1 3,679 Sep-03-2019, 09:49 PM
Last Post: woooee
  Receive data from Redis RQ worker process freak14 0 1,907 Jul-15-2019, 12:39 PM
Last Post: freak14
  Avoid output buffering when redirecting large data (40KB) to another process Ramphic 3 3,418 Mar-10-2018, 04:49 AM
Last Post: Larz60+
  Automating a Data Extraction Process Harrison 12 8,677 Mar-31-2017, 10:44 AM
Last Post: Harrison

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020