[smf_addin] Digest Number 4479

EXCEL Stock Market Functions Add-in Group

2 Messages

Digest #4479

1a

Re: smfgetoptionstrikes returning blanks by "Randy Harmelink" rharmelink

2a

Re: Retrieve business breakdown table by lawrence.leesh

Messages

1a

Re: smfgetoptionstrikes returning blanks

Sat Feb 2, 2019 6:26 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

Unfortunately, as long as that is what IE is returning, there's nothing the
add-in can do...those are the only dates it can see. :(

Do you get different results if you use that URL in the actual IE browser?
What version of IE does this say you are using, when the URL used in IE:

http://www.pinlady.net/PluginDetect/IE/

On Sat, Feb 2, 2019 at 7:12 PM Peter Cook peterscottcook@... wrote:

>
> I see. I opened it with notepad and I see what look like three expiration
> dates:
>
> {"optionChain":{"result":[{"underlyingSymbol":"AAPL","expirationDates":[1561075200,1563494400,1579219200],"strikes":[],"hasMiniOptions":false,"quote";:{"language":"en-US","region":"US","quoteType":"EQUITY","quoteSourceName":"Delayed
> Quote","currency":"USD","epsTrailingTwelveMonths":12.121,"epsForward":13.33,"esgPopulated":false,"tradeable":true,"marketState":"CLOSED","sharesOutstanding":4729800192,"bookValue":24.925,"fiftyDayAverage":155.8203,"fiftyDayAverageChange":10.699707,"fiftyDayAverageChangePercent":0.068666965,"twoHundredDayAverage":194.54417,"twoHundredDayAverageChange":-28.02417,"twoHundredDayAverageChangePercent":-0.14405042,"marketCap":787606339584,"forwardPE":12.492124,"priceToBook":6.680843,"sourceInterval":15,"exchangeTimezoneName":"America/New_York","exchangeTimezoneShortName":"EST","gmtOffSetMilliseconds":-18000000,"shortName":"Apple
> Inc.","exchange":"NMS","averageDailyVolume10Day":35547925,"regularMarketPrice":166.52,"regularMarketTime":1549054801,"regularMarketChange":0.08000183,"regularMarketOpen":166.96,"regularMarketDayHigh":168.98,"regularMarketDayLow":165.93,"regularMarketVolume":32668138,"postMarketChangePercent":0.01801512,"postMarketTime":1549069187,"postMarketPrice":166.55,"postMarketChange":0.02999878,"regularMarketChangePercent":0.04806647,"regularMarketDayRange";:"165.93
> -
> 168.98","regularMarketPreviousClose":166.44,"bid":166.52,"ask":166.55,"bidSize":13,"askSize":10,"messageBoardId":"finmb_24937";,"fullExchangeName":"NasdaqGS","longName":"Apple
> Inc.","financialCurrency":"USD","averageDailyVolume3Month":42946132,"market":"us_market","priceHint":2,"exchangeDataDelayedBy";:0,"fiftyTwoWeekLowChange":24.520004,"fiftyTwoWeekLowChangePercent":0.17267609,"fiftyTwoWeekRange":"142.0
> -
> 233.47","fiftyTwoWeekHighChange":-66.95,"fiftyTwoWeekHighChangePercent":-0.2867606,"fiftyTwoWeekLow":142.0,"fiftyTwoWeekHigh":233.47,"dividendDate":1542240000,"earningsTimestamp":1548795600,"earningsTimestampStart":1556535540,"earningsTimestampEnd":1556884800,"trailingAnnualDividendRate":2.82,"trailingPE":13.73814,"trailingAnnualDividendYield":0.016943041,"symbol":"AAPL"},"options":[{"expirationDate":1550188800,"hasMiniOptions":false,"calls":[],"puts":[]}]}],"error":null}}
>
>
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (15) . Top ^

2a

Re: Retrieve business breakdown table

Sat Feb 2, 2019 9:31 pm (PST) . Posted by:

lawrence.leesh

Yes, I would like to know the formula for (for the first table)... iPhone
2017
USD (in million)
141,319, etc.


And for the second table...
United States
2017
USD in million, etc.


I don't need the data in the % columns or delta columns.


thanks

Reply to sender . Reply to group . Reply via Web Post . All Messages (7) . Top ^

For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Visit Your Group

• Privacy • Unsubscribe • Terms of Use