Spreadsheet: 678006d1589653874-need-a-solution-for-power-query-related-work-test
Sheet: Nifty Rtd

symbol | LTP | open | dayHigh | dayLow | previousClose | Rs.chng | % [NAME]. | 52 Week High | 52 week Low | totalTradedVolume | totalTradedValue | lastUpdateTime | nearWKH | nearWKL | perChange365d | perChange30d
NIFTY 50 | 9136.85 | 9182.4 | 9182.4 | 9050 | 9142.75 | -5.899999999999636 | -0.06 | 12430.5 | 7511.1 | 575857112 | 258469673842 | 15-May-2020 16:00:00 | 26.49652065484091 | -21.64463261040327 | -18.05 | 1.66
VEDL | 92.6 | 90 | 95.55 | 88.2 | 89.15 | 3.45 | 3.87 | 180 | 60.2 | 75496782 | 6981187432 | 15-May-2020 15:59:59 | 48.55555555555556 | -53.8205980066445 | -44.3 | 13.86
BHARTIARTL | 554.8 | 543.5 | 556.9 | 539.4 | 539.85 | 14.95 | 2.77 | 569.75 | 321.05 | 14486155 | 7968109558 | 15-May-2020 15:59:40 | 2.623957876261526 | -72.80797383585109 | 62.97 | 5.4
BPCL | 317.8 | 313 | 324.35 | 311.1 | 309.7 | 8.1 | 2.62 | 549 | 252 | 13883667 | 4437219973 | 15-May-2020 15:59:57 | 42.11293260473588 | -26.11111111111111 | -13.86 | -11.54
ASIANPAINT | 1555 | 1529 | 1560 | 1510 | 1522.4 | 32.6 | 2.14 | 1916.7 | 1291.25 | 2860615 | 4388297835 | 15-May-2020 15:59:37 | 18.8709761569364 | -20.42594385285576 | 16.57 | -9.43
TATASTEEL | 273.15 | 270 | 276.8 | 268.8 | 268.55 | 4.6 | 1.71 | 518.6 | 250.85 | 14991458 | 4102862225 | 15-May-2020 15:59:41 | 47.32934824527575 | -8.889774765796286 | -41.99 | -4.95
NTPC | 90.75 | 90 | 91.8 | 89.2 | 89.35 | 1.4 | 1.57 | 145.85 | 73.2 | 16926082 | 1536380463 | 15-May-2020 15:58:41 | 37.7785395954748 | -23.97540983606557 | -27.91 | 0.79
HINDALCO | 118.95 | 118.4 | 120.9 | 117.4 | 117.2 | 1.75 | 1.49 | 221.2 | 84.9 | 12510164 | 1491962159 | 15-May-2020 15:59:56 | 46.2251356238698 | -40.1060070671378 | -38.53 | 2.99
HINDUNILVR | 2034.95 | 2015 | 2037.65 | 2006 | 2006.05 | 28.9 | 1.44 | 2614.3 | 1659.05 | 5491176 | 11101675254 | 15-May-2020 15:59:53 | 22.1608078644379 | -22.65754498056117 | 20.05 | -14.51
RELIANCE | 1453.2 | 1444 | 1466.7 | 1415.1 | 1435.95 | 17.25 | 1.2 | 1601.53 | 866.98 | 28683432 | 41299552731 | 15-May-2020 15:59:49 | 9.261768433935044 | -67.61632332925788 | 14.25 | 20.75
NESTLEIND | 16397 | 16500 | 16550 | 16201.95 | 16242.5 | 154.5 | 0.95 | 18369.95 | 10211 | 271603 | 4445513707 | 15-May-2020 15:59:44 | 10.74009455659923 | -60.58172559004995 | 58.18 | -2.15
GRASIM | 515.35 | 514.25 | 519.85 | 509.9 | 511.4 | 3.95 | 0.77 | 959.8 | 385.05 | 1378960 | 709695554 | 15-May-2020 15:59:53 | 46.30652219212335 | -33.83976106999091 | -37.24 | -6.08
EICHERMOT | 14123.65 | 14080 | 14199 | 13650 | 14031.85 | 91.8 | 0.65 | 23450 | 12450.1 | 235025 | 3281940806 | 15-May-2020 15:56:00 | 39.77121535181237 | -13.4420607063397 | -29.83 | 4.71
COALINDIA | 129.4 | 129.7 | 130.85 | 127.75 | 128.65 | 0.75 | 0.58 | 271.45 | 119.2 | 6296866 | 815821959 | 15-May-2020 15:59:23 | 52.33007920427334 | -8.557046979865774 | -45.28 | -11.82
IOC | 75.5 | 75.75 | 76.4 | 75.2 | 75.15 | 0.35 | 0.47 | 170.75 | 72.8 | 15818086 | 1200592727 | 15-May-2020 15:59:19 | 55.78330893118594 | -3.708791208791213 | -48.44 | -9.62
TATAMOTORS | 84.15 | 84.7 | 85.35 | 82.8 | 83.8 | 0.35 | 0.42 | 201.7 | 63.5 | 38594210 | 3238054219 | 15-May-2020 15:59:56 | 58.27962320277639 | -32.51968503937009 | -50.55 | 12.86
[NAME] | 85.8 | 86.1 | 86.8 | 84.75 | 85.45 | 0.35 | 0.41 | 182.7 | 65 | 12041344 | 1033869796 | 15-May-2020 15:59:48 | 53.03776683087028 | -31.99999999999999 | -74.24 | -0.7
ITC | 164.4 | 162.2 | 165.5 | 161.15 | 163.8 | 0.6 | 0.37 | 310 | 134.6 | 14950688 | 2439503761 | 15-May-2020 15:59:58 | 46.96774193548387 | -22.13967310549777 | -44.86 | -9.8
BRITANNIA | 3127 | 3146.9 | 3196 | 3115 | 3118.7 | 8.3 | 0.27 | 3583.75 | 2100 | 870248 | 2742160150 | 15-May-2020 15:57:21 | 12.74502964771538 | -48.90476190476191 | 16.03 | 15.24
KOTAKBANK | 1176.15 | 1179.85 | 1189.9 | 1154.2 | 1173.1 | 3.05 | 0.26 | 1740 | 1001 | 3864229 | 4525050801 | 15-May-2020 15:59:44 | 32.4051724137931 | -17.49750249750251 | -15.96 | -6.22
ADANIPORTS | 309 | 309 | 312 | 305.35 | 308.4 | 0.6 | 0.19 | 430.6 | 203 | 3712050 | 1145612871 | 15-May-2020 15:58:23 | 28.23966558290757 | -52.2167487684729 | -14.37 | 17.33
HDFC | 1634 | 1649 | 1657.75 | 1609 | 1632.4 | 1.6 | 0.1 | 2499.9 | 1473.45 | 5610025 | 9163414835 | 15-May-2020 15:59:37 | 34.63738549541982 | -10.89619600257898 | -16.07 | -1.38
TCS | 1903 | 1916 | 1917.4 | 1865.2 | 1902.35 | 0.65 | 0.03 | 2296.2 | 1506.05 | 3173682 | 5979978572 | 15-May-2020 15:59:58 | 17.12394390732514 | -26.35702665914147 | -9.21 | 8.13
TITAN | 846.25 | 846 | 859.8 | 842 | 846 | 0.25 | 0.03 | 1389.95 | 720.9 | 2131038 | 1810124988 | 15-May-2020 15:59:59 | 39.11651498255333 | -17.38798723817451 | -27.26 | -12.5
DRREDDY | 3730 | 3746 | 3778.9 | 3717.05 | 3732 | -2 | -0.05 | 4132.2 | 2351.2 | 899387 | 3374904748 | 15-May-2020 15:56:35 | 9.733313973186194 | -58.64239537257572 | 32.64 | -0.39
ONGC | 76 | 77.25 | 78.5 | 75.9 | 76.15 | -0.15 | -0.2 | 178.9 | 50 | 16836413 | 1293709975 | 15-May-2020 15:59:56 | 57.51816657350475 | -52 | -53.21 | 1.47
MARUTI | 5099 | 5110 | 5123.2 | 4961.15 | 5114.05 | -15.05 | -0.29 | 7758.7 | 4001.1 | 2182575 | 11014713950 | 15-May-2020 15:59:48 | 34.2802273576759 | -27.43995401264653 | -21.25 | -3.2
CIPLA | 566.8 | 572 | 585 | 565.6 | 569.75 | -2.95 | -0.52 | 632.65 | 355.3 | 14388640 | 8255769973 | 15-May-2020 15:59:52 | 10.40859875128428 | -59.52716014635517 | 2.53 | -3.9
HDFCBANK | 888 | 890.5 | 892.4 | 875 | 893.7 | -5.7 | -0.64 | 1305.5 | 738.75 | 12174870 | 10774759950 | 15-May-2020 15:59:55 | 31.98008425890463 | -20.20304568527919 | -60.92 | -0.18
JSWSTEEL | 174 | 176.9 | 179.4 | 173.25 | 175.2 | -1.2 | -0.68 | 297.5 | 132.5 | 11548870 | 2039761419 | 15-May-2020 15:58:43 | 41.51260504201681 | -31.32075471698113 | -34.75 | 4.5
POWERGRID | 159.6 | 159.2 | 161.75 | 158.25 | 160.8 | -1.2 | -0.75 | 216.25 | 122.15 | 11256556 | 1807915459 | 15-May-2020 15:59:41 | 26.19653179190752 | -30.65902578796561 | -9.92 | 0.53
TECHM | 511.5 | 520 | 520 | 507.4 | 515.7 | -4.2 | -0.81 | 845.9 | 471.4 | 3628560 | 1856915580 | 15-May-2020 15:59:59 | 39.53185955786736 | -8.506576156130679 | -34.75 | -2.12
INFY | 652.3 | 664.8 | 664.8 | 646.7 | 658.15 | -5.85 | -0.89 | 847 | 509.25 | 9255353 | 6038747618 | 15-May-2020 15:59:58 | 22.98701298701299 | -28.09032891507118 | -8.09 | 3.26
SBIN | 166.45 | 167.95 | 168.25 | 164.7 | 167.95 | -1.5 | -0.89 | 373.8 | 160.85 | 35498484 | 5898428101 | 15-May-2020 15:59:57 | 55.47084002140183 | -3.481504507304939 | -46.19 | -8.47
HCLTECH | 512.2 | 517.95 | 517.95 | 505.25 | 517.45 | -5.25 | -1.01 | 623.5 | 375.25 | 4895771 | 2501249404 | 15-May-2020 15:59:52 | 17.85084202085003 | -36.49566955363093 | -51.52 | 12.92
ULTRACEMCO | 3571.5 | 3629 | 3629 | 3547.85 | 3609.5 | -38 | -1.05 | 4904.95 | 2910 | 645207 | 2311976695 | 15-May-2020 15:59:44 | 27.18580209788071 | -22.7319587628866 | -16.88 | 4.14
LT | 861.25 | 881.95 | 885 | 854 | 871.65 | -10.4 | -1.19 | 1607 | 661 | 5654025 | 4907976401 | 15-May-2020 15:59:50 | 46.40634723086497 | -30.29500756429652 | -34.25 | 0.72
BAJFINANCE | 2086 | 2119.95 | 2136.6 | 2056 | 2112 | -26 | -1.23 | 4923.4 | 1915.65 | 8026847 | 16714464045 | 15-May-2020 15:59:55 | 57.63090547182841 | -8.892543001070129 | -29.66 | -7.66
WIPRO | 183.6 | 186 | 186 | 182.65 | 186 | -2.4 | -1.29 | 301.6 | 159.4 | 3425171 | 631875546 | 15-May-2020 15:59:44 | 39.12466843501327 | -15.1819322459222 | -34.28 | -1.69
SHREECEM | 19059.7 | 19509.9 | 19563.55 | 18811.5 | 19310.8 | -251.1 | -1.3 | 25355 | 15410 | 52718 | 1005503594 | 15-May-2020 15:55:33 | 24.82863340563991 | -23.68397144711227 | 1.56 | 11.62
BAJAJ-AUTO | 2660 | 2705 | 2710 | 2650 | 2702.65 | -42.65 | -1.58 | 3315.15 | 1788.65 | 645549 | 1724248468 | 15-May-2020 15:56:33 | 19.76230336485529 | -48.71551169876722 | -7.27 | 12.73
ICICIBANK | 322 | 329.3 | 330.55 | 318.8 | 327.4 | -5.4 | -1.65 | 552.2 | 268.3 | 31829841 | 10238386656 | 15-May-2020 15:59:58 | 41.68779427743571 | -20.0149086843086 | -13.17 | -0.98
BAJAJFINSV | 4710 | 4792 | 4833.65 | 4701 | 4790.25 | -80.25 | -1.68 | 9950 | 4160.25 | 395124 | 1874934502 | 15-May-2020 15:59:53 | 52.66331658291458 | -13.2143500991527 | -35.74 | 6.65
SUNPHARMA | 446.8 | 455.95 | 458.9 | 445.55 | 455.95 | -9.15 | -2.01 | 504.8 | 312 | 7863397 | 3557793973 | 15-May-2020 15:59:56 | 11.48969889064976 | -43.20512820512821 | 11.28 | -1.38
HEROMOTOCO | 2195.35 | 2249 | 2249 | 2170 | 2241.35 | -46 | -2.05 | 3022.9 | 1475 | 2080652 | 4578724404 | 15-May-2020 15:59:40 | 27.37602964041153 | -48.83728813559321 | -10.11 | 16.79
INDUSINDBK | 418.2 | 430.4 | 431 | 417.1 | 428 | -9.8 | -2.29 | 1672.95 | 235.55 | 14849518 | 6253280525 | 15-May-2020 15:59:59 | 75.00224154935891 | -77.54192315856504 | -68.96 | 4.29
UPL | 380 | 393.7 | 393.7 | 377.45 | 391.85 | -11.85 | -3.02 | 709.05 | 240.15 | 3690162 | 1415398537 | 15-May-2020 15:59:54 | 46.40716451590155 | -58.23443681032688 | -59.58 | 20.59
INFRATEL | 203.05 | 205.95 | 207.45 | 200.7 | 209.65 | -6.6 | -3.15 | 296.5 | 120.05 | 11910823 | 2426115537 | 15-May-2020 15:59:17 | 31.51770657672849 | -69.1378592253228 | -20.54 | 18.11
AXISBANK | 388.8 | 402.75 | 403.9 | 386.8 | 401.95 | -13.15 | -3.27 | 827.75 | 286 | 25435045 | 9957057066 | 15-May-2020 15:59:52 | 53.02929628511024 | -35.94405594405595 | -44.32 | -4.06
ZEEL | 163.5 | 166.7 | 172.2 | 162.5 | 169.65 | -6.15 | -3.63 | 405.2 | 114 | 28283411 | 4728703485 | 15-May-2020 15:59:26 | 59.64955577492596 | -43.42105263157895 | -47.37 | 23.74
M%26M | 381.85 | 402.75 | 403.95 | 373.2 | 400.45 | -18.6 | -4.64 | 683 | 245.4 | 14226558 | 5447775855 | 15-May-2020 15:59:22 | 44.0922401171303 | -55.60309698451508 | -34.31 | 10.36