2 Messages

Digest #4414

Data from TradingView by caleb.mullins25

Re: Data from TradingView by "Randy Harmelink" rharmelink

Messages

1a

Hi Randy,
Is there any way to extract Oscillators and Moving Averages data from this page: https://www.tradingview.com/symbols/NASDAQ-AAPL/technicals/ https://www.tradingview.com/symbols/NASDAQ-AAPL/technicals/

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

1b

Re: Data from TradingView

Thu Nov 1, 2018 1:47 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Such data items are not within the source code of the web, so XMLHTTP can't
be used. And the websocket they retrieve the data from is protected. You
could use one of the experimental SMF routines that can access a rendered
IE web page, but they can be slow, unreliable, and sometimes cause EXCEL to
crash.

For example:

=RCHGetTableCell("https://www.tradingview.com/symbols/NASDAQ-AAPL/technicals",1,"Ichimoku
Cloud Base Line",,,,,,,,1)

That last parameter with a value of "1" tells it to render the page in the
IE browser and then grab the rendered source code.

If you do use that process, make sure you have all work saved before using
a worksheet with the formulas. You might be best off using something like
the smfUpdateDownloadTable to grab the data upon request rather than via
dynamic formulas.

On Thu, Nov 1, 2018 at 10:57 AM naeem_4tk@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

> Is there any way to extract Oscillators and Moving Averages data from
> this page: https://www.tradingview.com/symbols/NASDAQ-AAPL/technicals/
>
>
>