stock price

  1. D

    Autofill dynamic range formula - Stock price ln return

    Hi to all, I'm Davide and new on VBA code. I have an issue to help some one can help me. I Have already set a code to check the range dynamic of the data of the sheet named "Cotizaciones". Here the code: Sub Funziona() 'Best used when first column has value on last row and first row has a value...
  2. Y

    Generating REAL TIME (no 15 min delay) stock prices in Excel

    Hi there, I am looking for a wizard to help me out on this one. I've created a rather advanced Excel workbook that tracks stocks (analyses, gives alerts, atc). The only thing missing is real time stock prices. I have tried many many things to get real time stockprices in my spreadsheet (power...
  3. B

    VBA code leads to #value! in cell but works in immediate box

    I have written a getprice function for retrieving stock tickers from yahoo and bitcoin prices from an online api. However the code for bitcoin results in an #value! in my excel cell. But it performs fine when I run the function from the immediate box in VB. I sense it's some sort of...
  4. T

    Convert 1 min data into 5 min data

    Hi I have some data that I would like to convert from a 1 min data into groups of 5 mins starting from 00:00, 00:05, 00:10 etc it is occuring over a number of years that is spread over 4 worksheets (yea its a lot of data). Problem is that it isn't a continuous set of 1 min data as it is only...
  5. E

    Stock Performance Charting

    I have a spreadsheet tracking a stock's weekly performance and want to effectively graph it as described below. My spreadsheet is setup as follows: Column A: Date of last trading day of the week - usually a Friday - format; Short Date (mm/dd/yyyy). Column B: Closing price of the stock for that...

Watch MrExcel Video

This Week's Hot Topics

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
Top