Automatically update Google Finance stock prices, pivot table, sparklines, + multiple charts per page. - open to bidding

Closed

Description

Using GoogleFinance Spreadsheets (not Excel), Sheet1 will store uploaded stock price data from GoogleFinance & store daily incremental price changes automatically. Approx 100 symbols. Sheet2 will present the data.

Initially ultra simple. I can send you a file of what I achieved so far, most of the above inc Sparklines, but it is not in pivot table format.

What I do is identify a market low point for the sector (27 June 2013 was the last one) then create %Change columns to show %Ch for all stocks for selected event dates as they present themselves ie intermediate market turns. Then I sort %Ch columns 1,2,3 etc to rank all the symbols in order of %Ch from their corresponding prior dates. Right now, from the 27 June low the sector I'm analyzing is coming down off a Dead Cat Bounce so things are approaching a critical point. Most symbols are still above the 27 June low, quite a few are below the Aug 7 low. T

The SPARKLINES are nice and they work well enough for a tiny visual display. Their real usefulness comes in when you increase the height of the row of the Sparkline you want to magnify. Then they are work great. But this is clunky and needs improvement.

What I'd like is to click on a Sparkline image and it resizes automatically to say 12cm x 7cm. A second click on the image would return it and the row to original size, or, clicking a second Sparkline while the first one is magnified would return the first to original size and magnify the second one. Ideally you could have several choices of Sparkline period, Daily, Weekly, Monthly, One Year.

I know you can do the pivot table. Do you think you can do the Sparklines?

Look forward to hearing from you

Regards

Anthony

Skills: Data Entry, Excel, Graphic Design, Russian, Web Search

See more: stock charts, pivot design, intermediate excel, graphic design is dead, graphic design finance, graphic design charts, graphic design ch, graphic data display, format prices, daily finance, critical graphic design, bounce graphic design, market prices, stock update, stock market data, stock image, pivot table excel, image format to excel, google spreadsheets, google ch, finance simple, finance in excel, finance excel, finance excel data, finance d

Project ID: #5003859

3 freelancers are bidding on average $254 for this job

SigmaVisual

Dear Client, I can help in your project. We have already experience of working on similar projects. Please see below to get idea of our experience: Amazon/Ebay Bots: http://sigma-dns.sigmavirtual.com/PDemo1/Am More

$206 USD in 5 days
(38 Reviews)
6.2
inoussakabore

Look at my profile, this is my job. i can do that for you. Don"t look at my bid but look at the quality of job i can do for you. I am ready to start.

$400 USD in 5 days
(1 Review)
3.2
kulatir03

i'm interested in this project i am familiar to stock market because i have investment there. I can read technical analysis charts and familiar in RSI,MACD,and the popular five waves of Elliott,etc. Willing to work for More

$155 USD in 3 days
(0 Reviews)
0.0