Last Friday of Month

12. Mai 2021

This script marks the last Friday of the month in a daily chart because this is the day when BTC and ETH options expire according to Deribit.
I only found a script that highlights the 3rd Friday of the month, which is not what I wanted.
This script tries to figure out the correct number of days per month but is not aware of holidays which might displace the expiry date.

13. Mai 2021

Versionshinweise

[Updated using a clean chart.]

This script tries to mark the last Friday of the month in the chart with a vertical line and/or a label.
It is meant for use on a daily BTC chart.

Price may tend toward a level known as the "max pain point" when options expire. See these articles:
coindesk.com/bitcoin-options-market-eyes-4-2b-expiry-on-friday
insights.deribit.com/education/maximum-pain-for-option-buyers-going-into-expiration/

Deribit is a place where you can trade BTC and ETH options. Monthly and quarterly options expiry
dates are relevant. From deribit.com/pages/information/Introduction_Policy:
Daily options expire every day at 08:00 UTC.
Weekly options expire on each Friday of each week at 08.00 UTC.
Monthly options expire on the last Friday of each calendar month at 08.00 UTC.
Quarterly options expire on the last Friday of each calendar quarter at 08.00 UTC.

23. Mai 2021

Versionshinweise

UPDATE: Now also shows the expiration Friday for the current month even if it lies in the future.

14. Aug. 2021

Versionshinweise

Added the URL where you can look up the max pain point in the comment.
(It is metrics.deribit.com/options?index=BTC)

26. Sept. 2021

Versionshinweise

• Fixed the logic for finding Fridays.
  
• No output if timeframe is different from 1 day.
  
• Extended the description in the header of the source code.
  

Apologies, dudes and dudesses. The previous version was pretty broken.
How hard can it be to find the Fridays? Well, pretty hard for me, it seems... :-)

21. Nov. 2021

Versionshinweise

Another bug fix for the future last Friday of the month (how embarrasing).
Added highlighting of past quadruple witching Fridays (future dates not working, yet).
Converted to Pine Script v5.

20. Aug. 2023

Versionshinweise

This is a complete rewrite that should solve all update problems.
Quadruple witching Fridays are now fully supported for the past and the future.
See also the updated documentation at the top of the script code.

Looking forward: I think it would be nice to receive an alert from this script some days before an upcoming special Friday. Let me know if you would find this useful.

22. Aug. 2023

Versionshinweise

Fix that makes the script work correctly with symbols that use a different time base (e.g. NIKKEI and NFTY).