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...
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)...
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...
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)...
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...
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...
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...
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
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
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...
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...
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...
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 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.