Selector getting table from nse it

i want to get stock value in https://www.nseindia.com/market-data/live-equity-market

there is stock symbol up arrow in suzlon i need to get all stocks which has up arrow

in general we can setup an extraction an react on the aria-label attribute


OR / Alternate:
racting on the class name - class attribute:
grafik

Then we can filter on Arrows Up Occurrences

For reliability reasons we would recommend to check

  • Approach - extract data / Table extraction & Checking aria-label within an for each
  • Approach with find children, as the extract data / Table extraction can react sensitive on structure inconsistencies

understand logic cbut unavble to proceed …can you please explain in detail

Thankyou @ppr

@Anil_G @Yoichi @Palaniyappan
Can you please help for this issue

we discussed internally and would recommend combining Extract datatable (extract native table) along with find children.

Let us know if you need further assistance

Fine

I hope u understood the process of extraction the entire data with table extraction from peters comment

Let’s say it is saved as a variable named ExtractedDatatable

Now if you want only the arrow up values

ExtractedDatatable = ExtractedDatatable.AsEnumerable().Where(Function(a) a(“Label”).ToString.Contains(“Arrows Up”)).CopyToDatatable()

This will give u the records whose arrow is up

Cheers @sathya_auto

Quick Feedback on the feasability:

grafik

  • extracted native table
    Properties Find Children:
    grafik

A rough filtering
ArrowUpFilter =

(From ue In uiChildren
Let nv = ue.FindFirst(FindScope.FIND_DESCENDANTS, New Selector("<webctrl tag='TD' idx='2' />"), Nothing).Get("text").toString
Select v = nv).toArray
Flow Version 1 - Outdated -we optmized with above

grafik
A rough filtering
ArrowUpFilter =

(From ue In uiChildren
Where ue.Get("innerhtml").toString.Contains("class=""multi_arrows_up""")
Let nv = ue.FindFirst(FindScope.FIND_DESCENDANTS, New Selector("<webctrl tag='TD' idx='2' />"), Nothing).Get("text").toString
Select v = nv).toArray

Filter:
grafik

As we achieved this so far we continue:

  • using the filter for filtering / DataJoining with the origin extracted native Datatable
  • breaking RnD Code down to more essential activities, if wished

thankyou @ppr
@Palaniyappan for your help
Regards
Sathya

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.