Quick Excel Macro to pull stock data

Public Clarification Board

• 

  Semi786

  • 6 years ago

  I have 2 questions. Could you please message me.

  • 6 years ago
• 

  Semi786

  • 6 years ago

  I am working on it as I have discussed.

  • 6 years ago
• 
  Contest Holder

  • 6 years ago

  Please read Stock data.docx, If you have any further questions please post them here

  • 6 years ago
  View 4 more messages
  1. 

     korgeo

     • 6 years ago

     As I previously mentioned, the stock value at a specific time is not available from the Google Finance API for historical data. The available values are Opening - Closing - High - Low - Volume.

     • 6 years ago
  2. 
     Contest Holder

     • 6 years ago

     if 13:00 is not possible thats fine. Only submit the file with Opening and Closing values.

     • 6 years ago
• 

  korgeo

  • 6 years ago

  Hello,
  I have a few questions regarding your project:
  
  1. Which field is the 13:00 o'clock value related to? Apart from Volume, the other options are High and Low, and neither seems appropriate.
  
  2. Average of averages implies that timeframes are identical in length for each run. For example, Run1 might include 14 days, while Run2 might have 20 days. Should the application enforce equal length for timeframes? If not, how are missing values supposed to be treated?
  
  3. Should the application keep the raw data for each run (per day prices for each stock) or simply the result of calculating the average (green column in screenshot formular.jpg)?

  • 6 years ago
• 
  Contest Holder

  • 6 years ago

  please post your questions.
  with kind regards

  • 6 years ago
• 

  aouniradhouene

  • 6 years ago

  Can you message me?

  • 6 years ago
• 
  Contest Holder

  • 6 years ago

  Hi, how can I help?

  • 6 years ago
• 

  aouniradhouene

  • 6 years ago

  Hi, I am on your project and i have a few questions so if someone can contact me, we may finish it in a few hours.

  • 6 years ago

Show more comments