hlc | Hybrid Logical Clock implementation in JavaScript | Frontend Framework library

So I have a form that executes a VBA script via a macro. The purpose of said script is to open Excel, create a new workbook, gather information from several tables and export them to a formatted spreadsheet. Each person has a sheet with their name, and the relevant data is printed in said sheet. It works perfectly for the most part. Only one problem... The table in Access where the name and demographics data is gathered from is formatted to sort by last name ascending alphabetically. The VBA script exports it in the order the names were entered. I want my VBA script to respect the formatting in the database table, and I would prefer not to have to add an alphabetizing subroutine to my VBA script.

Table A Format: ID, Active, Last, First, Role, Traveler, Resident, Preceptee, Phone, Completion

Table B Format: ID, Course, Course ID, Offered, HLC, Course Type

Last in Table A called "Roster" is the field with which I want my VBA script to sort alphabetically. The database is already configured to do this.

Thanks in advance!

VBA Code:

Overview

I am trying to use this Python Zig Zag candlestick indicator (utilises High,Low,Close values) on financial data but the code below appears to have a bug.

Any help fixing this is appreciated or if there is another working Python module that provides this functionality please advise.

What is a Zig Zag indicator

"The Zig Zag indicator plots points on the chart whenever prices reverse by a percentage greater than a pre-chosen variable." Source

What have I tried

While searching for a Python zigzag indicator for candlestick charts the only code I could find was from this pull request.

I'm trying to get the daily High/Low/Close with a security() call (with lookahead_on).
Those daily hlc values remain unchanged for every intraday bar within the same day.
Therefore, I'm trying to call the security function only once per day (when the date changes).
However, I keep getting the error Cannot read property 'isTuple' of undefined.
I don't understand why, and cannot seem to get it fixed.
Any ideas?

This is my example code

I tried running my Machine Learning LinearRegression code, but it is not working. Here is the code:

This script works perfectly on every timeframe except 30min and 20min?

I get an error"Pine cannot determine the referencing length of a series"

Adding max_bars_back has no effect on this error...I have tried that and it doesn't fix the error

Wondering what could possibly be causing this?

I'm also trying to figure out how to show previous pivots, have a checkbox to show or hide them.

I have a date column with data from 1 year in a pandas dataframe with a 1 minute granularity:

I am writing the template for a parametrized HashiCorp Nomad job. One of its parameters is priority, which is supposed to be an integer between 0 and 100.

Like other tools, Nomad supports variable interpolation, so that a variable can be defined at some point and later referenced. Nomad also allows to define "meta" variables, which are passed at runtime and can be used within the HLC file.

What I'm trying to do looks as follows:

I am trying to convert a perl code to python for simple multiplications of columns by some constants. I've created a pandas dataframe with multiple columns of float values. Here is the example of the components.csv file.

I'm trying to parse and sum values from a jsonb field (eventos) in a postgresql table (eventos_detalle) that I'm getting from SPSS Statistics (ODBC GET DATA) The jsonb_to_record function is working but the ->> operator is causing a syntax error. I've quoted and double quoted everything I can but still can get it to work. Any comment will be very appreciated.

Here's the code exactly copied from SPSS Syntax Editor