Javascript number extraction

[jimihendrix857]

Im new to AutoIt and somewhat new to scripting. Im trying to gather information from a website (https://www.cedarfinance.com/trade/) but its running a javascript so the standard WindowInfo tool doesnt help. Im trying to extract the current stock cost and place it into an excel file every hour to get historical data. Since my knowledge of java is limited Im reaching out to anyone that may be able to provide me with guidance. 

Thanks in advance. 

[Gianni]

hi jimihendrix857

to extract data from a web page you could use the functions provided by the ie.au3 udf

for example:

_IETableGetCollection and _IETableWriteToArray

could be used on your link in this way:

#include <IE.au3>
#include <Array.au3>

; open the page
Local $oIE = _IECreate("https://www.cedarfinance.com/trade/")

Local $oTable = _IETableGetCollection($oIE, 2) ; second table contains values
Local $aTableData = _IETableWriteToArray($oTable, 1) ; put the list from web table to array
_ArrayDisplay($aTableData)

[jimihendrix857]

Do the IE commands work with Chrome? The page doesnt load right in IE resulting in not much information being placed in the array. 

[JLogan3o13]

No (intuitively) the IE UDF is for..IE. I believe there is a Chrome UDF, though I have never used it. Your best bet is to look at the IUAutomation UDF at the top of the Examples forum. I know you can work in Chrome with that.

[MikahS]

Links:

>IUAutomation UDF

>Chrome UDF

[Xenobiologist]

Do you have the site always open in your browser?

Then a easy way would be (using Autoit)

Activate the browser send CTRL +A then CTRL+C

then use a Regex to get the info you want.

[jimihendrix857]

Thanks for everyones comments. The table extraction is perfect for that site. I have a 2nd site that doesn't have a clean table to extract but still in javascript.  Spotfn.com is the site.

The Regex solution is workable but not sure how to isolate a single number between two words and copy that into a variable. For example

......aslfkjdslfkajsdflaj

CALL

1.111234

PUT

lsdkfjsaldkfjasf......

 

How do I then place that into a variable?

It definitively gets what I want but I feel like there is a simpler way. I.e. pull the exact element from the site but even with the IU automation UDF I cant seem to isolate that particular element. Once I can learn to hunt down and know how to call a value from a specific element I can propagate the knowledge into the rest of my program. I would also like to click buttons in the javascript and unless I know the element name, the only way this can be done is through x, y mouse clicks which can get messed up.

Thanks