Quick Excel Macro to pull stock data

Stav: Closed
Odměna: €28
Přijatých návrhů: 2
Vítěz: Semi786

Winner

Instrukce k soutěži

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

Doporučené dovednosti

Winner

Zadejte podobnou soutěž

Zpětná vazba od zaměstnavatele

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

Nejlepší návrhy této soutěže

Semi786 India

1
korgeo Greece

0

Veřejná nástěnka k vyjasnění projektu

Semi786
- Před 6 let
I have 2 questions. Could you please message me.
- Před 6 let
Semi786
- Před 6 let
I am working on it as I have discussed.
- Před 6 let
Pořadatel soutěže
- Před 6 let
Please read Stock data.docx, If you have any further questions please post them here
- Před 6 let
Zobrazit dalších 4 zpráv
1. korgeo
  - Před 6 let
  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.
  - Před 6 let
2. Pořadatel soutěže
  - Před 6 let
  if 13:00 is not possible thats fine. Only submit the file with Opening and Closing values.
  - Před 6 let
korgeo
- Před 6 let
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)?
- Před 6 let
Pořadatel soutěže
- Před 6 let
please post your questions.
with kind regards
- Před 6 let
aouniradhouene
- Před 6 let
Can you message me?
- Před 6 let
Pořadatel soutěže
- Před 6 let
Hi, how can I help?
- Před 6 let
aouniradhouene
- Před 6 let
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.
- Před 6 let