Saturday, November 12, 2016

Record: How to change Firefox menu language

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

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

Thursday, March 3, 2016

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.


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.

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.


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,