stock price

  1. 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...
  2. 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...
  3. 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...
  4. 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...

Some videos you may like

This Week's Hot Topics

  • Sort code advice please
    Hi, I have the code below which im trying to edit but getting a little stuck. This was the original code which worked fine,columns A-F would sort...
  • SUMPRODUCT with nested If statement
    Hi everyone, Hope you're all well. I'm hoping someone will be able to point me in the right direction with a problem I'm having with a SUMPRODUCT...
  • VBA - simple sort is killing me!
    Hello all! This should be so easy, but not for me, apparently! I have a table of data that can be of varying lengths and widths. My current macro...
  • Compare Two Lists
    I have two Lists and I need to be able to Identify differences between them. List 100 comes from a workbook - the other is downloaded form the...
  • Formula that deducts points for each code I input.
    I am trying to create a formula that will have each student in my class start at 100 points and then for each code that I enter (PP for Poor...
  • Conditional formatting formula required for day of week and a value
    Hi, I have a really simple spreadsheet where column A is the date, column B is the activity total shown as a number and column C states the day of...
Top