Quick Excel Macro to pull stock data

Estado: Closed
Premio: €28
Propuestas recibidas: 2
Ganador: Semi786

Winner

Resumen del concurso

I need an Excel file that runs a macro to import Stock Data from Google finance, Similar to the file Multiple Stock Quote Downloader Google Finance.xlsm
The description of Contest in the file Stock data.docx

Thank you
With best regards
GS

Habilidades recomendadas

Winner

Publica un concurso similar

Comentarios del empleador

“Did the Job ASAP as requested, and managed to find good solutions for all the issues presented. Looking forward to working with Israr again the next time.”

stephenwichmann, Turkey.

Principales propuestas de este concurso

Semi786 India

1
korgeo Greece

0

Tablero de aclaración pública

Semi786
- 6 años atrás
I have 2 questions. Could you please message me.
- 6 años atrás
Semi786
- 6 años atrás
I am working on it as I have discussed.
- 6 años atrás
Organizador del concurso
- 6 años atrás
Please read Stock data.docx, If you have any further questions please post them here
- 6 años atrás
Ver 4 mensajes más
1. korgeo
  - 6 años atrás
  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 años atrás
2. Organizador del concurso
  - 6 años atrás
  if 13:00 is not possible thats fine. Only submit the file with Opening and Closing values.
  - 6 años atrás
korgeo
- 6 años atrás
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 años atrás
Organizador del concurso
- 6 años atrás
please post your questions.
with kind regards
- 6 años atrás
aouniradhouene
- 6 años atrás
Can you message me?
- 6 años atrás
Organizador del concurso
- 6 años atrás
Hi, how can I help?
- 6 años atrás
aouniradhouene
- 6 años atrás
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 años atrás