ticker

  1. D

    Multiple Stock Tickers from Yahoo Finance

    I saw the following request: How do I set up a web query in excel and make it dynamic for yahoo finance? I’d like to have a reference cell for the ticker symbol of which the web query references this cell. Therefore when the query is refeshed it reflects the stock ticker in the reference cell...
  2. J

    How to Use Wildcards with QueryTable?

    Hi there, I recorded a macro to download a Query Table from the Web that gives me revenue estimates. The code below works for the company ticker "NVDA" which is declared below. However, when I change the ticker to "ADBE", the code breaks because the column header (which specifies a date)...
  3. C

    Lookup and return data from a certain point - Macro?

    Hi All, Hope you are having a great day and thank you in advance for taking the time to look at my post! I am struggling to find a solution to solve the following issue, i am a proficient excel user but am new to Macro's. Ultimately i am trying to pull specific data from an array in order to...
  4. E

    Downloading files from internet using VBA

    Hi, I am pretty new to VBA and have a task which involves following steps: step 1- Copy a ticker (string) from excel file (say cell A2) Step 2- Open a particular url (Say GoogleFinance) Step 3- Search the copied ticker (string) in the search box on the website (by clicking the search button)...
  5. A

    VBA - Extract info from Webpage

    Hi there I have a spreadsheet with a stock ticker in A2. Let’s say for example "GRMN" which is Garmin's stock ticker. I want some code which will go to the webpage www.optionslam.com/earnings/stocks/”STOCKTICKER”. So in my example this would be: https://www.optionslam.com/earnings/stocks/GRMN...
  6. D

    Copy distinct values macro

    Is there a way to make a macro that takes the values/text I have in column B (starting in row 2 to avoid copying the header) on sheet SQL Dump and copy paste values all non-duplicate ticker symbols on a new sheet in column A staring in row 2 (again to avoid copying over the header) on sheet SD...
  7. J

    Pull Financial Statements from a website

    Hi guys, I am in need of a macro and I dont actually know how to write it, I want to pull data from this website: http://tools.morningstar.co.uk/uk/stockreport/default.aspx?tab=10&vw=is&SecurityToken=0P00006TF8%5D3%5D0%5DE0WWE%24%24ALL&Id=0P00006TF8&ClientFund=0&CurrencyId=USD Like I wanna...
  8. J

    Pull stock price daily

    Hello everyone, Do anyone know a way to pull any stock price just by typing the ticker of the stock in excel, hence can get a daily rate on the stock. For example, using the ticker of Microsoft MSFT, pull the current stock price. Thank you
  9. S

    so I'm trying to sum by ticker and rank largest to smallest (not sure how to do it with same ticker for different lots/amounts)

    I have data in two columns such as: AA 50 AA 30 bb 19 XX 20 XX 10 I'm trying to sum by column A inputs and rank highest to lowest by the summed numbers using column B values
  10. E

    QueryTable of Google Finance Appends New Tickers and Prices

    Hi All, Below is a macro I use to get real time price quotes from Google Finance. Each time I change the stock ticker in cell B3 and run the macro the query table appends the new ticker to the returned data. For instance, the first time I ran the macro with ticker AAPL, it put AAPL in E44 and...
  11. D

    Index Match

    Is it possible to use Index match to lookup a value based on two or more different criteria? So if it turns out that the first criteria in the index(Match( formula is not a match is it possible to then look at the second criteria as a backup per-se? So I need to look-up the ESG score in the...
  12. M

    Stock Ticker Macro

    Hi all, I have seen a few threads over the past few months asking this same question, but haven't come across an answer so I thought I would ask here: I used to run a macro/function called StockQuote which was based off of Yahoo Finance's API that would allow me to pull in a stock's price...
  13. X

    VBA > Finance.Yahoo > Ticker Symbol List

    I have a list of Stock ticker symbols starting on Sheet1 A1, however it is not pulling any information. I was wondering if I'm missing a simple fix or if it is slightly more complicated? Thank you in advanced for any and all your help! Sub Macro3() Dim conString As String Dim conName...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top