There is no equivalent Airtable formula. In Airtable you would filer the View to only show records on a particular date or of a particular ticker.
I have a feeling you’re going to run into Airtable limits no matter which way you tackle your particular usecase. Are you tracking every Ticker in the NYSE? That’s 7,754 rows.
Either you’re going to run out of fields in your current setup (up to 500 per table, so less than 2 years worth of data), or you’re going to run out of records in the standard Airtable setup which would require you to have a junction table where each row is linked to 1 date and 1 ticker (7,754 records added per day, and the limit per table is 50,000 on Pro accounts).
There is no equivalent Airtable formula. In Airtable you would filer the View to only show records on a particular date or of a particular ticker.
I have a feeling you’re going to run into Airtable limits no matter which way you tackle your particular usecase. Are you tracking every Ticker in the NYSE? That’s 7,754 rows.
Either you’re going to run out of fields in your current setup (up to 500 per table, so less than 2 years worth of data), or you’re going to run out of records in the standard Airtable setup which would require you to have a junction table where each row is linked to 1 date and 1 ticker (7,754 records added per day, and the limit per table is 50,000 on Pro accounts).
Thanks for the response. Your last points won’t be an issue - as it’s not every ticker and it’s only ever a year of data. I wouldn’t hit the limits.
Maybe the data would best be put into a standard SQL database that’s more manipulatable?