Senin, 07 November 2016

[smf_addin] Digest Number 3837

4 Messages

Digest #3837

Messages

Sun Nov 6, 2016 5:10 am (PST) . Posted by:

wdcarswell2002

Thanks so much, it worked perfectly.

I have not been able to do such complex queries -- could you point me in a direction to learn how to do these types of page investigations. I have looked at the Quick Webpage Examination spreadsheet you created but I cannot figure out how to use it. Are there any instructions for that spreadsheet or any examples of usage?


Thanx again, Will Carswell

Sun Nov 6, 2016 12:45 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

The only help the Quick Webpage Examination workbook can provide on JSON or
JavaScript data is the "Cascading Value" worksheet. The cascading value is
typically the "{", because it defines the various arrays of data.

JSON output can be tough. There are no tags defining each piece of data.
It's a straight text extraction. That means you have to find the data
you're interested in extracting, and then look for patterns or strings
around it that might be useful. That is, unique.

When it comes down to it, most of the worksheets in that workbook are
looking for patterns. But the other worksheets are looking for patterns in
HTML tags or tables.

On Sun, Nov 6, 2016 at 6:10 AM, b_carswell@bellsouth.net [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> I have not been able to do such complex queries -- could you point me in a
> direction to learn how to do these types of page investigations. I have
> looked at the Quick Webpage Examination spreadsheet you created but I
> cannot figure out how to use it. Are there any instructions for that
> spreadsheet or any examples of usage?
>
>
>

Sun Nov 6, 2016 5:42 pm (PST) . Posted by:

sdavis81

I am getting ERROR for this one and can't figure out the fix. My thanks for a second set of eyes?


=RCHGetTableCell("https://www.barchart.com/futures/quotes/ES*0/all-futures",1,"S&P 500 E-Mini (Mar '17)")


Trying to get the last quote for the March '17 ES future from site,
ES*0 | All Futures Contracts for S&P 500 E-Mini https://www.barchart.com/futures/quotes/ES*0/all-futures

ES*0 | All Futures Contracts for S&P 500 E-Mini https://www.barchart.com/futures/quotes/ES*0/all-futures Today's ES*0 futures prices, ES*0 futures, ES*0 commodities, charts and quotes.



View on www.barchart.com https://www.barchart.com/futures/quotes/ES*0/all-futures
Preview by Yahoo














Sun Nov 6, 2016 8:01 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

They're no longer delivering the data in an HTML table on the web page. In
fact, there's not even a single HTML table within the source code of the
delivered web page. They're dynamically building the table after doing a
call to their new API:

https://core-api.barchart.com/v1/quotes/get?fields=symbol%2CcontractName%2ClastPrice%2CpriceChange%2CopenPrice%2ChighPrice%2ClowPrice%2Cvolume%2CopenInterest%2CtradeTime%2CsymbolCode%2CsymbolType%2ChasOptions&list=futures.contractInRoot&meta=field.shortName%2Cfield.description&hasOptions=true&raw=1&root=ES

That URL is too long to use within a formula, so you'll need to create it
in a worksheet cell and refer to it. In the end, the new formula would look
something like:

=smfConvertData(smfStrExtr(smfStrExtr(RCHGetWebData(E4),"""contractName"":""S&P
500 E-Mini (Mar '17)"",","}"),"""lastPrice"":""",""""))

...where E4 contains that long URL.

On Sun, Nov 6, 2016 at 6:42 PM, sdavis81@
​...wrote:

>
> I am getting ERROR for this one and can't figure out the fix.
> My thanks for a second set of eyes?
>
> =
> ​​
> RCHGetTableCell("https://www.barchart.com/futures/quotes/ES*0/all-futures",1,"S&P
> 500 E-Mini (Mar '17)")
>
> Trying to get the last quote for the March '17 ES future from site,
> ES*0 | All Futures Contracts for S&P 500 E-Mini
> <https://www.barchart.com/futures/quotes/ES*0/all-futures>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar