Hey everyone,
I'm using Excel 2010 and I want to write VBA code for excel that will return the income statement from stockhouse.com on a sheet called "IncomeStatement" from the ticker symbol entered in d6 on a sheet called "Imput".
So basically if I enter GOOG d6 and then click my command button tied to VBA I want it to retrieve the income statement for google from:
http://www.stockhouse.com/tools/?pag...ubnav%3Dincome
and enter it into the "IncomeStatement" sheet.
I know it would probably be easier to download some addon but I'd like to get around that if possible.
Thanks a ton for any help anyone could offer.
I all I not sure how I should be doing this.
Right now I working on a work order system in excel with 3 work sheets.
So one the first worksheet is called workorder I have a field called materials and a other work sheet called parts that have all my part names and pricing.
So the materials field takes up c20 to c 44 and pricing takes up cells e20 to e 44, and on worksheet parts the info is in cells a8 to a76 and the prices are in parts cells c8 to c76
So what I have done in the materials field I have use data validation with =indirect to fill these cells with the right parts names.
it looks something like this =indirect("Parts!$A$8:$A$76") this works great and I have it in a list format with a drop down button.
The problem I am having now is the next cell over on the first workbook is the materials work now I want pricing based on the material or part name which is on another worksheet where I got the part names from.
I not sure if I should write an if statement or and array or vlookup any help would be great
So what I am trying to do is after selecting my materials in cell c20 I want the price to fill in as well in e20 but the data is on another sheet same work book can anyone suggest anything
thanks
I plan to open a G/L chart of accounts table in one workbbook.
In a second workbook I plan to set up an income statement template. To begin I will keep it simple. Column one is name.
Column two the amount summed from the second workbook containing the G/L table.
What formula do I use in the cell of my income statement template when the value I wish to sum is represented by more than one G/L account? In otherwords let's say I need to sum the financial data in column G when the G/L account number in column A is one of 5 possible account numbers. I have tried sumproduct but it doesn't seem to allow for a list of G/L accounts.
e.g.
Sum the Sales Income for sales accounts 4000, 4002, and 4020 into cell J20.
Sum the value from the monthly sales column (G) if the account number in column (A) has the value of Account# 4000 or 4002 or 4020 ( these values happen to be strings ) and put the sum into my Income Statement workbook corresponding cell (J20).
Thanks for your help
Pinny
I am trying to find out a way to enter a stock ticker into any cell on my spreadsheet, and excel to automatically pull the financial information from the web. I can do this one stock at a time through a web query but would like to be able to insert a ticker and get that companies information.
Thanks for the help.
I am a treasurer of a sports club and would like to use Excel to prepare and
print Balance sheets and year end statements of income and expenditure.
If I want to project my income or cost for Nov. or Dec. and have values in
the other months, how can I project what my income or cost would be for
November or December based on the other months?
I need an example of a multi business segment income statement for use in
studies at Ohio State.
I need an example of a multi business segment income statement for use in
studies at Ohio State.
Hi guys, thought i would share this Income and Expenditure form i have just finished with the help of these forums.
It would be used in the financial sector mainly, and uses government standard guideline figures, calculates totals, makes use of macros and argumented IF's and looks very clean and easy to understand/use.
Enjoy
I am new to excel and am trying to figure out how to build up a spreadsheet
that would calculate my monthly or even yearly income. I would like to
include this data
Client Name
Dates or months (I can fill this in)
Amount paid
I would love to have the spreadsheet do the calculations for me,
I need help
Lizette
liznnate10@yahoo.com
