It may also include other information such as volume traded, bid and offer sizes and static data about the financial instrument that may have come from a variety of sources.There are a number of financial data vendors that specialise in collecting, cleaning, collating and distributing market data and this has become the most common way that traders and investors get access to market data.
https:// can be used in combination with our CSV integration.
Real-time feeds provide data for all trading activity on the CSE: CSE listed and other listed securities.
For example, if you have a paid G-suite account your script can run for up to 6 hours a day, however, if you have a free account, scripts will only run for up to 90 minutes per day.
For more information please visit Google's official documentation.
This isn't particularly helpful so we've written a script that you can adapt to update the market data every minute, even when the Google Sheet is closed.
Now that you've written the script and set the trigger running, you'll be able to see the data on your Google Sheet refresh every hour.Google Sheets has a built-in function called GOOGLEFINANCE which fetches current or historical securities information from Google Finance to a Google Sheet.This article details how this function can be used with our Spreadsheets integration to display market data on your Geckoboard dashboard.This function doesn't update on its own by default so we've written a script that you can adapt to ensure your data is kept up to date.Our Google's stock price example show the basics of using this function and don't use this script.The feed also contains bulletins, market summaries and statistics.