I am trying to import yahoo finance statistics data for a certain stock into google sheets but the table is not being recognized by the IMPORTHTML function.
Here's my formula: =INDEX(IMPORTHTML(CONCATENATE(""/key-statistics"),"TABLE",1)">finance.yahoo.com/.../key-statistics"),"TABLE",1), 6,2)
It does pull some data but it's not from the table I am trying to target. Looks like the table I am trying to target is more than just HTML, not sure if that has something to do with it. It's the very first table at the top of the page I am trying to target. Appian Stock Stats page in Yahoo Finance
How do I import the Price/Sales ratio specifically on that page?