Clear Filters
Clear Filters

Extract first trading days of the month

2 views (last 30 days)
Hi! So I need to extract the trading data of the first day of the month but I don't know how to do it because some months start at day 4 and compare one day with the following one (when decreasing 31st to 1st) we reach a new month
what I had was
days_3 = data(((days>=1) & (days>28)),4)
I know it's not correct cause its just giving trading rates of days 29 30 31 of some months

Answers (1)

Stephen Jue
Stephen Jue on 21 Jun 2017
What you can do instead is:
days_3 = data((days-[100; days(1:end-1)])<0,4)
This checks the difference between each successive value. When the value decreases, it signifies the start of a new month.

Tags

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!