=RTD("gartle.rtd","GoogleFinanceOptions","rtd_LastUpdateDate") =RTD("gartle.rtd","GoogleFinanceOptions","rtd_LastUpdate") =RTD("gartle.rtd","GoogleFinanceOptions","rtd_LastMessage") =RTD("gartle.rtd","GoogleFinanceOptions","rtd_LastError") =RTD("gartle.rtd","GoogleFinanceOptions","Strike-1") =RTD("gartle.rtd","GoogleFinanceOptions","Strike+1") =RTD("gartle.rtd","GoogleFinanceOptions","Strike-0") =RTD("gartle.rtd","GoogleFinanceOptions","Strike+0") =RTD("gartle.rtd","GoogleFinanceOptions","Strike~0") =RTD("gartle.rtd","GoogleFinanceOptions","OpenInt") =RTD("gartle.rtd","GoogleFinanceOptions","Volume") =RTD("gartle.rtd","GoogleFinanceOptions","Ask") =RTD("gartle.rtd","GoogleFinanceOptions","Bid") =RTD("gartle.rtd","GoogleFinanceOptions","Mark") =RTD("gartle.rtd","GoogleFinanceOptions","PercentChange") =RTD("gartle.rtd","GoogleFinanceOptions","ChangePercent") =RTD("gartle.rtd","GoogleFinanceOptions","ChangeInPercent") =RTD("gartle.rtd","GoogleFinanceOptions","Change") =RTD("gartle.rtd","GoogleFinanceOptions","Last") =RTD("gartle.rtd","GoogleFinanceOptions","Symbol") =RTD("gartle.rtd","GoogleFinanceOptions","OptionCode") =RTD("gartle.rtd","GoogleFinanceOptions","rtd_LastUpdateTime")įormulas for getting data by option contract specifications: =RTD("gartle.rtd","GoogleFinanceOptions","Type") =RTD("gartle.rtd","GoogleFinanceOptions","Strike") =RTD("gartle.rtd","GoogleFinanceOptions","Exp") =RTD("gartle.rtd","GoogleFinanceOptions","OptionSymbol") Data Fields and Excel Formulasįormulas for getting data by option codes: This feature significantly reduces the amount of requests to the Google website. RealTimeToExcel loads one page to get the data for all options of the one expiration date. Otherwise, your IP can be banned by the Google website. =RTD("gartle.rtd","GoogleFinanceOptions","YHOO", "JAN20'17", 50, "P","OpenInt")ĭata is available for US exchanges and can be not available for other world's exchanges.ĭo not request the Google website frequently. =RTD("gartle.rtd","GoogleFinanceOptions",".YHOO170120C50.0","OpenInt") (Thinkorswim format)Įxcel formula for using option specifications: =RTD("gartle.rtd","GoogleFinanceOptions","","","")Įxamples: =RTD("gartle.rtd","GoogleFinanceOptions","YHOO", "170120", 50, "CALL","OpenInt") Strike as is with or without decimal part (common strike format)Įxamples: =RTD("gartle.rtd","GoogleFinanceOptions","YHOO170120C00050000","OpenInt") Strike format: 8 digits with leading zero as strike * 1000 (Google Finance format)ħ digits with leading zero as strike * 100Ħ digits with leading zero as strike * 10 Excel formula for using option codes: =RTD("gartle.rtd","GoogleFinanceOptions","","")
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |