extract data

Hi All, Is there any way in which I can extract live stock prices data from Yahoo Finance/ NSE ( Indian Stocks ) for different stocks for a range of dates ? Please guide me as the same is very important project given to me

hello...i'm using excel 2016 and I need the 1st word after the number sequence. How do I accomplish this? My text strings are as follows: 67478_06271_CHILLAXBLACK_ZG13096-06 67478_06271_OFFWEGO_ZG12711-04BOOTIEWI 67478_06271_RUBIE_ZG13574-15STRAPPYW 67478_06271_SPRAYPAINT_LACEDBOOTWITHPLAI...

Hi, I'm working with a large data set with paired values. Simply, column A is the x value (time) paired with the neighboring y value (signal) in column B. I'm seeking to only retrieve the x-y pair (in columns G & H, respectively) when y >= a certain threshold for maxima and y <= for minima...

Hi Experts, We are trying to extract data based on the "symbol" for example find all "CNU" and return the "C" value. i.e. for CNU 3.44 into separate columns (figure 2) for all the symbols. Is this possible? Thank you Figure 1 <colgroup><col span="10"></colgroup><tbody> Symbol N D T O H L C...

Hello, First post and i'm a scientist, with no programming experience so by all means tell me if i am being unreasonable with my expectations or if i am being incredibly stupid ! I have a workbook containing with 3 reports Each report represents a status of a type of blood sample (1 per row)...

I have 4 tabs of different #'s 201, 202, 203, 204 In a master tab I am dumping data... I have a suite column that has suite #'s and dates Each of the 4 suites and their dates are in this master data list. I am trying to get a macro that will loop through column and insert each suite and its...

Kind of lost on what to do here. I have a a cell in A2 that is in the format shown below. I need to extract all text after Query Summery - and to end at the ============ beffore Query. All it should pull through is New event testing in area 15. I have mutiple entries like this in the A...

I have the following VBA macro, and I am using it to create a log by extracting certain values from a list of excel files in a particular. However, instead of just the files in <code style="margin: 0px; padding: 1px 5px; border: 0px; font-size: 13px; font-family: Consolas, Menlo, Monaco, 'Lucida...

Hey Everyone, Thank you for taking the time to read this, I am currently a novice VBA programmer beginning to learn the basics of visual basics. I had been trying to design a program to view/download current tax forms for client viewing. The program as designed is supposed to visit a page and...

Hello, I need help with a macro that does the following: I have 31 worksheets labeled from "1" to "31" with certain data points on it. I am trying to pull data from those 31 sheets into a worksheet in the same workbook called "Weekly Report Results". I setup cells on the weekly report result...

Hello I have this formula =INDEX(TAB!$B$3:$B$5390,AGGREGATE(15,6,(ROW(TAB!$B$3:$B$5390)-ROW(TAB!$B$3)+1)/(--ISNUMBER(FIND($B$1:$F$1,TAB!$B$3:$B$5390))),ROWS(A$5:A5))) List of codes = TAB!$B$3:$B$5390 List of strings to filer extract from list of codes = $B$1:$F$1 So my list of codes loook...

I am new to the forum and I need technical help desperately. I need a formula to deal with 3 columns of data all on the same row on my financial spreadsheet. Column E contains dates of receiving interest income entered in this way "5/30/2014". Column F contains the interest earned amounts...

Hi Good evening all, I have a Sales report which has many duplicate Invoice nos. I have a Drop-down in cell J2 which fetches me all the unique Invoice nos. I want to fetch all of the Invoice details like Products Ordered, CustomerName, Qty, Rate, Amount etc when I select Invoice no from the...

Hi, Consider a sheet where I will have a cell in T1 that will have this value ...

Hi, I'm trying to extract data from this website http://www.linguasport.com/futbol/nacional/copa/seekff_esp.asp I need to vary the last number and extract data from 600 pages, all with the same structure. Could someone please help me with the code for a macro I should use to extract this data...

I have a database which lists daily entries of production data. In my process, material is input as one code, processed, and broken down into several output codes by composition. Within each production run, there are several metrics such as input code, production time, input weight, output...

So through combining several formulas I now have this amazing formula that allows the user to have a criteria for extracting data. When they put this in, the formula pops out a sorted list of the data including the data from other columns that go along with item (Last, First, DOB). Which field...

Hi Community, I was browsing through the forum and found a few interesting topics on using macros to extract data out from multiple sheets in Excel as seen as via the trackbacks. What I have on hand is slightly different hence requiring some advice. I have the followings: Sheet 1:Submission...

Hi guys. I found some brilliant advice on extracting the last cell from a cell of data in this thread from 2012. The user Rober Mika provided this formula for extraction of the last word from a cell: =UPPER(TRIM(RIGHT(SUBSTITUTE(TRIM(X1)," ",REPT(" ",99)),99))) This works great for most...

Extracting a series that has too many variables. Col A: <TBODY> Sender: </SPAN>SBS R-10034793-001000 Inconsistency between a document field and the prof. seg</SPAN> Sender: SBS P-ALTBBJ1 center N10/6024 is blocked against indirect post</SPAN> Sender: SBS C-00128 INS Too Cap - NIKON Laser...