![]() ![]() ![]() ![]() Auto-Refresh Tableau Public data from Google Sheets While it’s mainly designed for static snapshots of data, you can set it up to refresh automatically when connected to Google Sheets.Īll you need to do is to make sure you have this option checked when saving to Tableau Public: “Keep my data in sync with the data source and embed my credentials”. You can download it from here and go to town. Hold on, did I mention you can do this for free? But Tableau is a paid software. It’s important to type the ticker correctly because that’s the column used in the function that downloads the data. To fill it with your own stocks all you need to do is to write the company I created a template you can grab from here. And it gets refreshed automatically every 5 minutes. You don’t need any API key, authentication, add-on, etc. It’s based on the GOOGLEFINANCE function which communicates with the respective service. Here’s how the data looks in Google Sheets: Stock Data Google Sheets In this blog post I am going to show you how I created my own watchlist in Tableau, and how you can “steal” it from me to fill it with your own data, for free. It’s integration with Google Finance makes it the perfect solution for the average user looking for a quick way to grab stock data. Google Sheets is a powerful spreadsheet application that can be used to store data online and keep it fresh. You can customize the visualizations to give them a unique look and feel based on your own unique tase. It allows you to mix, match, and explore data from multiple sources in ways that can help you uncover insights and trends. Tableau is a data visualization software that allows you to make interactive charts, graphs, and dashboards using data from all kinds of sources. Are you into investing? Or maybe curious about how a part of the stock market is doing? An interactive stock dashboard might be the ideal project for you. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |