#AlphaVantage

[oscar85world]

Elevating Financial Dashboards with Python and Power BI: A Game-Changer for Asset Analysis

Link to the PowerBI dashboard: https://app.powerbi.com/links/ags0Z_S7UW?ctid=727824e9-e832-4dc8-8645-cfa98ed7b547&pbi_source=linkShare In the realm of finance, data is king. Yet, the true power lies not just in having access to data but in transforming it into actionable insights. This is where our latest project at the intersection of technology and finance comes into play. I’ve embarked on a…

[codehunter]

AlphaVantage API Stock Market Indices

I'm using python and its framework flask to build a frontEnd backEnd project. The project needs stock data. I used Yahoo's Api before it stopped working and now I'm using Alpha Vantage API. It's working pretty well but I'm having difficulties with stock market Indices like Nasdaq, Dow Jones.. with yahoo I was using their tickers(like symboles) (^IXIC, ^DJI...) but it doesn't seem to work with alpha vantage. Has anyone worked with alpha vantage?

example of url to get data for Microsoft: https://www.alphavantage.co/query?function=TIME_SERIES_DAILY_ADJUSTED&symbol=MSFT&outputsize=full&apikey=CN3J

Python code:

@app.route('/pfa/medaf/IndAct', methods = ['POST'])def donnee():Action1 = request.form['code1']Action2 = request.form['code2']Indice = request.form['Ind']url="https://www.alphavantage.co/query?function=TIME_SERIES_DAILY_ADJUSTED&symbol="urlInd=url+Indice+"&apikey=CN3J"urlAct1=url+Action1+"&apikey=CN3J"urlAct2=url+Action2+"&apikey=CN3J"respInd = urlopen(urlInd)dataInd = json.loads(respInd.read().decode(respInd.info().get_param('charset') or 'utf-8'))coursIndice=[]listInd=[]for elt in dataInd['Time Series (Daily)'].keys(): listInd.append(elt)listInd.sort(reverse=True)for e in listInd: coursIndice.append(float(dataInd['Time Series (Daily)'][e]['4. close']))lenIndice = len(coursIndice)rentabIndice=[]for j in range(lenIndice-1): rentabIndice.append(100*(coursIndice[j+1]/coursIndice[j] -1 ))moyenneMarche=sum(rentabIndice)/len(rentabIndice)

HTML code:

<section class="cols pad_left1"> <form action = "http://localhost:5000/pfa/medaf/IndAct" method = "post"> Tickers: <input type = "text" name = "code1" placeholder="Ticker here"><br> <input type = "text" name = "code2" placeholder="Ticker here"><br><br> Indice:<br> <select name="Ind" size="1" > <option value="^IXIC" > NASDAQ Composite </option> <option value="^FCHI" > CAC40 </option> <option value="^DJI" > Dow Jones</option> </select><br><br> <input type = "submit" value = "submit" /> </form></section>

https://codehunter.cc/a/flask/alphavantage-api-stock-market-indices

[sycriptouk]

Best day of the week to DCA

I've always heard the best day of the week to DCA is Sunday, like many of you I followed this advice blindly until I did my own research(also a heavily touted piece of advice). What I found was not only was Sunday not the best day it was one of the worst days. I do not want to say this is 100% accurate but I think it's pretty close. What I did was compare the high and low price of each day and average it out, for each day of the week. I went back 10, 30, 60, 90, 120, 180, 365 and 730 days to find when the best day would net you the biggest returns. Here is what I found...

​

Last 10 Days

​

Last 10 days

This shows that Thursday/Friday were the best times to buy while Monday was the worst.

​

Last 30 Days

​

Last 30 days

Over the month we see that Tuesday/Wed/Thurs were pretty good days to average down. Saturday was the worst time to dca over the last 30 days with a difference of 2706 dollars per coin.

​

Last 60 Days

​

Last 60 days

The graph may look different but it shows almost the same data, Tues-Thurs are pretty low while Sat-Mon are the peaks. Tuesday is pretty consistently the lowest point to DCA in. If you were DCAing on Tuesday your average price per coin is rough $1,100 bucks cheaper than if you DCA on Sundays.

​

Last 90, 120, 180, 365 Days

​

Last 90 days

​

​

Last 120 days

​

Last 180 Days

​

Last 365 days

​

As the charts show, Sunday has been one of the worst days to actual DCA. If you DCAed on Sunday you were normally DCAing 1,000-2,000 higher than if you were to DCA on Tuesday. Maybe this is because more and more people started buying on Sunday in the last few months because of people here saying it's the best time, maybe people knew it wasn't a good time but they pushed that information out anyways. If you look at the last 120 and 180 days, DCAing wasn't that bad and was actually lower than most days but now it seems to be a bad day to buy. Maybe it will change in a month or two. Monday though is by far one of the worst days to buy. Anyways hopes this was informative.

​

Last 2 years

The best DCA strategy though isn't which day you buy but for how long you buy. You can see if you were buying every week for the last 2 years, your average price per coin would be 21k.

​

TLDR: Buy on Tuesday, Wednesday, Thursday. Sell on Saturday or Monday.

Sources:

coinmarketcap - double checking coin prices

alphavantage - api calls

submitted by /u/DRob2388 [link] [comments]

from Cryptocurrency News & Discussion https://www.reddit.com/r/CryptoCurrency/comments/pepuzw/best_day_of_the_week_to_dca/ via IFTTT

[phungthaihy]

Real Time Stock Market Data Analysis with Python - Five Minute Python Scripts http://ehelpdesk.tk/wp-content/uploads/2020/02/logo-header.png [ad_1] Robinhood link: https://freestoc... #alphavantage #analytics #androiddevelopment #angular #automation #c #coding #codingtutorial #css #data #dataanalysis #dataanalytics #datascience #daytrading #deeplearning #derricksherrill #development #docker #fiveminutepythonscripts #information #iosdevelopment #java #javascript #machinelearning #node.js #pandas #programming #programmingtutorial #python #pythonautomation #react #realtime #stockmarket #stockmarketanalytics #tutorial #unity #webdevelopment