Google sheets complains about my sheet trying to scrape too much data and won't load the data most of the time. Basically I want a sheet where I put in symbols and it will load name, dividend, expense, change YTD, segment, top holding, and 1,3,5 year return data. I don't need live data where it updates constantly, just a button to manually update is fine.
Power query is too complicated imo. I got the tables to load but I'm not sure how you format/pull specific cells into a sheet.
Is there a free service to build something like this or an API maybe that can provide this basic data about symbols? Google finance and excel don't provide expense or dividend data. Think or swim doesn't have these as column options.
Submitted August 09, 2022 at 02:57AM by naps1saps https://ift.tt/JBjYilK
