Vnquant Package: VietNam Data Stock Market Price

vnquant package

0. NOTE

Note: Currently, prices on VnDirect source are supported again. There are two options data source for you:

• cafef: Set data_source='CAFE'
• vndirect: set data_source='VND'

1. Introduction

This project provide the financial information and useful visualization instrument about Vietnam stock market to researcher. Particularly, there are many aspect of data relating to any stock being able to store and clone. The official version are built on both machine learning language Python and R.

2. Setting:

2.1. Setup on local machine

This project is in developing process, So it is only distributed on github channel. To install requiring you open the command line and type the below commands:

git clone https://github.com/phamdinhkhanh/vnquant
cd vnquant
python setup.py install

you must install git command line in your computer to run above command.

2.2. Google colab

To use package in google colab, you have to mount point to google drive folder first and setup the same as in local machine. Reference to google colab - vnquant example for detail.

3. Visualization: (0.0.2)

from version 0.0.2 vnquant enable to you visualize stock price from any symbols code at source cafe or vnd or pandas data frame which have OHLC type. OHLC type meaning that your data frame columns is enough ['open', 'high', 'low', 'close'] list. Below is general syntax of visualization function supported on vnquant package.

from vnquant import Plot
Plot._vnquant_candle_stick(data,
                          title=None,
                          xlab='Date', ylab='Price',
                          start_date=None, end_date=None,
                          colors=['blue', 'red'],
                          width=800, height=600,
                          show_vol=True,
                          data_source='cafe', # not support vnd
                          **kargs)

Arguments

• data: is pandas data frame of OHLC type or OHLCV type, or string symbol of any VietNam stock index. in case symbol, data is automatically cloned from open source.
• title: General title of candle stick chart. In case data is symbol, title going to be default according to cloned data.
• xlab: x label. Default Date.
• ylab: y label. Default Price.
• start_date: start date. Default None. Must to be declared when data is symbol.
• end_date: end date. Default None. Must to be declared when data is symbol.
• colors: list colors defines increasing and decreasing color stick candle in order.
• width: with of plot frame. Default 800px
• height: height of plot frame. Default 600px
• show_vol: is show volume of stock price?
• data_source: invalid when use symbol intead of data frame. Source to clone data, 'VND' or 'CAFE'.

3.1. Visualization from source VND or CAFE

In this way, you can visualize stock price clone from VND or CAFE source by pass symbol, start_date, end_date into module as below:

from vnquant import Plot
Plot._vnquant_candle_stick(data='VND',
                           title='VND stock price data and volume from 2019-09-01 to 2019-11-01',
                           xlab='Date', ylab='Price',
                           start_date='2019-09-01',
                           end_date='2019-11-01',
                           show_vol=True)

You can suppress volume by set up show_vol=False. Result as below:

3.2. Visualization from data frame

Data frame must be OHLC or OHLCV type. OHLC type when it includes ['open','high','low','close'] and OHLCV is ['open','high','low','close','volume']. In case your data frame have columns with the same function, you should accordingly rename its.

from vnquant import Plot
Plot._vnquant_candle_stick(data = data_vnd,
                      title='Your data',
                      ylab='Date', xlab='Price',
                      show_vol=True)

To check whether data_vnd frame is OHLC or OHLCV type you can try:

from vnquant import utils
print(utils._isOHLC(data_vnd))
print(utils._isOHLCV(data_vnd))

Return True mean data frame is adapted types.

4. Clone Stock Prices: (0.0.1)

You can load the prices of one or more stocks in specific time interval according to syntax as below.

from vnquant.DataLoader import DataLoader

DataLoader(symbols="VND",
           start="2018-01-10",
           end="2018-02-15",
           minimal=True,
           data_source="cafe")

Arguments

• symbols: a string or list of strings indicate the stock names. The stock symbols in regular include 3 upper case letters except several special index such as: E1VFVN30, VN100-INDEX, HNX-INDEX, HNX30-INDEX, UPCOM-INDEX in case your data_source = "cafe" and VN30, HNX30, UPCOM in case your data_source = "vnd".
• start: start date time with format yyyy-mm-dd.
• end: end date time with format yyyy-mm-dd.
• minimal: default is True, we only clone high, low, open, close, adjust price, volume of stocks. In contrast, more information is added, for example volumn_reconcile, volumn_match,...
• data_source: the source to clone the stock prices. Currently, there two main resources are Vndirect and Cafef showed by data_source = vnd and cafe, respectively. The default is vnd.

4.1. Clone one stock:

import vnquant.DataLoader as web
loader = web.DataLoader('VND', '2018-02-02','2018-04-02')
data = loader.download()
data.head()

Attributes	high	low	open	close	avg	volume
Symbols	VND	VND	VND	VND	VND	VND
date
2018-02-02	28.95	27.60	28.5	28.95	28.28	1700670.0
2018-02-05	28.45	26.95	28.1	26.95	27.68	2150120.0
2018-02-06	26.95	25.10	25.1	26.40	25.25	3129690.0
2018-02-07	28.20	27.50	27.5	28.20	27.99	1985120.0
2018-02-08	29.20	27.70	28.0	28.00	28.47	943260.0

4.2. Clone more stocks:

We need to set up symbols as a list.

loader = web.DataLoader(symbols=["VND", "VCB"], start="2018-01-10", end="2018-02-15", minimal=True, data_source="cafe")
data = loader.download()
data.head()

Attributes	high		low		open		close		avg		volume
Symbols	VND	VCB	VND	VCB	VND	VCB	VND	VCB	VND	VCB	VND	VCB
date
2018-01-10	27.75	59.2	27.10	57.3	27.55	58.3	27.50	58.0	27.52	58.08	1466780.0	2842830.0
2018-01-11	27.50	58.8	26.80	57.2	27.30	57.5	27.20	58.8	27.21	58.04	1260720.0	1766240.0
2018-01-12	28.20	59.4	27.35	58.0	27.45	58.8	27.60	58.0	27.76	58.63	1730170.0	2525840.0
2018-01-15	28.40	60.0	27.35	57.0	27.60	58.0	28.25	60.0	28.11	58.76	1273740.0	2217420.0
2018-01-16	28.40	60.3	27.90	58.8	28.10	59.3	28.25	60.0	28.14	59.64	1163350.0	2218380.0

4.3. Clone full information:

To get more the others information about volume and value beside basical fields, we need to declare minimal=False (default True).

loader = web.DataLoader(symbols=["VND"], start="2018-01-10", end="2018-02-15", minimal=False)
data = loader.download()
data.head()

Attributes	change_perc1	change_perc2	open	high	low	close	avg	volume_match	volume_reconcile	volume
Symbols	VND	VND	VND	VND	VND	VND	VND	VND	VND	VND
date
2018-01-10	0.00	0.000000	27.55	27.75	27.10	27.50	27.52	1382780.0	84000.0	1466780.0
2018-01-11	-0.30	0.010909	27.30	27.50	26.80	27.20	27.21	1260720.0	0.0	1260720.0
2018-01-12	0.40	0.014706	27.45	28.20	27.35	27.60	27.76	1730170.0	0.0	1730170.0
2018-01-15	0.65	0.023551	27.60	28.40	27.35	28.25	28.11	1273740.0	0.0	1273740.0
2018-01-16	0.00	0.000000	28.10	28.40	27.90	28.25	28.14	1077350.0	86000.0	1163350.0

Through this project, i hope you make your work being more covinient and easy by applying them. Though try hard, but there are many drawback, kindly comment and send me feed back to implement my project.

5. Get finance, cashflow, business and basic index reports (0.0.3)

In version 0.0.3 you can download finance, cashflow, business and basic index reports with class vnquant.DataLoader.FinanceLoader. Currently, we only support you clone one symbol per each time. To use this class you import as bellow:

import vnquant.DataLoader as dl
loader = dl.FinanceLoader(symbol = 'VND', 
                          start = '2019-06-02',
                          end = '2021-12-31')

Arguments

• symbol: a string indicates the stock name. The stock symbol in regular includes 3 upper case letters.
• start: start date time with format yyyy-mm-dd.
• end: end date time with format yyyy-mm-dd.

5.1. Get finance report

Function get_finan_report() will help you get these finance indexes. For example:

import vnquant.DataLoader as dl
loader = dl.FinanceLoader('VND', '2019-06-02','2021-12-31')
data_finan = loader.get_finan_report()
data_finan.head()

	2021-06	2021-03	2020-12	2020-09	2020-06	2020-03	2019-12	2019-09	2019-06
index
Tài sản ngắn hạn	21351441834807	17347112129802	12793253609747	11585099253268	11479005695043	10851511570130	11239350733660	11059560981795	10590145635691
Tài sản tài chính ngắn hạn	21339567743512	17332349291032	12770938291296	11570420145910	11465268994352	10826493556341	11222476803929	11036102039564	10550582164047
Tiền và các khoản tương đương tiền	1153684350307	590663521250	595786368281	175314778804	185532378242	368330609085	613548205346	298144380199	413837038988
Tiền	778884350307	460708745512	509970753138	141314778804	148847077857	346330609085	611548205346	158744380199	252137038988
Tiền gửi của người đầu tư về giao dịch chứng khoán	0	0	0	0	0	0	0	0	0

5.2. Get business report

To get business report of each symbol, you use get_business_report() function as below:

import vnquant.DataLoader as dl
loader = dl.FinanceLoader('VND', '2019-06-02','2021-12-31', data_source='VND', minimal=True)
data_bus = loader.get_business_report()
data_bus.head()

	2021-06	2021-03	2020-12	2020-09	2020-06	2020-03	2019-12	2019-09	2019-06
index
Lãi từ các tài sản tài chính ghi nhận thông qua lãi/lỗ ( FVTPL)	384484114460	446903481873	348445083732	177846582328	126873424297	112699410946	69471930133	100788177914	96112568053
Lãi bán các tài sản tài chính PVTPL	187329856826	258061271830	321502700913	126020773731	120870780627	121996865833	77348559746	70332267851	62535937574
Chênh lệch tăng đánh giá lại các TSTC thông qua lãi/lỗ	192578271638	188425144043	-8160509655	33713693597	-848309517	-10832424389	-13633761575	28457177453	15139720013
Cổ tức, tiền lãi phát sinh từ tài sản tài chính PVTPL	4575985996	417066000	35102892474	18112115000	6850953187	1534969502	5757131962	1998732610	18436910466
Lãi từ các khoản đầu tư nắm giữ đến ngày đáo hạn	24948288940	108779296202	98753552528	84000482631	84108399683	105941161289	107029644615	100310037665	120061106620

5.3. Get cashflow report

Function get_cashflow_report() shall support to clone cashflow report:

import vnquant.DataLoader as dl
loader = dl.FinanceLoader('VND', '2019-06-02','2021-12-31', data_source='VND', minimal=True)
data_cash = loader.get_cashflow_report()
data_cash.head()

	2021-06	2021-03	2020-09	2020-06	2020-03	2019-12	2019-09	2019-06
index
Điều chỉnh cho các khoản	117772457799	102102918502	39938806717	-2179656198	189614451308	77119446501	115901816119	310400347299
Chi phí khấu hao tài sản cố định	7121178573	5117724702	5200320730	4817922370	5082314726	4956658731	5024428635	5218835903
Phân bổ lợi thế thương mại	0	0	0	0	0	0	0	0
Dự phòng giảm giá các khoản đầu tư ngắn hạn, dài hạn	15351994938	7673582615	-50406427024	-97302010585	74769599906	-47666085953	-1958363587	194803059759
Lãi, lỗ chênh lệch tỷ giá hối đoái chưa thực hiện	2291430861	0	-855383375	-855383375	0	-535741671	-136318575	136318575

5.4. Get basic index report

This function provide to you basic and important index of each symbol such as: ROA, ROE, Net Profit Marget, Net Revenue Growth, Profit After tax Growth

import vnquant.DataLoader as dl
loader = dl.FinanceLoader('VND', '2019-06-02','2021-12-31', data_source='VND', minimal=True)
data_basic = loader.get_basic_index()
data_basic.head()

	2020-12	2019-12
index
Profit After Tax Growth (YoY)	0.810405	0.025519
Net Revenue Growth (YoY)	0.421240	-0.023797
Net Profit Margin (Yr)	0.324553	0.254787
ROE last 4 quarters	0.195974	0.123374
ROA last 4 quarters	0.053917	0.033224

Download Details:
Author: phamdinhkhanh
Source Code: https://github.com/phamdinhkhanh/vnquant
License:

#pandas 

What is GEEK

Buddha Community

Your Data Architecture: Simple Best Practices for Your Data Strategy

If you accumulate data on which you base your decision-making as an organization, you should probably think about your data architecture and possible best practices.

If you accumulate data on which you base your decision-making as an organization, you most probably need to think about your data architecture and consider possible best practices. Gaining a competitive edge, remaining customer-centric to the greatest extent possible, and streamlining processes to get on-the-button outcomes can all be traced back to an organization’s capacity to build a future-ready data architecture.

In what follows, we offer a short overview of the overarching capabilities of data architecture. These include user-centricity, elasticity, robustness, and the capacity to ensure the seamless flow of data at all times. Added to these are automation enablement, plus security and data governance considerations. These points from our checklist for what we perceive to be an anticipatory analytics ecosystem.

#big data #data science #big data analytics #data analysis #data architecture #data transformation #data platform #data strategy #cloud data platform #data acquisition

Stock Market Betting Software Development | Stock Market Betting Solutions

Mobiweb Technologies is considered as an expert stock market betting software development company that offers an extensive and wide coverage betting software to empower the bettors. Our Team of top level management and expert sports betting software developers design unbeatable software development strategies that compete with other betting software in the market. People who believe in investment consider gambling as a source of profit generation and for this, Mobiweb’s betting software offers one touch betting facility to place the wager. Most importantly, it offers best-in-class user experience and provides a user engaging atmosphere. If you are looking for developing stock market betting software then you don’t need to hesitate, give this opportunity to Mobiweb and get on time delivery of your project under minimum possible cost.

#stock market betting software development #stock market betting software #stock market betting app development #stock market betting app developers #stock market betting software providers

Data Is The New Marketing Currency

Brands today are differentiated by how well they know their customers and craft campaigns that are intuitive and useful for the end-customer. Data does exactly that and enhances the efficacy of marketing campaigns. Data-led insights give us the liberty to investigate the diversity of user behaviour and understand our customer base more intimately. The barrage of data created online every day is amplifying at a magnificent rate. The lack of an effective tool can confound marketers and even diminish the data’s utility because of failed attempts to integrate the widespread information.

Sitting on a deluge of fragmented, disconnected data pointers is counterproductive to growth. Marketers are losing sleep trying to figure out ways to help their businesses create a single source of truth. The solution is to decentralize data silos, make them accessible to multiple business users and enable marketing teams to create engaging marketing campaigns.

The need for an intelligent CDP is urgent

The rise of Customer Data platforms has been sharp, thanks to modern marketing solutions that rely heavily on data-driven campaigns. A CDP acts as a singular storefront for data residing on multiple fronts (CRM, legacy marketing solutions, analytics platform, DMP). CDP pools customer data into one place for marketers to get a 360-degree view at any given point in time. This helps marketing and product teams rely on a single source of truth for understanding consumer behaviour.

There are several solutions out there that will help you assimilate your data to create a data warehouse, data lake, or similar sounding fancy names. But, this isn’t enough to help you scale your marketing and engagement efforts. A CDP is essentially incomplete without the ability to govern data, create dynamic segments and use this data seamlessly in campaigns, and lastly, creating up-to-date profiles for users: known and unknown.

An efficient CDP will facilitate data mobility, pull data from multiple sources and send it to other platforms. The consolidation of user-profiles will help track the whereabouts of known and unknown users. Marketers then will be able to act on this and design a relevant communication strategy for the users.

All the data is then used intelligently to create small customer segments, which is leveraged across omnichannel campaigns. This allows marketers to deep dive into multiple use cases in a customer lifecycle. Context is King! This adage summarizes the final step, insights. The incredible insights from intelligent campaigns contribute to faster decision-making and carve out marketers’ next steps.

#opinions #data for marketers #data for marketing #marketers #marketing #data

Getting Started With Data Lakes

Frameworks for Efficient Enterprise Analytics

The opportunities big data offers also come with very real challenges that many organizations are facing today. Often, it’s finding the most cost-effective, scalable way to store and process boundless volumes of data in multiple formats that come from a growing number of sources. Then organizations need the analytical capabilities and flexibility to turn this data into insights that can meet their specific business objectives.

This Refcard dives into how a data lake helps tackle these challenges at both ends — from its enhanced architecture that’s designed for efficient data ingestion, storage, and management to its advanced analytics functionality and performance flexibility. You’ll also explore key benefits and common use cases.

Introduction

As technology continues to evolve with new data sources, such as IoT sensors and social media churning out large volumes of data, there has never been a better time to discuss the possibilities and challenges of managing such data for varying analytical insights. In this Refcard, we dig deep into how data lakes solve the problem of storing and processing enormous amounts of data. While doing so, we also explore the benefits of data lakes, their use cases, and how they differ from data warehouses (DWHs).

---

This is a preview of the Getting Started With Data Lakes Refcard. To read the entire Refcard, please download the PDF from the link above.

#big data #data analytics #data analysis #business analytics #data warehouse #data storage #data lake #data lake architecture #data lake governance #data lake management

Future of Marketing: How Data Science Predicts Consumer Behavior

The outbreak of COVID-19 has shaken every industry thereby influenced the preferences and priorities of consumers. During the pandemic, those business models who adapted to the change survived while others got lost in the thin air. Gradually, as the post-pandemic phase arrived, one thing that helped marketers predict their consumer behavior was Data Science

#data-science #consumer-behavior #marketing #big-data #data #data-analysis #data-visualization #data-analytics