6 Messages
Digest #4480
Messages
Sun Feb 3, 2019 6:45 am (PST) . Posted by:
"Randy Harmelink" rharmelink
You can just use the INDEX() function to pull back the row and column of
the table. For example:
=INDEX(RCHGetHTMLTable("https://www.marketscreener.com/APPLE-4849/company/","Sales
per Businesses",-2,,2,,10,10),4,1)
=INDEX(RCHGetHTMLTable("https://www.marketscreener.com/APPLE-4849/company/","Sales
per Businesses",-2,,2,,10,10),4,2)
On Sat, Feb 2, 2019 at 10:35 PM lawrence.leesh@... wrote:
>
> 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.
>
>
the table. For example:
=INDEX(RCHGetHTMLTable("https://www.marketscreener.com/APPLE-4849/company/","Sales
per Businesses",-2,,2,,10,10),4,1)
=INDEX(RCHGetHTMLTable("https://www.marketscreener.com/APPLE-4849/company/","
per Businesses"
On Sat, Feb 2, 2019 at 10:35 PM 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.
>
>
Sun Feb 3, 2019 1:33 pm (PST) . Posted by:
"Peter Cook" pete_cook2001
If I open it in IE it still asks me if I want to open AAPL.json.
When I browse to http://www.pinlady.net/PluginDetect/IE/ I get
[image: image.png]
On Sat, Feb 2, 2019 at 9:26 PM Randy Harmelink rharmelink@gmail.com
[smf_addin] <smf_addin@yahoogroups.com> wrote:
>
>
> 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}}
When I browse to http://www.pinlady.net/PluginDetect/IE/ I get
[image: image.png]
On Sat, Feb 2, 2019 at 9:26 PM Randy Harmelink rharmelink@gmail.com
[smf_addin] <smf_addin@yahoogroups.com> wrote:
>
>
> 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@
>
>>
>> I see. I opened it with notepad and I see what look like three expiration
>> dates:
>>
>> {"optionChain&
>> Quote",
>> Inc.","
>> -
>> 168.98"
>> Inc.","
>> -
>> 233.47"