Go to the control panel of your PC. Look for MarketXLS and click on Uninstall.
MarketXLS has an option in settings form which allows you to select where the data tables will be downloaded. Selection: This will make all downloaded data tables to be downloaded at one cell to the right and down of your active selection. Ask Me: This will ask you to select a cell where you want … Read moreData download location
Please use this code below to get Market data with MarketXLS API. Sub Test() Dim objRequest As Object Dim strResponse As String Dim blnAsync As Boolean Set objRequest = CreateObject(“WinHttp.WinHttpRequest.5.1”) blnAsync = True With objRequest .Open “GET”, “https://api.marketxls.com/historical-prices/MSFT/2011-01-01/2017-01-01/daily/ohlcv“, blnAsync .setRequestHeader “x-api-key”, “Enter your Key here” .send .WaitForResponse strResponse = .responseText Debug.Print strResponse Debug.Print .Status End … Read moreknowledge-base How to use VBA to call MarketXlS Api in Excel for stock data
Using the Earnings by Date lookup feature of MarketXLS, you can easily lookup stocks with earnings by date, that is, stocks that declared their earnings or will be declaring earnings on a particular date. The feature is specially useful when you are planning to make a trade in the market on a particular date. With … Read moreLookup Stocks with Earnings by Date in Excel
This articles examples how can you find best monthly dividend paying stocks with MarketXLS.
Refresh All: If you are running the functions under individual mode, then Refresh all will simply recalculate all the formulas in Excel. That means all MarketXLS functions will recall API to get new data. In a Group Mode, this will get the loaded list symbols and call the API for all the data and store … Read moreRefresh All, Refresh Selected and Auto Refresh
Some data that MarketXLS gets does not change by the minute, so it make sense for such data to be cached. This should greatly increase the speed and usability of Excel files when using with MarketXLS. From the release version 184.108.40.206 the default installs of MarketXLS will have caching enabled. Quotes – Prices, last, ask, … Read moreCaching in MarketXLS