The following site explains how to change Firefox language from one to another
https://support.mozilla.org/en-US/questions/1018686
Steps:
1) on url, type "about:config" (without quote)
2) type "intl.locale.matchOS" (without quote)and set the value to "false"
3) download language pack (up to you)
4) type "general.useragent.locale" (without quote); double click and then change the language type code
Saturday, November 12, 2016
Sunday, October 16, 2016
Get Stock Historical Data From Yahoo Finance - English + Cantonese Caption (Eng Narration)
Just make a video on this simple technique to grab stocks historical data from Yahoo Finance.
Brief steps are listed below:
Before using your Jupyter Notebook from Anaconda:
1) Conda install pandas-datareader
When you get into Jupyter Notebook:
2) Import all the libraries (datareader, datetime, matplotlib)
3) define date (start & end) as well as the searching method (e.g. yahoo), refer to videos for details
4) ready for plotting and other coding
Tuesday, March 8, 2016
Pandas for Finance
This tutorial walks through the Series and DataFrames functionality of Pandas.
This tutorial is suitable for beginners.
http://quant-econ.net/py/pandas.html
This tutorial is suitable for beginners.
http://quant-econ.net/py/pandas.html
Thursday, March 3, 2016
Using Aggregate function to calculate Median of data based on certain condition
Just saw this video ...
It's very useful for stock/index fluctuation estimation.
It's very useful for stock/index fluctuation estimation.
Friday, February 26, 2016
Using Excel to Recognize Cashflow Pattern
Just link to Exelisfun's YouTube video on using Excel to to recognize cashflow pattern.
This technique can be a great tool for accountants.
This technique can be a great tool for accountants.
Thursday, February 18, 2016
Python Working With Excel - Creating Advanced Excel Workbooks
Just found the following article on Python and Excel:
http://pbpython.com/advanced-excel-workbooks.html
This article talks about:
1) create Excel workbook
2) merge Excel workbook
3) insert VBA
Please visit the above page for details.
Hope it helps all learners.
http://pbpython.com/advanced-excel-workbooks.html
This article talks about:
1) create Excel workbook
2) merge Excel workbook
3) insert VBA
Please visit the above page for details.
Hope it helps all learners.
Monday, February 15, 2016
Multilingual Excel Accounting Template (Foundation File)
Introduction
This is part1 of the multi-lingual Excel accounting template.Such template is designed for building a complete accounting system in Excel.
This template is pre-built with English, Traditional Chinese, and Japanese.
You can add your own language(s) by altering the "LangList" and "FieldList" tab in this file
What's in the file
1) Chart of Account
2) Bookkeeping interface (Source data input worksheet with dummy records for illustration purpose)
3) Other daily bookkeeping reports (debtors and creditors' list)
4) List of banks (with dummy records for illustration purpose)
Road Map
1)->Daily Bookkeeping records (this file)
2)-> Journal Entries **
3)-> Reports ** (e.g. financial statements, tax schedules, analytical reports, audit work schedules, and many others)
Please note that part (2) and (3) are considered professional work, which has to be performed by certified professional in many jurisdictions.
Therefore, my tutorials on DIY of part (2) and part (3) are just MY SHARINGS and contains NO ADVISORY element on your accounting system creation.
** tutorial videos will be shot, assuming part (1) (this template file) was downloaded and respective data were filled in prior to further accounting system creation.
** tutorial videos will be shot, assuming part (1) (this template file) was downloaded and respective data were filled in prior to further accounting system creation.
Disclaimer
All contents* are created for education purpose.
Accuracy and completeness of contents are not guaranteed.
Use this template at your own risk.
Download the basic version (has been discontinued ).
*not limited to formulas, cell values, description translations, and any other formats of contents,
Labels:
clueple,
Excel Accounting Template,
Multilingual
Subscribe to:
Posts (Atom)