I have just started experimenting with the stocks pack, and it’s great!
When you use some of the formats like Stocks::Quotes(), what you get is a dropdown full of all kinds of useful info like sector, 52-week high, 52-week low, etc.
Is there any way to extract those individual pieces of data?
For instead, I would like to have a column for 52-week high, another column for 52-week low etc.
Is there a way to do this?
Many thanks, Gregg
All of those values should project out to their own columns with a formula.
Thank you so much, Ben!
@BenLee is there a way to adjust historic data from the stocks pack using a date control?
Valid values are “5y”,“2y”,“1y”,“ytd”,“6m”,“3m”,“1m”
That will give you the data for however far back you want to see, but I don’t think there is a way to say “show me 1 month from this start date to this end date”.
If you do need to filter it though to pull out various data items from that list, you can use a formula like this:
- “no” on using a Coda date control to filter
- “yes” on using a filter formula within the table
I updated the embedded doc [above]. Ben’s formula is the column that is highlighted in yellow